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...
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
.JPG){kind=link}
Oh shoot! Thanks for pointing that out. My mistake and yes I am on MS Office 365. Riny_van_Eekelen