To rename a series in an Excel chart, select the chart, go to Chart Design > Select Data, choose the series under Legend Entries (Series), and click Edit. Enter a new series name or select a worksheet cell containing the name, then click OK. The chart legend updates to use the new name, which makes it easier to tell what each set of data represents.
The steps below are for Excel for Microsoft 365 on Windows. You can also rename series by changing the worksheet heading that a chart uses as its series name. Before you start, decide whether you want a fixed label or a name linked to a cell: a linked name updates when you edit that cell, while a typed name stays as entered.
What You’ll Need
- An Excel workbook containing a chart with at least one data series.
- Permission to edit the chart and, if you plan to link the name, access to the worksheet cell that should supply it.
- For a chart that is hard to identify, a clear label such as Revenue, Actual, or Forecast, rather than a generic name like Series 1.
Step-by-Step
- Select the chart. Click the chart once so Excel displays the chart-specific ribbon tabs. If you click a legend label or a data point instead, Excel may select that individual element rather than the whole chart. Click an empty area inside the chart if needed, then check that Chart Design appears on the ribbon.
- Open the data source settings. Choose Chart Design > Select Data. Excel opens the Select Data Source dialog. The left side, labeled Legend Entries (Series), lists the chart’s data series. A series is a related set of values shown as a line, group of columns, or another chart element; it is not the same thing as an individual category such as a month on the horizontal axis.
- Choose the series to rename. In Legend Entries (Series), click the series name you want to change. If the chart has several series with similar names, use the preview and the series order to identify the right one. Click Edit below the list. Do not choose an item from Horizontal (Category) Axis Labels unless you intend to change the category labels instead.
- Set the new name. In the Edit Series dialog, find the Series name field. To use a fixed label, select the existing entry and type the new name. To use a worksheet heading, click the field, then click the cell containing the heading. Excel inserts a reference to that cell. For example, you might use the cell containing Actual sales or Forecast. Avoid deleting the series values or changing the Series values field when your only goal is to rename the series.
- Confirm the change. Click OK in the Edit Series dialog, then click OK again in Select Data Source. The legend should now display the new name. If the chart has no legend, the series name may not be visible on the chart yet; turn on a legend from Chart Design > Add Chart Element > Legend, and choose its position.
- Check the chart and the data. Compare the legend with the plotted line, bars, or other marks to make sure you renamed the intended series. A useful check is to select the series in the chart and see whether its values correspond to the expected worksheet column or row. If the chart uses data labels, titles, or a chart title that repeat the old wording, update those separately as needed.
- Repeat for other series. Return to Chart Design > Select Data, select another entry under Legend Entries (Series), and use Edit again. Rename each series individually. Changing one series name does not automatically rename every series in the chart, even when the labels follow a similar pattern.
- Save the workbook. Press Ctrl+S on Windows after checking the chart. On a Mac, use Command+S. If you share the workbook, confirm that the file format and sharing method preserve the chart and its source data.
Alternative: change the source heading. Many charts take each series name from a header cell in the source data. Find the heading above the relevant data column, or beside the relevant data row, and edit that cell. If the chart series name is linked to it, the legend updates automatically. This is often the simplest approach when the worksheet heading itself should also be corrected. If the legend does not change, use Select Data to check whether the series name is linked to a different cell or is a fixed label.
On Excel for Mac, select the chart and use the Chart Design tab and Select Data command if available in your ribbon layout; the Edit Series dialog works in a similar way. Ribbon layouts can vary slightly by Excel version and window size. In Excel for the web, chart editing options may be more limited or arranged differently. If you cannot find a series-name field, open the workbook in the desktop app and follow the Windows or Mac steps above.
Common Mistakes
- Editing a category label instead of a series. The Select Data Source dialog has separate controls for Legend Entries (Series) and Horizontal (Category) Axis Labels. The series list controls legend entries; the category control changes labels such as dates or product names along the axis.
- Typing a name into the wrong field. The Edit Series dialog includes both Series name and Series values. Put the label in Series name. Altering Series values can change which numbers are plotted or cause the series to disappear.
- Expecting a typed name to track a cell. A manually entered label is not necessarily linked to the worksheet heading. If you want future heading edits to flow through to the chart, choose the heading cell in the Series name field instead of typing its words as plain text.
- Changing the worksheet data without checking the chart. A heading may be used by more than one chart or table. Before editing a source heading, check whether that change should apply everywhere. If only one chart needs a different label, edit that chart’s series name directly.
- Assuming the chart title is the series name. The chart title describes the whole chart; a series name identifies one plotted data set and typically appears in the legend. Editing one does not change the other.
Tips
- Choose names that explain the data. Use labels a reader can understand without looking up the source range. For example, use 2025 actual rather than Column C, and Forecast rather than Series 2.
- Keep names short enough for the legend. Long labels can crowd a chart, especially when the legend sits below it or the chart is narrow. Use a concise label and explain any necessary detail in a chart title, subtitle, or nearby note.
- Use consistent wording. If several series compare the same measure across years, use a consistent pattern such as Sales 2024 and Sales 2025. Consistency makes comparisons easier to scan.
- Prefer linked headings for data that changes. When worksheet headings are maintained as part of a regular report, linking a series name to its header cell avoids having to update the chart label separately. Keep the source heading descriptive so it works both in the worksheet and in the chart.
- Review the finished chart at its final size. A legend that looks clear while editing may wrap or overlap when the chart is placed in a report or presentation. Resize the chart or move the legend if the new wording makes it difficult to read.
Troubleshooting
The Select Data or Edit button is unavailable. Make sure the chart itself is selected, rather than a worksheet cell or a single chart element. If it is a PivotChart, some source settings may be controlled by the associated PivotTable. Rename the relevant value field in the PivotTable, often through Value Field Settings and its Custom Name box, rather than expecting the standard series controls to behave like a regular chart. Menu wording and available options can vary with the PivotTable layout.
The legend still shows Series 1 or the old text. Reopen Select Data and check the selected series name. If you linked a cell, confirm that you selected the intended heading and that it contains the expected text. If you typed a label, ensure you edited the Series name field, not the chart title or axis labels. Click OK in both dialogs to apply the change.
The name changes back after editing the worksheet. The chart may be using a cell reference for its series name. Editing that referenced cell will change the displayed name again. Decide whether the worksheet heading or the chart-specific label should be the source of truth. To keep the chart label independent, set the Series name to a fixed label; to keep it synchronized, edit the linked heading instead.
The series you want is not listed. The chart may not include the expected row or column in its source data. In Select Data Source, inspect the chart data range and the series list. If the values are missing, correct the source range or add the intended series first. Renaming cannot make an unplotted data set appear by itself.
The label appears in the legend but not on the chart. Series names normally appear in a legend, not automatically beside every plotted point. If you need a name directly on a line or bar, add or edit data labels and choose suitable label options where supported by that chart type. Keep labels readable and avoid adding them to every point if that makes the chart crowded.
The chart is embedded in a protected or shared workbook. Check whether the sheet or workbook is protected and whether you have edit access. Some coauthoring or browser views may restrict chart editing. If the command is unavailable, request the necessary permissions or open an editable desktop copy, make the change, and save it back to the shared location.
Frequently Asked Questions
Can I rename a series without changing the worksheet data?
Yes. Select the chart, open Chart Design > Select Data, choose the series, click Edit, and type a label in Series name. This changes the chart’s displayed series name without editing the source heading.
Will changing the series name affect the plotted values?
No, not when you edit only the Series name field. The values remain the same. Be careful not to modify Series values, which specifies the data Excel plots.
Can a series name come from a cell?
Yes. In the Edit Series dialog, select the Series name field and then select the worksheet cell containing the label. The chart can then use the cell’s text as the series name, so changing that heading can update the chart.
Why does my chart show Series 1 instead of my column heading?
Excel may not have recognized a heading when the chart was created, or the series name may not point to that heading. Edit the series name and select the correct header cell, or type a clear label directly.
Can I rename a series in Excel for the web?
Some chart-editing controls are available in Excel for the web, but the interface and options can differ. If you cannot find Select Data or the series-name control, open the workbook in desktop Excel and rename the series there.
Does renaming a series also change the chart title?
No. The series name and chart title are separate. Rename the series to change its legend entry; edit the chart title separately if the overall description needs updating.
Related
- How to Paste an Excel Table into Yahoo Mail Cleanly
- How to Paste an Image in an Excel Cell
- Password Protect an Excel File so It Requires a Password
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Gantt Chart Dates: Formulas, Setup, and TipsFor a basic Excel Gantt chart, calculate each task’s finish date with =B5+C5-1 when B5 is its start…
- Excel Dashboard Course: What to Learn and How to ChooseAn Excel dashboard course teaches you to turn spreadsheet data into a clear, interactive summary that helps people…
- Access Power Pivot in Excel 365: Enable and Use ItTo access Power Pivot in Excel for Microsoft 365 on Windows, open File > Options > Add-ins, choose…
- Excel Line Chart With Two X-Axes: Setup and AlternativesExcel can display a secondary horizontal axis on some charts, but a standard line chart does not give…
- Excel Speedometer Chart: Build a Gauge Step by StepTo build a speedometer chart in Excel, make a doughnut chart from your gauge ranges, hide its lower…
- Copy Sparklines from Excel to PowerPoint: Best MethodsTo copy sparklines from Excel to PowerPoint, select the cells that contain them, use Excel’s Home > Copy…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.