To rename a data series in an Excel chart, select the chart, choose Chart Design > Select Data, select the series under Legend Entries (Series), and click Edit. Enter a new name or select a worksheet cell containing the name, then choose OK. The chart legend and other places that display the series name will update. You can also rename the series by changing its source column or row heading.
What You’ll Need
- An Excel workbook with a chart and its source data. These steps are for Microsoft Excel for Microsoft 365 on Windows.
- Permission to edit the workbook. If you want the name to update automatically when a heading changes, identify a worksheet cell you can use for the series name.
You do not need to rebuild the chart or change its values. Renaming changes the label Excel uses for the series; it does not change the plotted data. If you are working with a PivotChart, see the troubleshooting section because its field names are managed differently.
Step-by-Step
- Select the chart. Click once on the chart area. You should see a border or handles around the chart and chart-specific tabs on the ribbon, including Chart Design. If you click a data point or legend entry instead, you may select only that object. Click an empty part of the chart area to select the whole chart.
- Open the chart’s data settings. On the ribbon, choose Chart Design > Select Data. The Select Data Source window opens. It shows the chart’s data range and a list called Legend Entries (Series). In some chart layouts, the series are displayed as rows rather than columns, but they are still listed in this box.
- Choose the series you want to rename. Under Legend Entries (Series), click the series name once. If the chart has several lines or groups of columns, use the legend text and the series order to identify the right one. If you are unsure, cancel the dialog temporarily and click the relevant line or column in the chart; Excel will usually show its series name in a tooltip or in the formula bar when the series is selected. Then reopen Select Data.
- Edit the series name. With the intended series selected, click Edit. In the Edit Series window, find Series name. You can type a short label directly, such as
Actual, or use the range-selector button beside the field and select a cell containing the name. To refer directly to a worksheet cell, with the series heading in cell B1 on a sheet named Sheet1, the reference is=Sheet1!$B$1. If the sheet name contains spaces, include single quotation marks around it, as in='Monthly Sales'!$B$1. Do not select the whole data column when you only want the heading. - Confirm the change. Click OK in the Edit Series window, then click OK again in Select Data Source. Check the chart legend and, if applicable, its data labels or title. A name entered as text stays as that text; a name linked to a cell reflects later changes to that cell.
- Save and verify the workbook. Save the file, then check that the series still displays the correct values and that the new wording is understandable in the legend. If the name looks clipped, widen the chart or move the legend rather than shortening a label that needs to remain precise. For a chart used in a report, review the chart at its final size as well.
Alternative: change the source heading. In many charts, Excel takes each series name from the heading above a column of values or beside a row of values. Find that heading in the worksheet and replace it with the desired wording. The chart will normally update immediately. This option is convenient when the heading should match the chart legend and any other uses of that data column. Use the Select Data method when you want a chart-specific label or cannot change the worksheet heading.
Common Mistakes
- Editing the chart title instead of the series name. The title describes the whole chart, while a series name identifies one set of plotted values. Use Select Data to change a series label; edit the title separately if needed.
- Changing the values range by accident. The Edit Series window contains fields for the series name, values, and sometimes category labels. Make changes only in Series name unless you deliberately intend to change what the chart plots.
- Selecting the wrong series. Two series may have similar names or adjacent colors. Confirm the selection before editing, especially in charts with many lines, stacked columns, or repeated categories.
- Typing a cell address as plain text. If you enter
B1without selecting a cell or entering a worksheet reference, Excel may treat it as the label itself. Use the range selector or a correctly formed reference such as=Sheet1!$B$1when you want the name to come from a cell. - Expecting every chart type to behave alike. A standard chart lets you edit its series in Select Data. PivotCharts are tied to PivotTable fields, and their labels may need to be changed in the PivotTable instead.
Tips
- Use a cell reference for a name that may change. If your source heading is maintained by another person or updated each month, linking the series name to that heading helps keep the legend in sync. It also avoids maintaining two versions of the same label.
- Keep names distinct and concise. Labels such as 2025 Actual and 2025 Forecast are easier to compare than two series both called Sales. Short labels are especially useful when a chart has several series or a narrow legend.
- Use the source heading when consistency matters. If the worksheet column heading is also used in a table or report, changing that heading may be better than applying a separate chart-only name. Check other workbook content that depends on the heading before changing it.
- Know when to switch rows and columns. In Select Data Source, Switch Row/Column changes how Excel groups data into series. It is not a renaming tool. If the chart suddenly shows a different set of series, undo or switch back, then edit the intended series name.
- Check the legend after editing. A longer series name can wrap, crowd out other entries, or make the legend take up more space. Resize the chart, reposition the legend, or use a clear shorter label if the chart must fit a fixed layout.
Troubleshooting
- Select Data is unavailable or the chart tabs are missing. First click the chart itself, not a worksheet cell or a chart object such as a text box. If the workbook is protected or opened read-only, you may not be allowed to edit the chart; check the workbook’s editing or protection status. If the chart is a PivotChart, use the PivotTable field-name guidance below.
- The series name changes back or does not stay changed. If its name is linked to a worksheet cell, the cell is the source of truth. Edit that cell instead, or use Select Data > Edit to enter a fixed text name. Also check whether a refreshed query, PivotTable, or workbook automation is restoring the source heading.
- The wrong line or columns changed. Reopen Chart Design > Select Data, compare the listed series names and order, and edit the intended entry. For charts with similar series, temporarily give each source heading a distinctive name so you can identify the correct one, then set the final labels.
- The chart still shows Series1 or Series2. Excel often assigns generic names when the source heading is blank or missing. Add a heading to the relevant source row or column, then check whether the chart updates. If it does not, use Select Data > Edit and link the series name to the heading cell.
- The name is cut off or not visible. The series may have been renamed even if the legend is too small to show all the text. Widen the chart, move the legend, or adjust the chart layout. If data labels are displayed, remember that their content and formatting are separate chart settings; changing a series name does not necessarily replace custom text in existing labels.
- You are using Excel for Mac or Excel for the web. On current Excel for Mac, select the chart and look for Chart Design > Select Data; dialog names and placement can vary slightly by release. Excel for the web has a more compact ribbon and some chart-editing controls may be limited. If you cannot find the series-name field in the browser, open the workbook in the desktop app and follow the Windows steps.
- The chart is a PivotChart. Its series names are usually based on PivotTable field items or value-field captions, rather than ordinary chart series settings. Rename the relevant field item or value field in the PivotTable, then refresh or check the chart. Avoid renaming the underlying source field if that change would disrupt other PivotTables or reports.
Frequently Asked Questions
Will renaming a data series change the worksheet data?
No, not when you enter a fixed name in the chart’s Series name field. It changes the chart’s label, not the values or source heading. If you rename the worksheet heading instead, that cell’s text does change.
Can I rename a series without changing its source column heading?
Yes. Select the chart, open Chart Design > Select Data, choose the series, click Edit, and enter the chart-specific name in Series name. This is useful when the worksheet heading needs to remain unchanged.
Can a series name update automatically?
Yes. Set the series name to a reference to a cell containing the desired label. When that cell’s text changes, the chart name should update too. A name typed directly into the dialog is a fixed label and will not follow changes to a worksheet heading.
Why does my chart show Series1 instead of my heading?
The source heading may be blank, outside the chart’s selected data range, or not recognized as a heading. Add or correct the heading and check the chart’s data range. You can also assign a name directly through the Edit Series dialog.
Can I rename several series at once?
Excel does not provide a single bulk-rename box for standard chart series. Edit each series individually, or change the corresponding source headings if the chart uses those headings. For many series, update headings in the worksheet and confirm that each chart points to the intended data.
Does this work for line, column, and pie charts?
The approach applies to many standard chart types, though the way series are represented differs. Pie charts typically show one data series split into slices, so renaming the series will not rename each slice’s category label. Change category names in the source data when you need different slice labels.
Related
- How to Print in Excel on One Full Page
- How to Print Excel on One Page Without Cutting Off Data
- How to Print in Excel Fit to Page Without Clipping
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Creating a Power Pivot in Excel: Steps and TipsTo create a Power Pivot in Excel for Microsoft 365 on Windows, enable the Power Pivot add-in if…
- Excel Line Chart With Multiple Series: A Step-by-Step GuideTo create a line chart with multiple series in Excel for Microsoft 365 on Windows, arrange each series…
- Excel Pivot Table: Show Only Filtered Data in Your Report?Yes. In Excel for Microsoft 365 on Windows, filter a PivotTable field using its dropdown, or add a…
- Fill Area in an Excel Chart: A Practical Step-by-StepTo fill an area in an Excel chart, select the data series, right-click it, choose Format Data Series,…
- Pivot Table Value Filter Not Working? Fix the CauseA PivotTable value filter usually seems broken because it is filtering a different summary than you expect, the…
- Excel Donut Chart: How to Make the Ring Wider and ThickerTo make an Excel donut chart’s ring thicker, select the ring, open Format Data Series, and reduce Doughnut…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.