Question Locked

Access Pivot Charts - change Legend Entry titles

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

My legend series titles show as "Sum of Management Query". What I'd like for it to show is "Management". How can I change this?

Jen

4 replies

by plunavat

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.

by rachelteneyck

I've used the create pivot chart tool and don't have the option to switch to Pivot Table View. How else can the legend be changed??

by tonyluke

Thanks for that, I've been searching all over the net to be able to find out how to do this.

This discussion is closed to new replies.