How to Rename Data Series in Excel

Tired of seeing "Series1" in your chart legend when you need to present valuable sales data? An unlabeled or poorly named data series in Excel can make an otherwise perfect chart confusing and unprofessional. This guide will walk you through three simple methods to rename any data series, turning your charts from ambiguous to crystal clear.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

First, What Is a Data Series in Excel?

In simple terms, a data series is a collection of related data points plotted in a chart. Think of it as a single line on a line chart, a set of bars of the same color on a column chart, or a slice of pie in a pie chart. Each series comes from a specific column or row in your spreadsheet.

For example, if you're charting quarterly sales figures for two different products, you'll have two data series: one for "Product A Sales" and one for "Product B Sales." Giving these series clear names is essential for anyone trying to interpret your chart. Generic names like "Series1" and "Series2" force your audience to decipher the data, defeating the purpose of creating a visual in the first place.

Clear, descriptive names provide immediate context and make your reports easier for everyone to understand. Let's look at a few ways to fix this.

Method 1: Use the "Select Data" Dialog Box (The Go-To Method)

The most common and reliable way to rename a data series is through the "Select Data" window. It gives you full control and lets you either type a name manually or link it to a cell - which is our recommended best practice.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Select Your Chart

Click anywhere on your chart. When you do, two new tabs will appear in the Ribbon at the top of your Excel window: Chart Design and Format.

Step 2: Open the "Select Data" Window

Navigate to the Chart Design tab and look for the "Select Data" button. Click it to open the "Select Data Source" dialog box. This is your command center for managing the data in your chart.

Step 3: Choose the Series and Click "Edit"

In the dialog box, you'll see a panel on the left labeled "Legend Entries (Series)." This is a list of all the data series currently plotted on your chart.

• Click on the series you want to rename (e.g., "Series1").
• Once it's highlighted, click the Edit button.

This will open a smaller "Edit Series" window where you can make your changes.

Step 4: Update the Series Name

Inside the "Edit Series" window, you have two options for the "Series name" field:

Option A: Type the Name Manually If you need a quick, static label, you can simply click into the "Series name" box and type your desired name. For instance, you could replace what's there with ="Q1 2024 Sales". The quotation marks are important if your name includes spaces or is text-based. This is quick but not flexible - if the name needs to change later, you have to repeat this process.

Option B: Link the Name to a Cell (Recommended) For a dynamic approach, link the series name to a cell in your worksheet, typically a column header. This is the smartest way to manage series names.

• In the "Series name" field, delete whatever is there currently.
• With your cursor still in that field, click directly on the cell in your spreadsheet that contains the correct name (for example, cell B1 that contains the header "Q1 Sales").
• The field will populate with a cell reference like =Sheet1!$B$1.

Click "OK" on the "Edit Series" window, and then "OK" on the "Select Data Source" window. Your chart's legend will now display the text from your chosen cell. The best part? If you ever update the text in cell B1, your chart will update automatically.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 2: Use the Formula Bar for a Quick Edit

If you're comfortable with Excel formulas and want to make a quick change without opening any menus, using the formula bar is a speedy alternative. Every data series in a chart is defined by a SERIES formula, which you can edit directly.

Step 1: Select the Data Series in Your Chart

First, click directly on the data series you want to modify within the chart itself. For instance, click on one of the bars in a column chart or on the line in a line chart. Be sure to select the entire series, not just a single data point.

Step 2: Find the SERIES Formula in the Formula Bar

With the entire series selected, look up at the formula bar just above the spreadsheet grid. You'll see a formula that looks something like this:

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

Step 3: Edit the First Argument of the Formula

Don't be intimidated by the formula. It's structured as SERIES(name, x_values, y_values, plot_order). The only part we care about right now is the very first argument - the series name.

• To add a static text name: Change the first part from a cell reference to your text in double quotes. For example, change Sheet1!$B$1 to "Regional Sales Revenue".
• To link to a different cell: Simply edit the cell reference. You could change Sheet1!$B$1 to Sheet1!$C$1 if that's where your new header is located.

After editing the formula, press Enter. Your chart will update immediately. This method is incredibly efficient for quick changes, especially if you already know the cell name you want to use.

Method 3: Structure Your Data Correctly from the Start

The easiest way to rename data series is to avoid having to rename them at all. By setting up your data correctly before you create your chart, you can ensure Excel automatically assigns the right names from the very beginning.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

The "Proactive" Approach: Including Headers in Your Selection

Before you insert a chart, make sure your data is organized in a clear table format with descriptive headers in the first row (or column).

For example, organize your data like this:

When you're ready to create your chart, make sure you select the entire range, including the headers ("East Region Sales" and "West Region Sales"). When you go to Insert > Chart, Excel is smart enough to recognize that the first row contains the names for your data series and will apply them for you. No manual renaming required!

If you've already created a chart and forgot a header, just use Method 1 to go back and link each series to its correct header cell.

Final Thoughts

Renaming your data series in Excel is a fundamental step that greatly improves the clarity and professionalism of your reports. Whether you prefer the control of the "Select Data" dialog, the speed of the formula bar, or the proactive approach of setting up your data correctly from the start, a properly labeled chart ensures your insights are understood instantly.

While mastering these Excel skills is valuable, manually updating charts - especially when pulling data from multiple sources - can quickly become a time-draining task. We created Graphed to streamline this entire reporting process. You simply connect all your data sources and then create comprehensive, real-time dashboards just by describing what you want to see in simple text. Instead of spending hours wrangling spreadsheets, you can get perfectly labeled charts and reports that update automatically in just a few seconds.