Forum Discussion
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.
Maybe this: a calculated item and and some creative formatting.
6 Replies
- Patrick2788Silver Contributor
If this is what you need:
You could create a calculated item for the 'region' and disable the Grand Total on the pivot.
- UmarNayabCopper Contributor
Hi Patrick, Thank You for your reply.
Tried As mentioned below, unable to get desired output. Kindly check on screen shot attached. I am missing something... Please Advise
- Patrick2788Silver ContributorIt looks like you're using a Calculated Field rather than a Calculated Item. If you're able to attach the workbook, I can take a look.