Adding Grand Total column in a Stacked Column Chart

[NoviceKB]

Good day all!

I have a stacked column chart from my pivot table. There is a "Grand Total" column which in the Pivot Table.

What I want to do is since my pivot table contains quite a lot of big amounts, I simply want to show the total for each column at the top.

I right-clicked on the chart and clicked on "SELECT DATA". The option to "ADD" is inactive which means I cannot add anything. I have fiddled with it for a bit but still unable to solve this. Any ideas will be really welcome!

Attached a screenshot. Thanks!

[#2]

@NoviceKB 

Use multiple tables to create a PivotTable

https://support.microsoft.com/en-gb/office/use-multiple-tables-to-create-a-pivottable-b5e3ff48-2921-...

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

[#3]

@NoviceKB Although you labelled your question "Excel on Mac", your picture suggest you're on a PC version of Excel. The following link explains how you can add grand totals to a Pivot Chart. Using CUBE functions or via a regular chart based on data linked to pivoted data.

https://www.myonlinetraininghub.com/include-grand-totals-in-pivot-charts 

[#4]

Oh shoot! Thanks for pointing that out. My mistake and yes I am on MS Office 365.  @Riny_van_Eekelen