Add Grand Total to Pivot Graph Legend

[relswatch]

Hello,

I created a Pivot Graph and I need to show the grand total for each column as part of the Legend.
Now the Legend only shows the names of the columns which are In Progress, Launched and On hold, but I would need it to show as follows:
In Progress 93
Launched 29
On Hold 2

Is that possible?

Thanks,

[sandy666]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[relswatch]

I have attached an example. I included two graphs one showing the actual results and one named Wanted Result that shows how I would like the legend to appear. Thanks

[xlnitwit]

Hi,

You could use some code- right click the worksheet tab, choose 'View Code' and copy this in to the window that appears

Please Login or Register  to view this content.

and finally refresh your pivot table.

[relswatch]

Thank you very much. It works perfectly.
The only thing is that I have multiple pivot tables in the same table.
How can I make sure the code only applied to the pivot table I want?
Is there a way to specify in the code which pivot table that it?

[xlnitwit]

Yes, you could test the name

Please Login or Register  to view this content.