Forum Discussion

UmarNayab's avatar
UmarNayab
Copper Contributor
May 11, 2023
Solved

How to Add Grand Total in Pivot Chart Colum Bar ?

Hi Experts, 

 

I have a scenario in pivot, Which goes as below, 

 

Region         Count

 A                    1

 B                    2

 C                    3

Grand Total     6 

 

 

Now i am creating a Stacked Column chart, where i want  Chart bars to show values of Region i.e A , B & C along with Grand Total Bar (Total 4 Bars in chart instead of 3 of region) 

 

How to Execute this in Excel? 

Note: I cannot make any changes to my pivot source. 

Please Advise.

6 Replies

Resources