Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Modify Chart Legend Entries. The index number represents the position of the legend entry in the legend. To change the text in a PivotChart LEGEND switch from PivotChart View to PivotTable View.
Legend Entry Tricks In Excel Charts Peltier Tech from peltiertech.com
Right-click on the Chart and click Select Data then edit the series names directly as shown below. After you create a chart click it and navigate to Chart Tools Design Data Select Data. This displays the Chart Tools adding the Design Layout and Format tabs.
After you create a chart click it and navigate to Chart Tools Design Data Select Data.
Click Select Data on the toolbar. LegendEntries 1 is at the top of the legend. By default the Field List pane will be opened when clicking the pivot chart. Right-click on the Chart and click Select Data then edit the series names directly as shown below.
