Change Legend Entry label of "Total" to actual name of field.

[J.W. Aldridge]

I have two pivot charts. One has multiple criteria and when I create a
pivot chart, each series field breaks out properly using the names
provided in the multiple criteria given.

Now, the issue is when I have a single (one) field name, the chart
automatically has the legend entry of "Total" since I am using the
'sum of' option. I've manually changed the name of the field in the
pivot table, but the label on the chart remains the same. I've go so
far as to read several tips on going to the source data to change this
but of course when working with pivot tables, you cannot access the
source data.

Any ideas? I need to change the name.

Thanx

 

[Herbert Seidenberg]

Excel 2007
Pivot Tables, Pivot Charts, Labels
This puts your custom sum label into the title.
Also applies to report filter.
http://www.mediafire.com/file/twyzdju3wrz/02_05_09.xlsm