Forum Discussion
Adding Grand Total column in a Stacked Column Chart
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!
3 Replies
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
Oh shoot! Thanks for pointing that out. My mistake and yes I am on MS Office 365. Riny_van_Eekelen
Use multiple tables to create a PivotTable
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.
.JPG){kind=link}