The quickest way to rename a series in Excel

To rename a series in Excel, right-click on any data point in the series (the bars, line, or dots in your chart), select Format Data Series, go to the Series tab, and change the name in the Series name field. You can type a new name directly, or point Excel to a cell that contains the name you want to use. The chart updates when ready.

This works whether your series is a bar chart, line chart, scatter plot, or any other chart type. The series name is what appears in your chart legend — the box that identifies which color or line represents which data.

If you have multiple series in one chart and want to rename them all, you repeat this step for each series. There is no way to rename all series at once from the chart itself.

Key Takeaways

  • Right-click any data point in the series you want to rename, then select Format Data Series from the menu.
  • In the Series tab, you can type a new name directly into the Series name field or link it to a cell.
  • The chart legend updates automatically as soon as you confirm the change.
  • If you linked the series name to a cell, changing that cell's content will change the series name in the chart.
  • You must rename each series individually — there is no bulk rename option.

Renaming a series by typing a name directly

The simplest approach is to type the new name straight into the dialog box. Click on your chart to select it, then right-click on any data point in the series you want to rename. A context menu appears. Select Format Data Series (not Format Data Point — that is for a single bar or dot).

The Format Data Series pane opens on the right side of your screen. Click the Series tab if it is not already selected. You will see a field labeled Series name. Clear whatever is there and type your new name. Press Enter or click elsewhere to confirm. Your chart legend updates right away.

This method works best when you know exactly what you want to call the series and do not plan to change it later. If you type "Q1 Sales" and then decide next month you want "Q1 2024 Sales", you have to come back and edit the chart again.

Linking a series name to a cell instead

If your series name might change — or if you want the chart to pull the name from your data table — link the series to a cell instead of typing a static name. In the Series name field, type an equals sign followed by the cell reference, like =A1 or =Sheet2!B5. Excel treats this as a formula and pulls the text from that cell.

Now when you change the content of that cell, the series name in the chart changes automatically. This is useful if you have a data table where the column header is the series name, or if you maintain a separate list of labels that feed multiple charts.

The cell you link to must contain text or a formula that produces text. If the cell is empty, the series name disappears from the legend. If the cell contains a number, Excel displays the number as the series name.

Why your series name might not be showing

If you renamed a series but the legend still shows the old name, the chart may not have refreshed. Click somewhere outside the chart and then click back on it. If the name still does not update, check that you clicked Format Data Series and not Format Data Point. Formatting a single data point does not change the series name.

Another reason the legend might be hidden is that you have turned off the legend display. Click the chart, then look for a Chart Elements button (a plus sign) in the top right corner of the chart. Click it and check the Legend box to show the legend again.

If you linked the series name to a cell and the name is not updating when you change that cell, make sure you used the equals sign. Without it, Excel treats your entry as plain text, not a formula.

Renaming multiple series in the same chart

When you have a chart with two or more series — for example, a chart comparing sales across three regions — you rename each series separately. Right-click on a data point from the first series, rename it, then right-click on a data point from the second series and rename that one too.

The easiest way to tell which data points belong to which series is to look at the color or pattern. All bars of the same color are the same series. All dots on the same line are the same series. Click on one data point and the entire series highlights.

If your chart is crowded and it is hard to click on the right data point, you can also select the series from the Chart Design tab. Click the chart, go to Chart Design, and look for a dropdown that lists all the series in your chart. Select the series you want to rename from that list, then right-click and choose Format Data Series.

When to use a cell reference instead of typing the name

Use a cell reference if your data table already has a header row with the series names. For example, if your spreadsheet has columns labeled "North Region", "South Region", and "West Region", link each chart series to its corresponding header cell. This way, if you ever change the header text, the chart updates without you having to edit it.

Cell references are also useful if you create charts from templates or if you build multiple charts that share the same series names. Change the name once in your data table, and all linked charts reflect the change.

The downside is that if someone deletes or moves the cell you linked to, the series name disappears. For a chart that will not change much, typing the name directly is simpler and safer.

Frequently Asked Questions

Can I rename a series without opening the Format Data Series dialog?

No. The Format Data Series dialog is the only place in Excel where you can change a series name. You cannot edit it directly in the chart or from the spreadsheet itself. The series name is stored as part of the chart object, not as a cell value.

What happens if I delete the cell that a series name is linked to?

The series name disappears from the chart legend. If you want to keep the chart working, either restore the cell or edit the series to use a static name instead. You can also link it to a different cell that contains the name you want.

Can I use a formula in the Series name field?

Yes, but only if the formula is a cell reference (like =A1) or a reference to another sheet (like =Sheet2!C3). You cannot use functions like CONCATENATE or IF in the Series name field. If you need a formula-based name, create it in a cell first, then link the series to that cell.

Does renaming a series change my original data?

No. The series name is part of the chart only. Renaming a series does not change any values in your spreadsheet, column headers, or data table. You can rename a series as many times as you want without affecting your data.

Why does my series name show a cell reference instead of the actual text?

You likely typed the cell reference without an equals sign. Excel treats A1 as text and displays it literally. To link to a cell, you must start with =A1. Delete what is there and type it again with the equals sign.