How to Change Series Text in Excel Graph

Seeing "Series1, Series2, Series3" in your Excel chart's legend is a telltale sign of a report in progress, not one that's ready to share. While Excel does its best to guess your chart's labels, it often needs a little help. This article will walk you through the simple, yet essential, steps to change your data series names so your graphs are clear, professional, and easy to understand.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Renaming Your Series from the "Select Data" Dialog Box

The most straightforward method to change a series name is through the "Select Data Source" dialog box. This is the control center for your chart's data, giving you direct access to edit legends, axes, and the data ranges themselves.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step-by-Step Instructions:

1. Select Your Chart: Start by clicking anywhere on your chart. You'll see the chart area become highlighted, and two new tabs, "Chart Design" and "Format," will appear in the Excel ribbon at the top.
2. Open the "Select Data" Window: Go to the Chart Design tab. In the "Data" group, click on the Select Data button. A pop-up window titled "Select Data Source" will appear.
3. Choose the Series to Edit: In this new window, you'll see a box on the left labeled "Legend Entries (Series)." This list contains all the data series plotted on your chart, likely with names like "Series1" or whatever was in your header row. Click on the series you want to rename.
4. Click "Edit": With the series highlighted, click the Edit button located just above the list. This opens a smaller "Edit Series" dialog box.

From here, you have two great options for setting the new name.

Option A: Type a Custom Name Directly

The "Edit Series" window has a field called "Series name:". If you want to manually type a specific name, simply click into this box and type the new text you want to use (e.g., "Q1 Sales"). Click "OK" in the "Edit Series" window, and then "OK" again in the "Select Data Source" window. Your chart legend will instantly update.

When to use this: This is perfect for one-off charts or when the name won't ever change. It's a quick and simple fix.

Option B: Link to a Cell for a Dynamic Name

This is the more powerful and professionally preferred method. Instead of hard-coding the series name, you can link it to a cell in your worksheet. Typically, you'll link it to the column header containing your data.

In the "Series name:" field, instead of typing, you can either:

• Type the cell reference directly, like =Sheet1!$B$1.
• Delete any existing text in the box and then click on the specific cell in your worksheet that contains the desired name. Excel will automatically fill in the reference for you.

Click "OK" twice to close the windows. Now, your chart's series name is dynamically linked. If you ever update the text in that cell (e.g., changing "Q1 Sales" to "Quarter 1 Revenue"), the chart legend will automatically update to match. No more manual edits required!

When to use this: Use this method for almost any dashboard or recurring report. It makes your charts lower maintenance and ensures consistency between your data and your visualizations.

Changing the Series Name with the Formula Bar

If you're comfortable working with Excel formulas, you can skip the dialog boxes altogether and edit the series name directly in the formula bar. This can be much faster once you know what you're looking at.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

How a Series Formula Works

First, click on one of the data series within the chart itself — for example, click directly on a bar in a bar chart, a line in a line chart, or a pie slice in a pie chart. When you do, a formula will appear in Excel's formula bar at the top of your screen. It will look something like this:

=SERIES(Sheet1!$B$1, Sheet1!$A$2:$A$7, Sheet1!$B$2:$B$7, 1)

This formula may look complicated, but it's just telling Excel four things in order:

1. Series Name: Sheet1!$B$1 - This is the part we want to change. It's Excel's instruction on where to find the name for this series.
2. Category (X) Axis Labels: Sheet1!$A$2:$A$7 - The range containing labels for the horizontal axis (e.g., months, product names).
3. Series Values (Y) Axis Data: Sheet1!$B$2:$B$7 - The actual numerical data being plotted.
4. Plot Order: 1 - The order in which this series is plotted (relevant for charts with multiple series).

To change the series name here, you just need to edit the very first argument of the formula.

• To hard-code a new name: Replace the cell reference (Sheet1!$B$1) with your desired text enclosed in double-quotes. For example: "Total Revenue 2024". Your new formula would begin like this: =SERIES("Total Revenue 2024", ...
• To link it to a different cell: Simply change the cell reference to the correct one (e.g., from Sheet1!$B$1 to Sheet1!$C$1). Your new formula would begin: =SERIES(Sheet1!$C$1, ...

After editing the formula, just press Enter. Your chart will update immediately. This method is incredibly efficient once you're used to it.

Let Your Source Data Do the Work

Often, the reason your series is named "Series1" is because of how your source data is organized. Following best practices with your raw data setup can prevent the issue from happening in the first place.

Excel automatically looks for headers when you create a chart. It assumes the first row of your selection contains the series names, and the first column contains the category labels. If your chart shows a generic name, check two things:

1. Does Your Data Have a Header? Go back to your data table. Is the cell directly above your numbers (e.g., cell B1 is right above data in B2:B10) correctly filled with the name you want? If it's blank, that's your problem. Type a descriptive title in that cell, and Excel will often update the chart for you. If it doesn't automatically refresh, you can right-click the chart, choose "Select Data," and re-select your data range, making sure to include the new header row.
2. Did You Select the Header? When you first created the chart, you might have only selected the numerical data, not the header row above it. Without that header, Excel has nothing to use for a name and defaults to "Series1." The simplest fix is often to delete the chart and remake it, ensuring you include the header row in your initial data selection.

Organizing your data logically in a simple table with clear headers is the foundation of creating good charts quickly.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

How to Rename Series in a PivotChart

Changing series names in a PivotChart works a bit differently. Because a PivotChart is dynamically linked to a PivotTable, you can't just use the methods above. The series names are pulled directly from the field names in your PivotTable's "Values" area.

To change the name, you have to edit it in the PivotTable itself. Here's how:

1. In your PivotTable Fields panel (the task pane that usually appears on the right), find the field in the "Values" box. It will likely say something like "Sum of Price" or "Count of Product ID."
2. Click the small downward arrow next to the field name and choose Value Field Settings.
3. A dialog box will appear. The top field is "Custom Name." Simply type the new name you'd prefer here (e.g., change "Sum of Revenue" to just "Revenue").
4. Click OK. Both your PivotTable and your PivotChart will update with the cleaner, more readable name.

Pro Tip: You can also just click directly on the header cell in the PivotTable itself (the cell that says "Sum of Revenue") and type your new name there and press Enter. This is an even faster way to accomplish the same thing.

Final Thoughts

Renaming your chart series from the generic default is a fundamental step in turning raw data into a clear and compelling story. Whether you use the detailed 'Select Data' dialog, the quick formula bar edit, or simply fix your source data headers, you're taking control of your report and making it more professional and easier for your audience to interpret.

Manually creating reports and building perfectly formatted charts in tools like Excel is a weekly cycle many of us know too well, especially when data comes from disconnected sources like Google Analytics, Shopify, and your CRM. We built Graphed to eliminate that friction. Instead of wrestling with data imports and chart settings, you can connect your platforms once and then simply ask for what you need - "show me my sales revenue by marketing channel for last month" - and get a live, professional dashboard built in seconds.