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...
The way to simply change the text in a PivotChart LEGEND is to 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.