How to Rename a Legend in an Excel Chart

Charts & pivot tables · Updated November 20, 2026

To rename a legend entry in an Excel chart, select the chart, go to Chart Design > Select Data, choose the series under Legend Entries (Series), and select Edit. Change the series name or link it to a worksheet cell, then confirm. A chart legend displays series names, so changing the series name changes the corresponding legend label.

What You’ll Need

  • An Excel workbook containing a chart with a visible legend.
  • Permission to edit the workbook. If the chart is based on worksheet data, you may also want to know which cell or data heading supplies the current series name.
  • Excel for Microsoft 365 on Windows for the exact ribbon steps below. Excel for Mac has similar chart controls; Excel for the web may show a more limited set of editing options.

Step-by-Step

  1. Select the chart. Click once inside the chart area. Excel should show the chart-specific ribbon tab, usually called Chart Design. If you only see the regular worksheet tabs, click the chart again. Make sure you select the chart itself rather than a nearby cell or an individual data point.
  2. Open the data settings. On the ribbon, choose Chart Design > Select Data. The Select Data Source dialog shows the data range and a list named Legend Entries (Series). Each item in that list corresponds to a plotted data series and normally to one legend entry.
  3. Choose the entry to change. In the Legend Entries (Series) list, click the series whose legend text you want to update. If the chart has several lines, columns, or other data groups, use the list to identify the right one. When possible, compare the current name with the series’ data or its color in the chart before editing.
  4. Open the series editor. With the intended series selected, click Edit. Excel opens an Edit Series dialog with a Series name field, along with fields for the series values. Do not change the values field unless you also intend to change which numbers the chart plots.
  5. Enter the new name. Click the Series name field. You can enter a short label directly, or select a worksheet cell that contains the label. To use a cell, click the small range-selection button beside the field if it is shown, select the cell on the sheet, and confirm the selection. For example, if a chart’s current entry is “Series 1,” you could use a cell containing “Online sales” so the legend describes the data clearly.
  6. Confirm the change. Click OK to close Edit Series, then click OK again in Select Data Source. The chart should redraw with the revised legend entry. If you do not see a legend, select the chart and use Chart Design > Add Chart Element > Legend to add one, then choose a position.
  7. Check the chart and source. Confirm that the intended legend label changed and that the line, bars, or other plotted values are still correct. If you linked the name to a cell, check that you selected the label cell, not a value cell or a blank cell. Save the workbook when the result is right.

Alternative when the chart uses column headings: If the series name comes from the heading above its data, you can edit that heading cell instead. For example, changing a column heading from “Series 1” to “Online sales” often updates the chart legend automatically. This approach keeps the worksheet label and chart label in sync. Use the Select Data method when you want a chart-specific name or when changing the source heading would affect other parts of the workbook.

Excel for Mac: Select the chart and look for Chart Design > Select Data on the ribbon. Choose the series, select Edit, change its Series name, and confirm. Ribbon layout and dialog appearance can vary slightly by Excel version, but the series-name setting serves the same purpose. If the ribbon is collapsed, expand it or use Excel’s search box to find “Select Data.”

Excel for the web: Select the chart and check the chart ribbon for a data-selection or series-editing option. Available chart-editing controls can differ from the desktop app and may depend on the chart type. If you cannot edit the series name in the browser, open the workbook in the Excel desktop app and use the steps above. You can also try changing the worksheet heading that supplies the series name, if that is appropriate for your workbook.

Common Mistakes

  • Editing the chart title instead of the legend entry. The chart title describes the whole chart; legend entries identify individual data series. To rename a legend label, edit the series name, not the chart title text box.
  • Changing a category label instead of a series name. The horizontal axis may show categories such as months or product names. Those labels are not the same as the legend entries. In Select Data Source, use the Legend Entries (Series) list for a legend label; the category-axis label control is for the labels along the chart axis.
  • Replacing the series values by accident. The Edit Series dialog contains more than one field. Enter the new text in Series name only. Changing the series values can make the chart plot different cells or remove its data.
  • Typing a name into a cell that is not used by the chart. A label elsewhere on the worksheet will not automatically affect the legend. Either edit the series name in the dialog or change the actual heading cell that the chart uses.
  • Expecting a single legend heading to rename every entry. A legend is usually a list of series labels, not a single editable text object. Rename each series separately if several entries need new names. If you mean the chart’s title or a separate explanatory heading, edit or add that text independently.
  • Changing a shared source heading without checking other charts. Several charts or formulas may use the same heading cell. Editing it can update more than the chart you have open. Use a direct series name if you want to change only this chart.

Tips

  • Use labels that explain what is being compared. “2025” and “2026” may be enough for a year-to-year chart, while “North region” and “South region” may be clearer for a regional comparison. Keep labels concise so they fit without crowding the chart.
  • Link names to cells when labels may change. Selecting a worksheet cell for Series name means the chart can reflect later edits to that cell. This is useful for reports that are refreshed or reused. Keep the label cell in a visible, clearly named header row so it is easy to maintain.
  • Use the source heading when it should be consistent everywhere. If the worksheet heading is already the intended name, correcting it is often simpler than setting a separate chart label. This can also prevent the chart and table from describing the same data differently.
  • Rename one series at a time. In charts with several entries, confirm the selected series before editing. A quick check of the chart’s color or plotted values can help you avoid assigning one series’ name to another.
  • Consider the legend layout after renaming. Longer names can make a legend wider or taller and may reduce room for the plot. If necessary, move the legend using Chart Design > Add Chart Element > Legend, or shorten the wording while keeping it meaningful.
  • Keep a copy of the original wording if the workbook is shared. This is especially useful when a label has a defined meaning in a recurring report. A clear, consistent naming convention makes future updates easier for other people who use the file.

Troubleshooting

The legend did not change. Reopen Chart Design > Select Data and check whether you edited the intended series. Make sure you confirmed both dialogs. If the series name is linked to a cell, verify that the selected cell contains the new wording and is part of the chart’s actual source data. If the chart is based on a PivotTable, see the PivotChart note below.

The legend entry changed back after editing the worksheet. The series name may be linked to a heading cell, so later edits to that cell replace the displayed name. Decide whether the worksheet heading or a chart-specific name should be the source of truth. If you want a chart-specific label, edit the Series name in Select Data and avoid changing it through the source heading.

The Edit button is unavailable, or the chart controls are missing. Confirm that the chart is selected and that you are editing the workbook rather than viewing it in read-only mode. A protected sheet or workbook can also restrict changes; if you are authorized, check the relevant protection settings. In Excel for the web, open the file in the desktop app if the required control is not available.

The chart shows “Series 1” or another generic label. This often happens when the chart was created without a usable heading, or when its header cell is blank. Give the series a meaningful name in the Edit Series dialog, or add a heading to the correct source cell. If the chart includes headers in its selected data range, verify that Excel is interpreting the intended row or column as the series name.

The chart is a PivotChart. PivotCharts draw their series and labels from PivotTable fields, so the standard series-editing workflow may be restricted or the name may revert after a refresh. Check the PivotTable field or item that supplies the label and rename it there, where permitted. For a value field, the PivotTable’s value-field settings may provide a custom name. Be aware that changing a PivotTable label can affect the associated PivotTable and other connected views; make a copy or check with the workbook owner before changing shared report fields.

The new name is too long or appears cut off. Shorten the wording, widen the chart, or move the legend to another position. You can also resize the chart area. Check the result at the size where the chart will actually be viewed or printed, since a label that fits on a large worksheet may wrap or become crowded in a report.

Frequently Asked Questions

Can I rename a legend entry without changing the source data?
Yes. Select the chart, open Chart Design > Select Data, select the series, choose Edit, and enter a chart-specific Series name. If you change the source heading instead, other charts or worksheet content that use it may also change.

Why does my legend show “Series 1” instead of a name?
Excel may not have found a heading for that series when the chart was created. The heading cell may be blank, or the chart’s data range may not include it. Add or correct the relevant source heading, or set the name directly in the Edit Series dialog.

Can I rename just one entry in the legend?
Yes. In Select Data Source, select only the series you want to change and edit its name. The remaining series names stay as they are. Confirm the selected item carefully when the chart contains several series.

Can I rename the word “Legend” itself?
Most Excel charts do not have a separate, built-in legend heading called “Legend.” They show a key of series names. To add a heading such as “Product,” insert a separate text box or use another chart text element, then position it near the legend.

Will the new legend name remain after refreshing the data?
It depends on how the name is set. A name linked to a worksheet heading follows that cell, while a PivotChart may take its labels from PivotTable fields during refresh. For a standard chart, check the series name after updating the data; for a PivotChart, manage the label in the PivotTable or its field settings.

Can I change legend names in Excel for the web?
Sometimes, depending on the chart and the editing controls available in your browser version. If you cannot find a series-editing option, use Excel for Microsoft 365 on Windows or Mac. Editing the chart’s source heading in the browser may also work when the legend name comes from that heading.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.