Adding Grand total to Pivot Chart Table

[Dineshkumar Palanisamy K]

I have a Pivot chart which has Table in it. I need to add the total to the end of the table. Please help me to get it resolved.


Pivot table

Pivot Chart

Need to add the total at the end as shown down

 

[Domenic]

I would suggest that you copy the data from your pivot table, paste it into another location, and then create your chart from there. And, if new data gets added to the source range, then simply refresh and repeat the same process. All this can be done automatically using the TableUpdate event handler.