How to Edit Legend Text in Excel | Linked vs. Static Methods

Editing legend text in an Excel chart takes either a cell edit on the worksheet or a typed name in the Select Data Source dialog box.

A chart that reads “Series1” or “Series2” looks unfinished and forces anyone reading it to guess what the data represents. The task of figuring out how to edit legend text in Excel comes down to two straightforward methods, and neither requires changing your actual chart data. One keeps the legend linked to a worksheet cell so it updates automatically, and the other lets you type a fixed label that stays put no matter what happens in the spreadsheet. The right choice depends on whether the source name might change later.

Edit the Worksheet Cell for a Linked Legend

The simplest route keeps the legend tied to the cell that supplies the series name. Click the cell on the worksheet that currently holds the label — the same one that appears in the chart legend. Type the new name and press Enter. The legend updates immediately to match.

This method works best when the source data names change periodically, because the legend follows the cell every time. If you update the cell next quarter, the chart reflects it without extra steps. The trade-off: the legend is fully dependent on that cell, so deleting or moving the cell breaks the label.

Use the Select Data Source Dialog for a Static Label

When you need a one-time label that stays fixed regardless of worksheet changes, the Select Data Source dialog gives you full control without touching the data.

Select the chart, then go to the Chart Design tab on the Ribbon. In the Data group, click Select Data. Under Legend Entries (Series), pick the entry you want to change and click Edit. In the Edit Series dialog, find the Series Name box. Delete the cell reference — something like =Sheet1!$D$5 — and type the exact text you want. Click OK twice to close both dialog boxes. The legend updates with your typed text, and the underlying numerical data stays untouched.

Microsoft’s official documentation covers the full sequence for both Windows and Mac. Microsoft’s modify chart legend entries guide walks through each step with screenshots.

One behavior catches people off guard: typing text instead of a cell reference breaks the link to the worksheet. If you later change the original cell, the legend won’t move with it. To re-link, follow the same steps but use the Collapse Dialog button next to the Series Name field to select a worksheet cell instead of typing.

What About Excel on a Mac?

The Mac version uses a slightly different path to reach the same dialog. Right-click the chart legend and select Select Data from the context menu. Under Legend Entries (Series), click the entry to edit. In the Name field on the right side, replace the existing text. Click OK to apply the change. The result is identical — a static label that does not link back to a cell unless you enter a cell reference manually.

The table below lays out every route in one view so you can pick the one that matches your version of Excel.

Common Mistakes When Editing Legend Text

A few simple mix-ups cause most of the frustration around legend edits. Knowing them ahead of time saves rework.

Clicking the word “Legend” instead of the arrow. In the Chart Elements menu, clicking the word “Legend” directly removes the legend from the chart entirely. Hover over “Legend” until a small arrow appears, then click the arrow to choose a position. The CustomGuide tutorial on editing a legend in Excel demonstrates this behavior clearly.

Assuming the typed name stays linked. Typing text in the Series Name box produces a static label that won’t update when the worksheet cell changes. To keep the link, enter a cell reference in the box rather than plain text.

Editing the wrong series in a multi-series chart. The Legend Entries list shows all series in the chart. Select the wrong one and you change the wrong label. Verify the current name in the list before clicking Edit.

Pressing Delete on a legend entry. Deleting an entry from the dialog removes the entire data series from the chart, not just the label. Use the Edit button to change the text instead.

Relying on the mobile app for the full dialog. The Select Data Source dialog is not fully accessible on iOS or Android. Edit the source cell directly on the worksheet when working from a phone or tablet.

Which Method Should You Pick?

Use the edit source cell method when the label comes from a worksheet cell that you update periodically — quarterly reports, rolling forecasts, or dashboards that pull new data. The legend follows automatically, so you never have to remember to update it separately.

Use the Select Data Source dialog when you need a one-time presentation label, when the source cell is far from the chart, or when you want to freeze the legend text so it doesn’t drift after someone edits the spreadsheet. This is the safer choice for PDF exports, slide decks, and printed materials where the label must match exactly what you intended.

On mobile or in Excel for the Web, stick with editing the source cell directly. The full dialog is unreliable on phones and behaves differently in the browser, but changing a cell works the same everywhere.