How to Change Legend Name in Excel: A Complete Guide

Excel charts are powerful — but only when they communicate clearly. If your legend is showing generic labels like "Series 1" or "Series 2", your chart is doing half the job it could be. Changing legend names is one of those small edits that makes a significant difference in readability, especially when sharing workbooks with others.

Here's exactly how it works, what affects the process, and why different setups lead to different results.

What Is a Chart Legend in Excel?

A chart legend is the key that identifies each data series in your chart. It maps colors, patterns, or symbols to the data they represent. By default, Excel pulls legend text from the column or row headers in your source data range.

If your headers are clearly labeled ("Q1 Revenue," "Q2 Revenue"), your legend reflects that automatically. If your data has no headers — or you built the chart before labeling them — Excel falls back on placeholder names like Series 1, Series 2, and so on.

Understanding this source relationship is the key to changing legend names correctly.

Method 1: Edit the Source Data Header (Recommended)

The cleanest approach is editing the header cell in your spreadsheet that corresponds to the data series.

1. Locate the cell at the top of the column (or beginning of the row) that contains your data series
2. Click that cell and type your desired label
3. Press Enter
4. Your chart legend updates automatically — no further steps needed

This method keeps your data and chart in sync. It's the preferred approach for most users because the label lives in one place and flows naturally into the chart.

Method 2: Edit the Series Name Directly via Select Data

If you can't (or don't want to) change the header in your spreadsheet, Excel lets you edit the series name independently through the Select Data Source dialog.

1. Click anywhere on your chart to activate it
2. Go to the Chart Design tab (in the ribbon)
3. Click Select Data
4. In the dialog box, you'll see a list of your data series under Legend Entries (Series)
5. Select the series you want to rename and click Edit
6. In the Series name field, you can either:
   • Type a name directly (in quotes, as a static text label)
   • Or reference a cell by clicking the cell selector and choosing a cell from your sheet
7. Click OK, then OK again

This approach gives you flexibility — especially useful when your source data headers serve a different purpose in the spreadsheet and you don't want to rename them.

Method 3: Double-Click the Legend Entry 🖱️

In some versions of Excel (particularly Microsoft 365 and Excel 2019/2021), you can interact with the legend more directly:

1. Click the legend once to select it as a group
2. Click again on the specific legend entry you want to edit — this selects just that entry
3. Depending on your version, you may be able to edit it inline, or you'll be directed back to the Select Data dialog

This shortcut saves steps when you know exactly which entry needs changing, though its availability varies by Excel version and whether you're on Windows or Mac.

How Excel Versions and Platforms Affect the Process

Not all Excel environments behave identically. This is one of the key variables that determines your exact workflow:

Excel Online in particular has a reduced feature set compared to the desktop application. If you're working in a browser-based version of Excel and can't find the Select Data option, switching to the desktop app may be necessary to complete the rename.

Why Your Legend Name Might Not Be Changing ✏️

A few common reasons the change doesn't stick or doesn't appear:

• Linked cell reference: If the series name is referencing a cell, changing the dialog text won't override it — you need to clear the cell reference first
• Protected sheet: If the workbook or sheet is protected, editing source data or chart properties may be locked
• Chart is embedded in a grouped object: Clicking might select the group rather than the chart — double-click to enter the chart object
• PivotChart: Charts based on PivotTables pull their field names differently; renaming requires adjusting the PivotTable field names, not just the chart series settings

PivotCharts are a notable exception to the standard workflow. The legend in a PivotChart reflects the field names and item labels from the underlying PivotTable, so the editing path is different from a standard chart.

When Changing the Header Isn't an Option

Some users work with structured data where headers are fixed — shared databases, imported data feeds, or template files managed by someone else. In those cases, the Select Data → Edit Series Name method with a static text label is the cleanest workaround. It lets you display whatever label makes sense for the chart without touching the underlying data structure.

This is also relevant when one dataset is used to power multiple charts with different audiences — each chart can have its own legend labels while the source data stays untouched.

The Factor That Changes Everything

How straightforward legend renaming is depends heavily on what kind of chart you have, where your data lives, and which version of Excel you're running. A simple bar chart built from a clean table in Excel for Windows takes about 30 seconds. A PivotChart connected to a live data model, opened in Excel Online on a protected workbook, is a different problem entirely.

The mechanics are consistent — but the path to your specific legend edit depends on your own setup, data structure, and Excel environment. 📊