How to Rename Legend in Excel Chart

Renaming the default "Series1, Series2..." in your Excel chart legend is one of the quickest ways to make your data understandable. Instead of forcing your audience to guess what the colors mean, a clear legend turns a confusing visual into a compelling story. This article will show you three easy methods to edit your legend names, from the quickest fix to the most flexible and future-proof approach.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What is an Excel Chart Legend and Why Rename It?

Think of a chart legend as the key to a map. It’s a small section of your chart that deciphers the visual elements, explaining which data series each color, pattern, or symbol represents. Without a clear legend, you're just looking at a collection of lines and bars with no context.

Excel does its best to automatically create a legend based on your source data, but it often needs a little help. You'll likely want to rename a legend for a few common reasons:

• Vague Default Names: If you create a chart without properly formatted headers, Excel will simply name your data series "Series1," "Series2," and so on. This is meaningless to anyone looking at your chart.
• Clunky Source Data Headers: Sometimes the column or row headers in your worksheet are long or contain technical terms that aren't suitable for a clean chart presentation (e.g., "Q4_Revenue_Actuals_Final" could be simplified to "Q4 Actuals").
• Adding More Context: You might want to add extra information that isn't in your data table, like changing "Sales" to "Sales (in thousands)" for clarity.

Ultimately, a well-named legend ensures your chart can be understood at a glance, without needing to refer back to the raw data.

Method 1: Rename by Directly Editing the Source Data (Best Practice)

This is the most reliable and efficient way to manage your legend names. By changing the name in the source data cell (usually a column or row header), the chart legend updates automatically. This method maintains the dynamic link between your data and your chart, which means any future changes to the headers will be reflected instantly.

It's the "set it and forget it" approach and is considered the best practice for charts that need regular updating.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step-by-Step Instructions

Let's say we have the following data and the resulting chart. Notice the legend names "Website_Visitors" and "MQL_Generated" are a bit technical and could be cleaner.

1. Locate the Source Data Cell: Identify the cells in your worksheet that house the titles for your data series. In our example, these are cells B1 and C1.
2. Edit the Cell Text: Click directly into the cell you want to change. In this case, we'll click on cell B1.
3. Type the New Name: Replace the existing text with your desired legend name. Let's change "Website_Visitors" to "Visitors." Press Enter.
4. Watch the Magic Happen: Your chart legend will update in real time. The legend entry that was "Website_Visitors" now reads "Visitors."

Repeat the process for any other legend entries. We'll change "MQL_Generated" in cell C1 to "Leads." The chart is now much easier to read and understand.

Why is this the best method? Because your chart remains linked to your data. If you decide next month that "Leads" should be called "Marketing Qualified Leads," you only have to change it in one place — cell C1 — and your chart is instantly correct.

Method 2: Use the 'Select Data Source' Menu (Most Powerful)

This method gives you the most control over your legend. It's especially useful when the name you want to use for the legend isn't located directly next to your data or if you want to write a custom name without adding it to your worksheet.

The 'Select Data Source' menu allows you to manually tell Excel where to find the series name, or even type one in yourself.

Step-by-Step Instructions

1. Open the Select Data Menu: Right-click anywhere on your chart and choose "Select Data..." from the dropdown menu.
2. Choose the Series to Edit: The 'Select Data Source' dialog box will appear. On the left side, under "Legend Entries (Series)," you’ll see the list of your data series. Click on the series you want to rename. In our example, let's select "Visitors" and click the "Edit" button.
3. Edit the Series Name: A new 'Edit Series' window will pop up. The field you're interested in is the very first one: "Series name."

From here, you have two options:

Option A: Link to a Different Cell

Let's say you have a different, more descriptive title in another cell (e.g., cell E5 contains "Total Website Visitors"). Inside the 'Series name' box, delete the existing cell reference (e.g., =Sheet1!$B$1). Then, either type the new cell reference directly or simply click on the cell in your spreadsheet that contains the name you want to use. You'll see the formula update. Click "OK."

Graphed

Still Building Reports Manually?

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

Watch the Demo

Option B: Manually Type a Custom Name

You can also just type a new legend name directly into the 'Series name' box. This is useful for one-off presentations where you don't need a dynamic link. For this to work correctly, you must overwrite whatever formula is in there first. For example, you could type "Monthly Visitors" directly into the box. Then click "OK" twice to close the windows.

Important Note: Manually typing a name like this makes it static. It will not update if you change your source data headers. This method is best reserved for final reports or when the legend text won't need to change.

Method 3: A Quick Direct Edit on the Chart (For Static Reports)

If you're in a hurry and making a chart that you don't plan to update later, this is the fastest way to change a legend name. However, be warned: this method breaks the link between the legend and your source data. A change in the data source header will no longer be reflected in the legend after performing this edit.

Step-by-Step Instructions

1. Select the Legend Entry: First, click once on the legend box on your chart. You'll see a bounding box appear around the entire legend area.
2. Select the Specific Name: Now, click a second time (slowly, this is not a double-click) directly on the specific legend name you wish to change. The individual text entry will become editable, just like a cell in the worksheet.
3. Type Your New Name: You can now type your new legend name directly. For example, "Series1" can be changed to "2024 Revenue." Once done, press the Enter key.

The legend will instantly update with the new text. While incredibly fast, remember this is a static change. Use it cautiously for quick, one-time charts, but stick to Method 1 for any dashboards or reports you'll need to refresh over time.

Troubleshooting Common Issues

Graphed

Still Building Reports Manually?

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

Watch the Demo

"I'm using a PivotChart, and I can't edit my legend!"

PivotChart legends are controlled by the fields in your PivotTable. To rename the legend, you must rename the field itself within the PivotTable Fields pane or by changing the header in the source data and refreshing the PivotTable. You cannot directly edit the legend on a PivotChart as described in Methods 2 or 3.

"My legend entry is showing a date instead of a name."

This often happens when your data headers are formatted as dates. Excel can misinterpret the date as part of the data series. The easiest fix is to go to the header cell, reformat it as 'General' or 'Text' on the Home tab, re-type the header, and your chart should update correctly.

Final Thoughts

Customizing your Excel chart legends is a small step with a big impact on clarity. Method 1 (editing the source data) is your best bet for reports that will be reused or updated, while Method 2 (using 'Select Data') offers ultimate control for unique situations. Method 3 (direct editing) is your go-to for a quick, static fix when you just need to get it done.

While mastering these small Excel tweaks is useful, the modern way to get answers from your business data avoids this manual work altogether. Instead of logging into a dozen platforms and meticulously formatting charts, we built Graphed to simplify the entire process. Just connect your SaaS tools like Google Analytics, Shopify, or Salesforce once, then ask for the dashboard you need in plain English. Graphed builds it instantly, keeping your reports live and updated so you can focus on insights, not on figuring out where the "select data" menu is.