Adding Grand Total column in a Stacked Column Chart

%3CLINGO-SUB%20id%3D%22lingo-sub-1672895%22%20slang%3D%22en-US%22%3EAdding%20Grand%20Total%20column%20in%20a%20Stacked%20Column%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1672895%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day%20all!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20stacked%20column%20chart%20from%20my%20pivot%20table.%20There%20is%20a%20%22Grand%20Total%22%20column%20which%20in%20the%20Pivot%20Table.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EWhat%20I%20want%20to%20do%20is%20since%20my%20pivot%20table%20contains%20quite%20a%20lot%20of%20big%20amounts%2C%20I%20simply%20want%20to%20show%20the%20total%20for%20each%20column%20at%20the%20top.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20right-clicked%20on%20the%20chart%20and%20clicked%20on%20%22SELECT%20DATA%22.%20The%20option%20to%20%22ADD%22%20is%20inactive%20which%20means%20I%20cannot%20add%20anything.%20I%20have%20fiddled%20with%20it%20for%20a%20bit%20but%20still%20unable%20to%20solve%20this.%20Any%20ideas%20will%20be%20really%20welcome!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20a%20screenshot.%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1672895%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1672990%22%20slang%3D%22de-DE%22%3ESubject%3A%20Adding%20Grand%20Total%20column%20in%20a%20Stacked%20Column%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1672990%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F677879%22%20target%3D%22_blank%22%3E%40NoviceKB%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%224%22%3EUse%20multiple%20tables%20to%20create%20a%20PivotTable%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fuse-multiple-tables-to-create-a-pivottable-b5e3ff48-2921-4e29-be15-511e09b5cf2d%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Foffice%2Fuse-multiple-tables-to-create-a-pivottable-b5e3ff48-2921-4e29-be15-511e09b5cf2d%3Fui%3Den-us%26amp%3Brs%3Den-gb%26amp%3Bad%3Dgb%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1673220%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20Grand%20Total%20column%20in%20a%20Stacked%20Column%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1673220%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F677879%22%20target%3D%22_blank%22%3E%40NoviceKB%3C%2FA%3E%26nbsp%3BAlthough%20you%20labelled%20your%20question%20%22Excel%20on%20Mac%22%2C%20your%20picture%26nbsp%3Bsuggest%20you're%20on%20a%20PC%20version%20of%20Excel.%20The%20following%20link%20explains%20how%20you%20can%20add%20grand%20totals%20to%20a%20Pivot%20Chart.%20Using%20CUBE%20functions%20or%20via%20a%20regular%20chart%20based%20on%20data%20linked%20to%20pivoted%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.myonlinetraininghub.com%2Finclude-grand-totals-in-pivot-charts%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.myonlinetraininghub.com%2Finclude-grand-totals-in-pivot-charts%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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 

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.

@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