Excel Stacked Area Chart with Data Table and Totals

Question

In my Stacked Area chart, I want to include the Legend Keys with a total line in the table below the Stacked Area chart. But I do not want the total line to be part of the Stacked Area chart itself. I found an example of one that displays what I would like it to look like and I attached it. The Total line at the bottom I outlined in red. You see it totals the table, but is not included in the Stacked Are chart itself.

Answer 1

Here is an old trick from Chart/Data Table Total Row

Step 1: create a chart including the totals:

Step 2: select the Total series.

On the Format tab of the ribbon, under Chart Tools, click 'Format Selection'.

a) Under Series Options, plot the series on the Secondary Axis:

b) Under Fill & line, set the series to use No Fill and No Line:

The Total series is now completely invisible, but still shown in the Data Table:

Answer 2

Thank you so much, that worked perfectly.