How to Add Series Title in Excel Chart

You’ve wrangled your data, selected your ranges, and created a slick-looking chart in Excel. The bars are the right heights, and the lines trend correctly, but then you look at the legend and see the unhelpful default names: "Series1," "Series2," and "Series3." It’s a common frustration that can turn a data-driven masterpiece into a confusing mess. This tutorial will walk you through several easy methods for adding and changing your chart series titles in Excel, so you can make your data crystal clear and easy to understand.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Your Excel Chart Series Needs a Name

Before jumping into the "how," let's quickly touch on the "why." Default series names are one of the biggest red flags of a rushed or amateur report. Clarity is king in data visualization. When someone looks at your chart, they should instantly understand what each line, bar, or pie slice represents.

• Clarity and Readability: "Q1 Sales - North Region" is infinitely more descriptive than "Series1." Proper titles eliminate guesswork and allow your audience to grasp the insights immediately.
• Professionalism: Well-labeled charts show attention to detail and make your reports look more polished and trustworthy.
• Prevents Misinterpretation: Without clear labels, stakeholders might misread the data, leading to flawed conclusions and poor business decisions. Giving each series a proper name is the first step toward effective data storytelling.

Method 1: The Quickest Fix Using the "Select Data" Dialog Box

This is the most direct and common way to rename your series after a chart has already been created. It gives you precise control over each individual series name.

Step 1: Open the Select Data Source Window

First, click on your chart to select it. You'll see the chart borders and handles appear. Right-click anywhere on the chart area and choose "Select Data" from the context menu. This will open the Select Data Source dialog box.

Alternatively, with the chart selected, you can go to the Chart Design tab in the Excel ribbon and click on "Select Data."

Step 2: Edit the Desired Data Series

In the Select Data Source window, you'll see a panel on the left labeled "Legend Entries (Series)." This is a list of all the data series currently in your chart (likely named "Series1," "Series2," etc.).

Click on the series you want to rename (e.g., "Series1") and then click the "Edit" button located just above the list.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Add Your Series Name

After clicking "Edit," the Edit Series dialog box will appear. Here, you have two simple options for setting the series name.

Option 1: Manually Type the Name

The "Series name:" field will likely be empty or contain a funky formula. You can simply click inside this box and type the desired name directly — for instance, "2023 Revenue." This is great for a quick, one-off report.

When you're done, click "OK" on the Edit Series window, and then "OK" again on the Select Data Source window. Your chart's legend will instantly update with the new name.

Option 2 (Recommended): Link to a Cell

This is the more powerful and dynamic approach. Instead of typing the name, you can link the series title to a cell in your worksheet — usually a column or row header. This way, if you ever update the header in your data table (e.g., change "Revenue 2023" to "2023 Gross Revenue"), the chart will automatically update too!

In the Edit Series dialog box, click inside the "Series name:" field and delete any existing content. Then, simply click on the cell in your spreadsheet that contains the header text you want to use. You'll see the cell reference (like =Sheet1!$B$1) appear in the field.

Click "OK" twice to close the windows, and your series name is now dynamically linked.

Method 2: Including Headers When Creating Your Chart

The best way to fix a problem is to avoid it altogether. By setting up your data correctly from the start, you can make Excel do the work for you, automatically assigning the correct series names when you create your chart.

Step 1: Structure Your Data Correctly

Organize your data in a simple table format. Put your categories (like months or product names) in the first column, and then use the first row for your series labels (like "2022 Sales," "2023 Sales," and "2024 projections").

Here’s an example structure:

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Select Your Full Data Range (Including Headers!)

This is the key step. When you're ready to create the chart, don't just select the numbers. Click and drag your cursor to select the entire table, including the column headers ("Month," "2023 Revenue," "2024 Revenue Target") and categorical labels.

Step 3: Insert Your Chart

With the full range selected, go to the Insert tab on the Excel ribbon. Choose your preferred chart type from the "Charts" section (e.g., Column, Line, Bar).

Excel is smart enough to recognize that the first row of your selection contains the names for your data series and the first column contains the labels for your axis or categories. It will use these headers automatically, so your legend will be perfectly labeled from the moment the chart is created. No more "Series1"!

Method 3: Using the Formula Bar for Direct Editing

For those who feel a bit more comfortable with Excel formulas, this method offers a fast and powerful way to edit series names (and other series properties) without opening any dialog boxes.

First, click on the chart itself. Then, click on one specific series within the chart — for instance, click on one of the bars in a bar chart. When you do this, you'll see a formula appear in the Excel Formula Bar at the top of the worksheet. It will look something like this:

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

This formula might look complex, but it's pretty straightforward. It’s structured as:

=SERIES(<series_name>, <x_values>, <y_values>, <plot_order>)

The first argument in the formula is the series name! You can edit this directly:

• To link to a cell: You can simply edit the cell reference here. For example, change Sheet1!$B$1 to Sheet1!$C$1.
• To hard-code a name: You can replace the cell reference with a text string in double-quotes, like "Company A Revenue". The formula would then look like:

=SERIES("Company A Revenue", Sheet1!$A$2:$A$4, Sheet1!$B$2:$B$4, 1)

Press Enter after editing the formula, and your chart will update immediately. This method gives you ultimate control and is surprisingly quick once you get the hang of it.

Common Issues & Tips

Graphed

Still Building Reports Manually?

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

Watch the Demo

My Series Name is From the Wrong Cell

If Excel grabs the wrong header, it's typically because your data structure may be unconventional (e.g., merged cells, blank spacer rows). The "Select Data" (Method 1) is the perfect fix for this, as it lets you manually override any incorrect guesses Excel made.

Keep It Concise and Clear

Your series titles should be descriptive but brief. A long chart title can crowd the legend and make the chart harder to read. Use abbreviations where appropriate (e.g., "Q1" instead of "Quarter 1") and avoid repeating information that’s already in the chart title.

Changing Series Names in PivotCharts

It’s important to note that you cannot directly change series names in a PivotChart using the methods above. A PivotChart’s labels are directly tied to the field names in your PivotTable. To change the name, you must either change the header in the source data and refresh the PivotTable, or you can edit the field name directly in the PivotTable itself.

Final Thoughts

Renaming the default "Series1" is a small step that makes a huge impact on the clarity and professionalism of your Excel charts. Whether you prefer fixing it after the fact with the "Select Data" window, setting it up correctly from the start, or making quick edits in the formula bar, you now have the tools to make your data understandable at a glance.

While mastering these Excel tricks is rewarding, we know that getting insights shouldn't always require hours of manual report building. At Graphed , we created a tool that automates this entire process. You can connect your data sources (like Google Analytics, Shopify, QuickBooks, and even Google Sheets) and simply ask for what you want in plain English, like "Show me monthly revenue by product for the last quarter." We instantly build live, interactive dashboards for you, so you can spend less time wrangling charts and more time making data-driven decisions that grow your business.