Change legend names - Microsoft Support (2024)

FAQs

Change legend names - Microsoft Support? ›

On the Design tab, in the Data group, click Select Data. In the Select Data Source dialog box, in the Legend Entries (Series) box, select the legend entry that you want to change. Click Edit. Tip: To add a new legend entry, click Add, or to remove a legend entry, click Remove.

On the Design tab, in the Data group, click Select Data. In the Select Data Source dialog box, in the Legend Entries (Series) box, select the legend entry that you want to change. Click Edit. Tip: To add a new legend entry, click Add, or to remove a legend entry, click Remove.

Right-click the chart with the data series you want to rename, and click Select Data. In the Select Data Source dialog box, under Legend Entries (Series), select the data series, and click Edit. In the Series name box, type the name you want to use.

In the worksheet, click the cell that contains the title or data label text that you want to change. Edit the existing contents, or type the new text or value, and then press ENTER. The changes you made automatically appear on the chart.

Select the object (table, equation, figure, or another object) that you want to add a caption to. On the References tab, in the Captions group, click Insert Caption. In the Label list, select the label that best describes the object, such as a figure or equation.

Select your chart and on the Chart Design tab, choose Select Data. Choose on the legend name you want to change in the Select Data Source dialog box, and select Edit. Note: You can update Legend Entries and Axis Label names from this view, and multiple Edit options might be available.

How to rename a data series in Excel. On the menu displayed, click Select Data. In the Legend Entries, select the data series you want to rename, and click Edit. In the Edit Series dialog box, clear series name, type the new series name in the same box, and click the OK.

How do I change multiple names in Excel? ›

If you want to edit names of multiple columns at once, use the Rename At button found in the ribbon toolbar tab Variable. Clicking this button will show the function in the sidebar. If you click on it, the setting options will be displayed in the Properties Panel - Prefix, Suffix and Variables.

Go to Layout tab, select Data Labels > Right. Right mouse click on the data label displayed on the chart. Select Format Data Labels. Under the Label Options, show the Series Name and untick the Value.

Click Add Chart Element > Legend. To change the position of the legend, choose Right, Top, Left, or Bottom. To change the format of the legend, click More Legend Options, and then make the format changes that you want.

From the very right of the ribbon, click “Format Pane.” Once that pane is open, click on the legend itself within your chart. In your Format Pane, the options will then look something like this: Then, set that legend position to be whichever location you want.

A1: To change a legend name in Excel on Mac, select the legend and then click the “Chart Elements” button. Then, click the “Legend” option and select “More Legend Options.” In the Legend Options window, enter the new name in the “Name” text box and click “o*k.” This will change the legend name.

Right-click the trendline. In the pop-up menu choose Format Trendline. In the dialog box that appears, choose the Options tab. Under Trendline name, select Custom and fill in the new name.

Since the legend is a text object, you can edit it using methods common to all text objects: To open the Legend dialog box, press Ctrl + double-click on the graph legend text or right-click and choose Properties.