The quickest way to rename a series in Excel
To change a series name in Excel, right-click the series (the colored bars, line, or points on your chart) and select Format Data Series. In the panel that opens, go to the Series Options tab, find the Series Name field, and type the new name. Click outside the field or press Enter to save the change.
A series name is the label that appears in your chart legend and identifies what the data represents—for example, "Sales Q1" or "Website Traffic." Changing it updates only the chart display, not the underlying data in your spreadsheet.
The method varies slightly depending on whether you want to link the name to a cell in your spreadsheet or type it directly. Both approaches take less than a minute.
Key Takeaways
- Right-click the series on the chart itself, not the chart title or legend, to open the formatting options.
- You can type a new name directly into the Series Name field, or link it to a cell so the name updates automatically when you change that cell.
- The series name change appears in the legend when ready and does not affect the actual numbers in your spreadsheet.
- If you have multiple series on one chart, you must format each one separately.
Typing a name directly into the series
This is the simplest method if you want a one-time name change that does not need to update later. Click on your chart to select it, then right-click directly on one of the bars, points, or line segments that make up the series you want to rename. A menu will appear.
Select Format Data Series from the menu. On the right side of the screen, a panel will open. Look for the Series OptionsSeries Name. Click in that field, clear the current text, and type your new name. Press Enter or click elsewhere to confirm.
The legend on your chart will update when ready. If you do not see a legend, you can add one by right-clicking the chart background and selecting Add Chart Element > Legend.
Linking the series name to a spreadsheet cell
If you want the series name to change automatically whenever you edit a cell in your spreadsheet, you can link the series name to that cell instead of typing it directly. This is useful when you update your data regularly and want the chart labels to stay in sync.
Right-click the series and select Format Data Series. In the Series Name field, type an equals sign followed by the cell address—for example, =A1 or =Sheet2!B5. Press Enter. Now the series name will always match whatever text is in that cell. If you change the cell content, the chart legend updates automatically.
Make sure the cell you link to contains only text, not a formula that returns an error or a number. If the cell is empty, the series will have no name in the legend.
Changing the name using the Name Box
Another route is to use the Name Box, which is the field that normally shows the cell address (like "A1") in the top left of Excel. This method works best if you prefer not to use the Format Data Series panel.
Click on your chart to select it. Then click directly on the series you want to rename—the entire series will highlight with small squares at each data point. Now look at the Name Box in the top left. It will show something like "Series 1" or the current series name. Click in the Name Box, type your new name, and press Enter.
This method types the name directly and does not create a link to a cell. Use the Format Data Series panel if you need to link to a cell instead.
Common mistakes to avoid
The most frequent error is right-clicking the chart title or the legend instead of the series itself. The chart title is the text at the top of the chart; the legend is the box that lists the series names. You must right-click one of the actual data elements—a bar, line, or point—to format that series.
Another mistake is forgetting that each series must be renamed separately. If your chart has three series (three different colored bars or lines), changing one does not change the others. You will need to right-click each series and repeat the process.
If you link a series name to a cell and later delete that cell or move it to a different sheet, the series name will show an error. Plan ahead if you are using cell links, and keep the source cells in a stable location.
Renaming a series in a pivot chart
Pivot charts work differently from regular charts. If you right-click a series in a pivot chart, the Format Data Series option may not appear, or changes you make might reset when you refresh the pivot table.
The safer approach is to rename the data at the source: change the field name in the pivot table itself, not the chart. Click on the pivot table, go to the PivotTable Analyze tab, and look for Field List. Find the field you want to rename, right-click it, and select Rename Field. The chart will update automatically.
Frequently Asked Questions
Why does my series name show as "Series 1" even after I change it?
This usually means the series name is linked to a cell that is empty or contains an error. Check the cell you linked to and make sure it has text in it. If you typed the name directly and it still shows "Series 1", try clicking the chart, then clicking the series again to make sure it is selected before you open Format Data Series.
Can I change the series name without opening the Format Data Series panel?
Yes, use the Name Box method. Click the chart, click the series, then click the Name Box in the top left (where it shows the cell address) and type the new name. This is faster if you do not need to link the name to a cell.
What happens to the original data in my spreadsheet when I change the series name?
Nothing. The series name is only a label on the chart. Changing it does not alter any of the numbers or formulas in your spreadsheet. The underlying data stays exactly the same.
How do I change the series name back to the original?
Right-click the series again, open Format Data Series, and type the old name or delete the current name. If you linked it to a cell, you can clear that cell or change the cell reference. There is no undo button specific to series names, so type carefully.
Can I rename multiple series at once?
No, you must rename each series individually. Select one series, change its name, then click a different series and repeat. There is no batch-rename feature for chart series in Excel.