Hi,

I have a pivot chart that is a pie chart from a pivot table that has sums of multiple fields. So, I want to be able to put the total either in the title after the name or somewhere in the chart.

For example, I have the names in the column (6 names so 6 columns). The rows for my pivot table are the sum of each source (15 rows total). I created a filter using another pivot chart and slicers to filter by name. So when I choose a name, I see in my pie chart the number of each source. So, say I filter for John Smith. The pie chart will only show John Smith and only the sum of the sources under him. So lets say, website is 7 and board is 3 and search is 5. I want the total (15) to show up on the pie chart either in the title after the name (John Smith - 15) or somewhere on the chart.

Sorry for the terribly long explanation. I am not even sure if this is possible for a pivot chart.

As always, your help and suggestions are greatly appreciated.

Thank you!