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

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

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
 
Back
Top