Changing a Legend Name in Excel

To change a legend name in Excel, right-click the legend entry you want to rename, select "Edit Data Label" or "Format Legend Entry," and modify the text directly. The method depends on whether you want to rename the legend itself, the data series it represents, or individual legend entries. Most of the time, the fastest route is to change the source data in your spreadsheet — Excel updates the legend automatically when you do.

If you are working with a chart that already exists, you have three main paths: edit the legend entry text directly on the chart, change the data series name in your worksheet, or use the Select Data Source dialog to rename entries. Each method works in different situations, and knowing which one applies saves you from clicking through menus that do not have what you need.

Key Takeaways

  • The simplest method is to change the data series name in your spreadsheet — Excel automatically updates the legend when you edit the cell that contains that name.
  • You can also right-click a legend entry on the chart itself and edit the text directly without touching your source data.
  • The Select Data Source dialog (accessed by right-clicking the chart and choosing "Select Data") lets you rename multiple legend entries at once.
  • Changes made directly on the chart are not linked to your spreadsheet, so if you edit the source data later, the legend reverts to the original name.

Method 1: Change the Data Series Name in Your Spreadsheet

This is the most reliable method because it keeps your legend linked to your data. Open your spreadsheet and locate the cell that contains the name of the data series you want to change. In most cases, this is a header cell at the top of a column — for example, if your legend says "Sales Q1" and that name comes from cell B1, you would click B1 and type the new name directly.

After you change the cell text and press Enter, click on your chart. Excel updates the legend automatically within a second or two. This method works because the legend pulls its names from the source data, not from stored text on the chart itself. If you later edit your spreadsheet data, the legend stays correct because it is still reading from those same cells.

Method 2: Edit the Legend Entry Directly on the Chart

If you want to change the legend without editing your spreadsheet, you can edit the text right on the chart. Click the chart to select it, then click the specific legend entry you want to rename. A text cursor appears, and you can type the new name directly. Press Enter when you are done.

Be aware that this method breaks the link between your legend and your source data. If you later change the data series name in your spreadsheet, the legend will revert to that original name, overwriting your chart edit. Use this method only when you are certain you will not be changing the source data, or when you want the legend to display something different from the actual data series name.

Method 3: Use the Select Data Source Dialog

For more control over multiple legend entries at once, right-click your chart and select "Select Data." The Select Data Source dialog opens, showing a list of all data series in your chart on the left side. Click the series name you want to change, then click "Edit" below the list.

A small dialog appears with a field labeled "Series name." This field shows either a cell reference (like =$B$1) or plain text. If it shows a cell reference, you are seeing the link to your spreadsheet — editing this field will break that link and replace it with static text. Type your new name and click OK. The legend updates when ready. You can rename multiple series by repeating this process for each one.

Timing and Common Mistakes

Changing a legend name takes seconds once you know which method to use, but choosing the wrong method can create problems later. The most common mistake is editing the legend text directly on the chart and then forgetting that it is no longer linked to your data. Six months later, someone updates the spreadsheet, the legend reverts, and you spend time hunting for what went wrong.

Another frequent error is trying to edit a legend entry by double-clicking it. In some versions of Excel, double-clicking a legend entry selects the entire legend instead of opening an edit dialog. If this happens, right-click instead — the context menu gives you the options you need. Always verify that your change took effect by clicking outside the chart and then clicking it again to see the final result.

When to Use Each Method

Use Method 1 (editing the spreadsheet) when you own the data and plan to maintain it over time. This keeps everything in sync and prevents confusion later. Use Method 2 (editing the chart directly) when you are creating a one-time report or presentation and you want the legend to say something different from the raw data name — for example, changing "Series1" to "Monthly Revenue" for a client-facing chart. Use Method 3 (the Select Data Source dialog) when you have a complex chart with many series and you want to rename several at once, or when you need to see all your series names in one place.

If you are working in a shared spreadsheet or a file that others will update, always use Method 1. It ensures that your legend stays accurate no matter who edits the data. If you are the only person working with the file and you never plan to change the source data, any method works — choose whichever feels fastest to you.

Frequently Asked Questions

What if I cannot find the legend entry when I right-click?

Make sure you are clicking directly on the legend itself, not on the chart background. The legend is usually a small box with colored squares or lines and text labels, often positioned to the right or below the chart. If you click the chart area instead, you get a different menu. Click once on the chart to select it, then click once on the legend box to select it, then right-click.

Can I change the legend title separately from the series names?

Yes. Right-click the legend title (the text at the top of the legend box, if one exists) and select "Edit Legend Title." A text cursor appears and you can type a new title. Some charts do not have a legend title by default — if yours does not, you can add one by right-clicking the legend and selecting "Add Legend Title."

Why does my legend still show the old name after I changed the spreadsheet?

The chart may not have refreshed yet. Click outside the chart to deselect it, then click it again. If the name still has not changed, you may have edited the legend text directly on the chart at some point, which broke the link to your spreadsheet. Use Method 3 to check: right-click the chart, select "Select Data," click the series, and click "Edit." If the Series name field shows plain text instead of a cell reference like =$B$1, that is your problem — delete the text and type the cell reference instead.

Can I rename a legend entry if I do not have the original spreadsheet?

Yes, but only by editing the chart directly (Method 2). Right-click the legend entry and edit the text. Keep in mind that this text will not update if the chart is ever linked to new data, and if someone else opens the file and updates the source data, your custom name will disappear.