How to Change a Column Name in an Excel Chart

Charts & pivot tables · Updated November 20, 2026

To change a column name shown in an Excel chart, rename the chart’s data series: select the chart, go to Chart Design > Select Data, choose the series under Legend Entries (Series), select Edit, and enter a new series name or point to a worksheet cell. If you mean the labels along the chart’s horizontal axis, edit the category-axis labels instead. The steps below are for Microsoft Excel for Microsoft 365 on Windows.

What You’ll Need

  • An Excel workbook containing the chart you want to update.
  • Permission to edit the chart and its source data. If the chart is linked to a worksheet, knowing where its source table is will make it easier to keep the chart labels consistent.

You do not need to recreate the chart or change the numbers to rename a series. Save a copy first if you are working with a shared or important workbook, particularly before making other changes to its data layout.

Step-by-Step

  1. Select the chart. Click once inside the chart area. Excel should show the contextual Chart Design and Format tabs on the ribbon. If you only see regular worksheet tabs, click the chart again. Selecting an individual bar or column can select a single data point instead, so click an empty area of the chart when possible.
  2. Open the chart’s data settings. Select Chart Design > Select Data. You can also right-click the chart background and choose Select Data. The Select Data Source dialog shows the worksheet range feeding the chart and a list called Legend Entries (Series). In many charts, each listed series is one of the colored groups, such as a year, product, or department.
  3. Choose the series to rename. In Legend Entries (Series), click the entry whose displayed name you want to change. Check its color and the data represented in the chart before proceeding, especially if several series have similar names. Select Edit to open the Edit Series dialog. Do not choose a category label on the right if you are changing the series or legend name.
  4. Enter the replacement name. In the Series name box, either type a name or select the worksheet cell that contains the desired heading. For example, you could replace a series named 2024 with 2025, or change Sales to Online sales. A typed name is stored with the chart. A cell reference makes the chart name follow that cell if its text changes later, which is usually the better choice for a chart tied to a table.
  5. Apply the name and close the dialog. If you are linking to a cell, click the small range-selection button beside the Series name box if needed, select the heading cell on the worksheet, and confirm the selection. Select OK in the Edit Series dialog, then select OK in Select Data Source. The chart legend should show the new name. The bars, columns, lines, or other plotted values should remain unchanged.
  6. Alternatively, change the source heading. If the series name comes from a header cell in the chart’s source data, you can edit that cell directly on the worksheet. For example, if a table heading says North and the chart uses that heading as a series name, replacing North with North region should update the chart’s legend automatically. This is often the simplest method when the heading is used only for the intended series. Check other charts that use the same cell, because they may update too.
  7. Check whether you meant a horizontal-axis label. If you want to rename labels such as January, February, or product names along the bottom of the chart, select Chart Design > Select Data. Under Horizontal (Category) Axis Labels, choose Edit, then select the worksheet cells containing the replacement labels and confirm. These are category labels, not series names. Changing them can update several labels at once, so select the full intended range.
  8. Review the chart and save. Confirm that the right legend entry changed, the category labels still match the data, and the chart title was not accidentally altered. If the text is too long for the legend, resize the chart or adjust the legend placement. Save the workbook after checking the result.

In Excel for Mac, select the chart and use the Chart Design tab, then choose Select Data; the dialog and series-name controls are broadly similar, though the ribbon layout can differ. In Excel for the web, changing a worksheet header may update a linked chart, but some chart editing controls vary by chart type and account. If you cannot find the series edit controls in the browser, open the workbook in the desktop app.

Common Mistakes

  • Editing the chart title instead of the series name. The chart title describes the whole chart and is a separate text element. Clicking it and typing changes only the title; it does not rename an entry in the legend. Use Select Data to edit a series name.
  • Changing the wrong kind of label. A legend lists data series, while the horizontal axis usually lists categories. If the legend says East and West, those are likely series names. If the bottom axis says Q1 and Q2, those are likely category labels. Decide which displayed text you mean before editing.
  • Typing a cell address as plain text. If you want the series label to follow a worksheet heading, select the cell using the range picker or enter it as a valid worksheet reference in the series-name box. Typing something like B1 without selecting or referencing the cell can make Excel treat it as literal text rather than the cell’s current value.
  • Overwriting or moving source data. Renaming a heading is different from changing the plotted values. Avoid replacing a row or column of numbers when all you intend to change is its label. If you insert, delete, or move source cells, verify the chart range afterward.
  • Assuming the change affects only one chart. Several charts can use the same source heading. Editing that worksheet cell may rename the series in each chart that references it. If only one chart should have a custom label, change the series name in that chart’s dialog instead.
  • Changing the chart’s row-and-column orientation by mistake. The Switch Row/Column control changes which data Excel treats as series and which it treats as categories. It is not a rename command and can substantially rearrange the chart. Use it only when the chart is grouping data in the wrong direction.

Tips

  • Prefer a worksheet reference for labels that may change. Linking the series name to a header cell reduces the chance that a chart legend will become out of date after a report heading is revised. Keep the heading concise so it fits in the legend.
  • Use clear, distinct names. If a chart compares multiple years or locations, include enough detail to identify each series, such as Actual 2025 and Forecast 2025 rather than two entries both called Sales. Avoid names that are so long they crowd the plot.
  • Check for blank or merged header cells. Excel may display a blank or unexpected label if the source heading is empty or the chart refers to a different cell than the one you edited. Use Select Data to inspect the chart’s source range and series name.
  • Keep axis labels and legend entries consistent with the source table. If a workbook is used for recurring reports, use a stable header row and update the source cells rather than repeatedly typing unrelated labels into charts. That makes future updates easier to verify.
  • Make the label readable at its final size. A name may fit while the chart is large but become cut off when pasted into a document or displayed on a small screen. Shorten the wording or reposition the legend rather than shrinking the chart text until it is hard to read.

Troubleshooting

The legend name did not change. Reopen Chart Design > Select Data and check that you edited the correct series. If you typed a name, confirm the dialog with OK twice. If you edited a worksheet header, check that the chart actually uses that cell as the series name; the chart may use a different header or a name entered directly in the chart settings.

The legend is missing or hidden. The series can still exist even if the legend is not displayed. Select the chart, use the chart elements control or Chart Design > Add Chart Element > Legend to show a legend, then inspect the result. The exact available options depend on the chart type. You can also open Select Data to confirm the series is listed.

The name appears as a formula or an unexpected value. Check the reference in the Series name box and make sure it points to the intended heading cell, not a data cell or a blank cell. If the source worksheet name contains spaces, Excel may include apostrophes around it in the reference; that is normal. Select the correct cell with the range picker if you are unsure.

Excel changes the labels at the bottom, not the legend. You likely edited Horizontal (Category) Axis Labels. Reopen Select Data and choose the intended entry under Legend Entries (Series), then select Edit. If your intended text is actually a category such as a month or location, keep using the axis-label edit control instead.

The controls are unavailable or behave differently. Make sure the chart itself is selected and that the workbook is not opened in a restricted, read-only, or protected state. Some chart types and Excel for the web have fewer editing controls. Try the workbook in the Microsoft 365 desktop app, and check whether the chart is a picture rather than an editable chart. A picture has no data series to rename.

Frequently Asked Questions

Can I rename a chart column without changing the worksheet heading?

Yes. Use Chart Design > Select Data, select the series, choose Edit, and type a name in Series name. That changes the chart’s label without changing the source cell. If you want the label to update whenever a heading changes, link the series name to that cell instead.

Does changing the series name change the chart values?

No. Renaming a series changes its displayed name, such as its legend entry. It does not change the numbers plotted by the series. Still, check the chart after editing to ensure you selected the correct series and did not change its data range.

How do I change the names along the bottom of a column chart?

Those are usually category-axis labels. Open Chart Design > Select Data, select Edit under Horizontal (Category) Axis Labels, and choose the cells containing the new labels. For a bar chart, the category labels may appear vertically along the left side instead.

Why does Excel show Series 1 instead of my heading?

Excel may show a default name when the chart’s source header is blank, excluded from the chart range, or not recognized as a heading. Check the source range in Select Data, then either include the correct header cell or edit the series name directly.

Will the renamed chart series stay changed when I update the data?

Usually, yes, as long as the series remains in the chart. A manually typed name stays with the chart, while a name linked to a worksheet cell reflects that cell’s current text. If you replace or rebuild the chart’s source range, check the name and legend again because the series may be recreated.

Can I change a column name in Excel for the web?

You can edit worksheet headings in Excel for the web, and linked chart labels may update. Chart editing options depend on the chart and available web controls. For the most direct access to Select Data and series-name editing, use Excel for Microsoft 365 on Windows or Mac.

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.