What a series name is and why you'd change it

A series in an Excel chart is the actual data being plotted — the numbers themselves. The series name is the label that identifies what those numbers represent. When you create a chart from a spreadsheet, Excel pulls the series name from your column header or row label. If that header says "Q1 Sales" but you later decide it should say "Q1 Revenue," you need to change the series name in the chart itself, not just in the spreadsheet.

The series name appears in the chart legend (the box that explains what each line or bar means) and in the data labels if you've turned those on. Changing it updates both places automatically. This matters because a confusing or outdated label makes your chart harder to read, and anyone viewing it might misunderstand what the data shows.

You have two ways to change a series name: by editing the source data reference in the chart, or by typing a new name directly into the chart itself. The first method is cleaner if you want the change to stick even if someone opens the file later. The second is faster if you just need a quick fix.

Key Takeaways

  • The series name is the label in your chart legend that identifies what data is being shown, usually pulled from your column or row headers.
  • You can change a series name by right-clicking the data series in the chart and selecting "Format Data Series," then editing the name field.
  • The faster method is to click the series once to select it, then click the name in the formula bar and type a new one directly.
  • Changes made in the chart do not update the original spreadsheet column headers, so keep track of what you renamed if others use the file.

Selecting the series you want to rename

Before you can change the name, you need to tell Excel which series you're working with. Click anywhere inside the chart to enter edit mode — the chart will show a gray border around it. Now click directly on one of the bars, lines, or data points in the chart. You should see small squares appear on every data point in that series, showing it's selected.

If your chart has multiple series (for example, bars for both "2023 Sales" and "2024 Sales"), clicking on one bar selects only that series. Click on a different bar to switch to a different series. If you click on the background or legend by mistake, the selection disappears and you'll need to click a data point again.

The quick method: editing the name in the formula bar

Once you have the series selected, look at the formula bar at the top of the screen — it's the long white box that normally shows cell contents. When a series is selected, it shows a formula that references your data, something like =Sheet1!$B$1. This formula tells Excel where the series name comes from.

Click in the formula bar and look for the cell reference that points to your header. In the example above, $B$1 is the cell containing the series name. Change that reference to point to a different cell, or delete the reference and type a new name in quotes, like ="New Series Name". Press Enter. The chart updates when ready.

This method works best when you want a name that doesn't exist anywhere in your spreadsheet, or when you want to point the series to a different header cell. It's the fastest way if you know exactly what you want the name to be.

The detailed method: using the Format Data Series dialog

Right-click on the selected series and choose Format Data Series from the menu. A dialog box opens with several tabs. Click the Series tab (or sometimes called Series Options, depending on your Excel version). You'll see a field labeled Series name with a text box next to it.

In that text box, you can either type a new name directly or click the small button with an arrow icon next to it. That button lets you click a cell in your spreadsheet to use as the series name — useful if you want the chart to pull the name from a specific cell and update automatically if that cell changes later. Type your new name or select your cell, then click OK.

This method is more reliable for permanent changes because it clearly shows you what the series name is set to. It also lets you see other series options at the same time if you need to adjust anything else about how the data displays.

Changing multiple series at once

If your chart has three or four series and you want to rename them all, you don't have to do them one at a time. After renaming the first series, click on a different series (a different bar or line in the chart) and repeat the process. Each series remembers its own name independently, so changing one doesn't affect the others.

A common situation is when you've created a chart from data where the headers weren't clear — maybe they say "Column A" and "Column B" instead of "Revenue" and "Expenses." You can rename each series to something meaningful without touching the original spreadsheet. This is especially useful if other people use that spreadsheet and you don't want to change their headers.

What happens to the original spreadsheet

Changing a series name in the chart does not change the column header in your spreadsheet. If your spreadsheet says "Q1 Sales" in cell B1, and you change the series name in the chart to "Q1 Revenue," the spreadsheet still shows "Q1 Sales." The chart and the spreadsheet are now out of sync.

This matters if someone else opens the file and wonders why the chart says one thing and the spreadsheet says another. If you want everything to match, change the header in the spreadsheet first, then the chart will update automatically (assuming the series name is set to reference that cell). If you change only the chart, make a note somewhere that the chart uses a different label than the source data.

Fixing a series name that points to the wrong cell

Sometimes a series name gets linked to the wrong cell by accident — maybe you copied a chart and the cell references shifted. The series name might show something unexpected or blank. To fix this, select the series, right-click, and choose Format Data Series. In the Series name

If the series name field is completely empty, the chart is showing no label at all. Click in that field and either type a name directly or use the arrow button to select a cell. Once you click OK, the name appears in the legend and anywhere else it's displayed in the chart.

Frequently Asked Questions

Can I change a series name without editing the chart?

Not directly. The series name in a chart is separate from the spreadsheet header, even if they start out the same. You can change the spreadsheet header and the chart will update automatically if the series name is set to reference that cell, but you cannot change the chart's series name from the spreadsheet itself.

What if I don't see the series name in my chart?

The series name appears in the legend box. If your chart has no legend, right-click the chart background and select Add Chart Element or Legend, then choose where you want it to appear. If the legend exists but shows no text, the series name field is probably empty — select the series and add a name using the method described above.

Will changing a series name affect my data or calculations?

No. The series name is purely a label. Changing it does not alter the numbers being charted, any formulas in your spreadsheet, or anything else. It only changes what the data is called in the chart display.

How do I rename a series if I'm using a pivot table chart?

Pivot table charts work the same way — select the series, right-click, and choose Format Data Series. However, if you refresh the pivot table later, the series names may revert to the pivot table's field names. To keep custom names permanent, rename the fields in the pivot table itself rather than in the chart.

Can I use special characters or line breaks in a series name?

You can use most special characters (like hyphens, parentheses, and dollar signs) in a series name. Line breaks within a single series name are not supported in the legend, though the name can be quite long. If the legend text is too crowded, make the legend box wider by dragging its edge.