How to Rename a Data Series in Excel
Charts are one of Microsoft Excel’s most powerful features for visualizing data. Whether you’re creating sales reports, financial dashboards, project timelines, or scientific graphs, a well-labeled chart makes your data easier to understand. One important aspect of chart customization is the series name, which identifies each data series displayed in the chart legend.
By default, Excel often uses the column or row headers as series names. However, there are many situations where you may want to rename a series to make your chart more descriptive or professional. Fortunately, Excel provides several simple methods to change a series name.
This guide explains how to change a series name in Excel using different techniques, along with tips for managing chart data effectively.
What Is a Series Name in Excel?
A series is a collection of related data points plotted in a chart.
For example, if you have monthly sales data for three products, each product represents a separate data series.
A series name is displayed in:
- Chart legends
- Data labels (in some chart types)
- Chart filters
- Select Data Source dialog
Meaningful series names help viewers interpret charts more quickly.
Why Change a Series Name?
You might want to rename a series for several reasons, including:
- Improve chart readability
- Replace generic labels like “Series1”
- Reflect updated business terminology
- Make reports more professional
- Simplify presentations
- Clarify multiple datasets
Using descriptive names makes charts easier to understand, especially when sharing them with others.
Method 1: Change the Series Name Using the Select Data Dialog
This is the most common method.
Step 1: Select the Chart
Click anywhere on the chart.
Excel displays the Chart Design tab (or Chart tab, depending on your version).
Step 2: Open Select Data
Click:
Chart Design > Select Data
The Select Data Source window appears.
Image: Excel Select Data Source dialog with series list highlighted.
Step 3: Choose the Data Series
Under Legend Entries (Series):
- Select the series you want to rename.
- Click Edit.
Step 4: Enter the New Series Name
The Edit Series window opens.
You can:
- Type a custom name.
- Select a worksheet cell containing the desired name.
Click OK.
The chart legend updates immediately.
Method 2: Change the Header Cell
If the series name references a worksheet cell, editing that cell automatically updates the chart.
For example:
| Product | January | February |
|---|---|---|
| Laptop | 100 | 120 |
If “Laptop” is the series name, simply change it to:
- Laptop Sales
- Premium Laptop
- Product A
The chart updates automatically.
This method is ideal because it keeps your worksheet and chart synchronized.
Method 3: Edit the Formula Bar
Advanced users can modify the chart series formula directly.
Step 1: Click the Series
Select the chart.
Click the data series.
Step 2: View the Formula
The formula bar displays something similar to:
=SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$13,Sheet1!$B$2:$B$13,1)The first argument represents the series name.
Step 3: Modify the Name
You can replace the cell reference with:
- Another cell reference
- A text value enclosed in quotation marks
Example:
=SERIES("Annual Sales",Sheet1!$A$2:$A$13,Sheet1!$B$2:$B$13,1)Press Enter to apply the change.
Method 4: Rename Multiple Series
Charts often contain several data series.
Repeat the following steps for each series:
- Open Select Data.
- Choose a series.
- Click Edit.
- Update the name.
- Click OK.
This method works for:
- Line charts
- Bar charts
- Column charts
- Area charts
- Scatter charts
- Combo charts
Using Dynamic Series Names
Instead of manually typing names, link the series name to a worksheet cell.
Benefits include:
- Automatic updates
- Easier maintenance
- Better dashboard functionality
- Reduced manual editing
If the linked cell changes, the chart legend updates automatically.
This is especially useful for interactive reports and dashboards.
Changing Series Names in Pivot Charts
Pivot Charts work differently because their series names are generated from PivotTable fields.
To change the displayed series name:
- Rename the field in the PivotTable.
- Modify the source column heading.
- Refresh the PivotTable.
The Pivot Chart reflects the updated field name automatically.
Working with Multiple Charts
If multiple charts use the same data source:
- Changing the worksheet header updates every linked chart.
- Editing one chart’s series formula independently affects only that chart.
Understanding this distinction helps maintain consistency across reports.
Best Practices for Naming Data Series
Choose names that clearly describe the data.
Examples include:
- Monthly Revenue
- Operating Expenses
- Marketing Budget
- Website Traffic
- Customer Growth
- Product Sales
- Quarterly Profit
Avoid generic names such as:
- Series1
- Data
- Values
- Chart1
Descriptive labels make reports much easier to interpret.
Common Problems When Changing Series Names
Sometimes the series name does not update as expected.
Possible causes include:
- Incorrect cell reference
- Broken chart link
- Protected worksheet
- Hidden source data
- Pivot Chart limitations
Verifying the source data usually resolves these issues.
Tips for Better Chart Legends
A clear legend improves chart readability.
Consider these recommendations:
- Use concise names.
- Avoid unnecessary abbreviations.
- Keep capitalization consistent.
- Use descriptive business terms.
- Ensure each series has a unique name.
Professional legends help audiences understand charts more quickly.
Using Named Ranges for Series Names
Named ranges can make chart formulas easier to manage.
For example:
- Sales2025
- RevenueQ1
- ExpensesNorth
Using named ranges simplifies maintenance, especially in complex workbooks.
Difference Between Series Name and Chart Title
These two elements serve different purposes.
Chart Title
Describes the overall chart.
Example:
Annual Sales Report
Series Name
Identifies individual datasets.
Example:
- East Region
- West Region
- North Region
Both contribute to creating informative charts.
Frequently Asked Questions
Can I type a custom series name instead of using a cell reference?
Yes. When editing a series, you can either enter a custom text value directly or reference a worksheet cell. Linking to a cell is often more convenient because the chart updates automatically if the cell’s contents change.
Why does my chart still show “Series1”?
This usually happens when the chart was created without column or row headers, or when the header cell is blank. You can rename the series manually through the Select Data Source dialog or by updating the appropriate header cell.
Can I change series names without changing the worksheet data?
Yes. By editing the series directly in the Select Data Source dialog or modifying the chart’s SERIES formula, you can assign a custom name that is independent of the worksheet headers.
Do series names affect the chart data?
No. Changing a series name only updates the label displayed in the chart legend and related chart elements. It does not modify the underlying data values.
Can I rename series in all Excel chart types?
Most chart types, including column, bar, line, pie, scatter, and area charts, support custom series names. However, the exact editing options may vary depending on the chart type and whether the chart is based on a PivotTable.
Conclusion
Changing a series name in Excel is a simple yet effective way to make your charts more informative and professional. Whether you choose to edit the series through the Select Data Source dialog, update the worksheet header, or modify the SERIES formula directly, Excel provides flexible options to customize chart labels.