CODEWITHSUNDEEP
excelpivot
Orkhan Orkhan
Orkhan Orkhan

Reputation: 105

Adding total numbers(Grand Total) in pivot chart

I need help in adding the total numbers on pivot table as in the picture below. Any kind of help would be highly appreciated.

enter image description here

I have tried everything but was not able to make it reflected on the chart.

Regards

Upvotes: 0

Views: 4032

Answers (1)

M.Douda
M.Douda

Reputation: 574

Only way that I can think of is not very elegant but it should do what you want. Create a formula in a cell that gets data you need from the pivot table, it should be ok to just write in "=" and click on the cell and Excel should write down the GETPIVOTDATA formula for you. After that you just create a text box and write "=(adress of the cell) in the formula bar while you have the text box selected.

Hope that helps

Upvotes: 2

Related Questions