In Excel I have a stacked bar chart like this:
for which I want to add a trendline for the total (ie the full vertical bar).
The instructions I have found are for old Excel versions. One problem (apart from the different menu options) is that, if I add a total column, Add Trendline remains greyed out.
How can I add a trendline to a stacked bar chart with modern Excel?