Simple way to change/remove the "Sum of..." text, or any text, in a PivotChart LEGEND. I searched other sites for many hours and could find no help on this subject...a co-worker stumbled upon the solution. To change the text in a PivotChart LEGEND, switch from PivotChart View to PivotTable View. Then click once to highlight the field name that reads "Sum of...", then go to properties, when the properties dialog box displays select the "caption" tab, now go to the item titled "caption" and simply type in the new text you would like reflected in your Legend. Switch back to PivotChart View and you will see the Legend has changed.
Email This FAQ To A Friend