#How to change text in excel legend series
The Series name box contains the address of the cell from which Excel pulls the label. The Edit Series dialog window will show up. In the Select Data Source box, click on the legend entry you want to change, and then click the Edit button. Right-click the legend, and click Select Data 2. Note that within the legend object, alignment of columns depends on the Align Columns check box (on by default) in the Text Object dialog box, Text tab (right-click on the legend object and choose Properties from the shortcut menu). Here are the steps to change the legend labels: 1. Press CTRL and drag to re-arrange the legend. Click on the series you want to edit, click Edit, and you will have another box with the option to change the series name.Select the legend in order to show up the legend border. At the top of the Element pane, click the drop-down arrow next to the Legend text and select a text item from the list.On the Text tab of Text Object dialog, make your selection from the Alignment drop-down list.įor those seeking a greater degree of control over legend alignment, see Legend Element Alignment. Click on the legend object, right-click and choose Properties.
![how to change text in excel legend how to change text in excel legend](https://support.content.office.net/en-us/media/6d872784-9c25-4438-bf93-208c71970800.png)
![how to change text in excel legend how to change text in excel legend](https://www.getbasicidea.com/wp-content/uploads/2021/01/Legend-in-Excel-7.png)
Rather than show each series I would prefer to list the name of each project in Series 1 in the Chart Legend. The HasLegend text defaults to Series 1, Series 2, Series 3.