Excel Chart Legend Text: Rename Series and Edit Labels

To change legend text in an Excel chart, select the chart, choose Chart Design > Select Data, select the series under Legend Entries (Series), and click Edit. Change the series name there, or edit the source-data heading that supplies the name. A chart legend identifies data series, so the right method depends on whether you want to change the displayed name, the underlying heading, or the chart’s category labels.

Rename a legend entry in the Select Data dialog

In Excel for Microsoft 365 on Windows, the Select Data dialog lets you edit the chart’s series names and choose which cells provide them. This works for most standard charts, including column, line, and pie charts. Follow these steps:

Click the chart to show the chart tabs on the ribbon.
Open Chart Design > Select Data.
In Legend Entries (Series), click the entry you want to change, then click Edit.
In the Series name box, enter the name you want or select the worksheet cell containing it. Click OK, then click OK again to close the dialog.

For example, if the legend currently says Series 1 and the data column represents completed orders, change its name to Completed orders. If the name should remain connected to a heading cell, select that cell in the worksheet rather than typing a fixed label. The exact dialog layout can vary slightly by chart type, but the series list and its Edit control are the key parts.

On Excel for Mac, select the chart and use the Chart Design tab’s Select Data command, then edit the relevant series. Excel for the web has chart-editing controls too, but their placement and available options can differ from the Windows desktop dialog. If you cannot find the series-name control in the web version, open the workbook in desktop Excel for the full set of chart options.

Change the source heading instead

Often the simplest fix is to change the heading above the data column or row. Excel commonly uses that heading as the chart’s series name. For instance, if the source table has Month in column A, Budget in column B, and Actual in column C, the legend will usually show Budget and Actual. Change the heading Actual to Final results, and a chart linked to that heading will usually update its legend accordingly.

This approach is useful when the worksheet heading and chart legend should say the same thing. It also helps keep a workbook consistent: a later chart made from the same data is more likely to inherit the intended label. However, the update depends on how the series name was set. If someone replaced the cell reference with a fixed name in the chart’s series settings, changing the worksheet heading might not change that chart. In that case, edit the name in Select Data or restore the link to the heading cell.

When selecting a cell as the series name, use a clear, single-cell heading. If the cell is blank, Excel may show a generic name or an unhelpful empty entry. Avoid using a long explanatory sentence as a heading when a short chart label will do; a long legend can crowd the chart, especially when it is placed at the top or bottom.

Use a custom label without changing worksheet data

You do not have to rename a source-data heading just to make one chart easier to read. In Chart Design > Select Data, select the series and edit its name for that chart. This is useful when the worksheet uses technical column names, when a chart needs a shorter label, or when two charts should describe the same data differently for separate audiences.

A custom chart name can be a fixed label or a reference to a cell. A fixed name is convenient for a one-off chart, but it will not automatically follow changes to the worksheet heading. A cell reference keeps the chart label connected to that cell, which is preferable when names change over time. If you use a reference, check that it points to the intended worksheet and cell; a reference to a blank or unrelated cell can make the legend confusing.

There is an important distinction between changing the legend and changing the data. Renaming a series changes its displayed identifier; it does not alter the values, formulas, or source range that the chart plots. If the chart is showing the wrong numbers, changing the legend text only disguises the problem. Check the series values and category range in Select Data as well.

Know the difference between a legend and axis labels

A legend names the separate data series in a chart. Axis labels identify positions along an axis, such as dates, departments, or product names. These are different chart elements, and changing one does not necessarily change the other. In the example with Month, Budget, and Actual columns, Budget and Actual are series names in the legend, while the month names are category labels along the horizontal axis.

If you meant to change the labels along the bottom of a column chart, open Chart Design > Select Data and look under Horizontal (Category) Axis Labels. Use Edit there to select the cells containing the desired categories. In a bar chart, the category labels may appear on the vertical axis instead, but they still are not legend entries. A chart with only one series may not need a legend at all; you can remove it or show the series name another way, such as with data labels.

Checking this distinction prevents a common mistake: editing the series name when the real issue is that the months or product names along the axis are wrong. If both the legend and axis are inaccurate, inspect both sections of the Select Data dialog and confirm that each points to the correct cells.

Reorder, remove, or show legend entries

The Select Data dialog can also help when the legend names are right but appear in an unhelpful order. Under Legend Entries (Series), select a series and use the up or down controls to change its position. This can change the order of the series in the chart as well as the legend, depending on the chart type, so inspect the plotted data after reordering. For a stacked chart, series order can affect which segment appears at the bottom or top.

To remove a series from a standard chart, select it in the series list and choose Remove. This removes that series from the chart, not from the worksheet. To show or hide the legend itself, select the chart and use Chart Design > Add Chart Element > Legend, then choose a position or turn it off. A visible legend is not always necessary: direct labels on lines or bars can be easier to interpret when there are only a few series, although direct labels require their own formatting.

Changing a legend’s position or font is separate from changing its text. Right-click the legend and choose Format Legend to access formatting options, or use the chart formatting controls available in your Excel version. Formatting can improve readability, but it does not rename the series or correct its source reference.

Special cases: PivotCharts and linked charts

PivotCharts are connected to PivotTable fields, so their series names are often controlled by the PivotTable rather than by the ordinary Select Data workflow. If a PivotChart does not let you edit a series name in the usual way, inspect the associated PivotTable and its field names. For a summarized value such as Sum of Sales, right-click the value field in the PivotTable, choose Value Field Settings, and enter an appropriate Custom Name. The chart may use that name. Field and item labels can also depend on the source data and PivotTable layout.

Charts copied into another workbook or linked to external data may have series names that refer to cells in a different sheet or file. If a label does not respond to a local heading change, open Select Data and inspect the series name reference. A chart linked to an external workbook may keep its existing name or prompt for updated links; changing a local cell that is not the chart’s actual source will have no effect.

For a chart built from an Excel table, headings typically serve as series names, and adding or renaming table headings can update the chart’s labels. Still, verify the result after changing table structure. If you are working with a PivotChart, an external link, or a workbook designed with fixed chart formulas, the source heading may not be the controlling label.

Common problems and how to fix them

The legend still says Series 1. The chart may not have detected a heading, or the heading cell may be blank. Add a clear heading, then check whether the series name points to it. You can also enter a custom name in the series settings.
Changing the column heading does nothing. The chart may use a fixed series name or a different cell reference. Use Select Data to inspect and edit the name for that specific chart.
The wrong items change when you edit the label. You may be editing category labels rather than the legend series, or vice versa. Confirm whether the target is listed under Legend Entries (Series) or Horizontal (Category) Axis Labels.
The chart has no legend. Select the chart and add one with Chart Design > Add Chart Element > Legend. If the chart has only one series, decide whether a legend adds useful information before displaying it.
The edit controls are unavailable. Check whether the chart is a PivotChart, whether the worksheet is protected, or whether you are using Excel for the web, where some desktop controls may be arranged differently. Try the desktop app if necessary.

After editing, read the chart as a viewer would: can someone tell which color or line represents each series, and do those names match the data being shown? That quick check catches labels that are technically changed but still ambiguous, such as several entries all called Sales.

Frequently Asked Questions

Can I rename a chart legend without changing the data?
Yes. Select the chart, open Chart Design > Select Data, choose the series, and edit its name. This changes the chart label, not the values or source data. Use a cell reference instead of a fixed name if you want the label to follow a worksheet cell.

Why does my Excel legend say Series 1?
Excel often uses a generic name when it cannot identify a usable heading for the series. Add or correct the source-data heading, or set a name directly in the series Edit dialog. Also check that the chart’s series name is not pointing to a blank cell.

How do I change the labels at the bottom of an Excel chart?
Those are usually horizontal category-axis labels, not legend entries. Go to Chart Design > Select Data and edit the range under Horizontal (Category) Axis Labels. The exact axis orientation depends on the chart type.

Can I change the legend text in Excel for the web?
Excel for the web supports chart editing, but some controls may be arranged differently or be less complete than in desktop Excel. Select the chart and look for its data or series editing options. Use Excel for Microsoft 365 on Windows or Mac if the required series-name control is not available.

Does renaming a PivotChart legend work the same way?
Not always. A PivotChart is tied to its PivotTable fields, so change the relevant field or value-field custom name in the PivotTable when ordinary series editing is unavailable. Refresh or inspect the chart afterward to confirm it displays the new label.

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.