Excel chart legends are edited by renaming the data series behind each entry using the Select Data dialog or the worksheet cells that supply the label.
Legend text in an Excel chart isn’t free‑standing — it comes directly from the data you’re charting. So when you need to fix a wrong name or make a label read more clearly, you change the source that drives it. Two official routes exist: edit the worksheet cell that holds the series name, or update the series name inside the Select Data dialog. Both update the legend instantly, and both take about ten seconds once you know where to look.
What Does Excel Use as Legend Text?
Excel pulls legend names from the cells adjacent to your data series. For a typical clustered column chart, the values in the table’s first column become the series names the legend displays. Microsoft’s support documentation confirms that “some chart types, such as Clustered Columns, use the cells to the left of each row as legend names.” [Microsoft support]
If you have multiple data series, each series gets its own legend entry. You edit them one at a time – changing one does not rename the others.
Method 1: Rename a Legend Entry by Editing the Worksheet Cell
This is the fastest approach when the legend name already lives in a cell you can reach.
- Locate the worksheet cell that contains the current legend name for the series you want to change.
- Click the cell and type the new name.
- Press Enter. The chart legend updates to the new text immediately.
This works because the legend is linked to that cell. Any change you make there flows through. The chart title stays unaffected – you are only editing the legend entry.
Method 2: Rename a Legend Entry Using Select Data
If you prefer to stay in the chart world, or if the series name isn’t directly tied to a worksheet cell you want to change, use the Select Data dialog.
- Click anywhere on the chart to select it. The Chart Design tab appears on the ribbon. (On older versions it may be labeled Design.)
- On the Chart Design tab, click Select Data.
- In the dialog, find the section Legend Entries (Series). Highlight the series whose legend text you want to change.
- Click Edit above the list.
- In the Series name field, type the new label (or enter a cell reference like
=Sheet1!$D$5to pull text from a specific cell). - Click OK, then OK again. The legend entry updates.
You can also right‑click the chart and choose Select Data from the context menu – it opens the same dialog.
Show, Hide, or Move the Legend
If the legend itself isn’t visible, or you want it somewhere else, the Chart Elements button (the plus sign near the upper‑right corner of the chart) is the quickest tool.
- Click the chart, then click the + icon.
- Check or uncheck Legend to show or hide the entire legend.
- Click the arrow next to Legend to pick a position: Right, Bottom, Left, Top, or Overlay.
A common trap: clicking the word “Legend” itself turns the legend off instead of opening the placement menu. Always click the small arrow to see position options.
Common Mistakes When Editing a Legend
| Mistake | Why It Happens | The Fix |
|---|---|---|
| Clicking “Legend” in Chart Elements hides the legend | The checkbox toggles visibility; the arrow opens options. | Use the arrow next to the checkbox, not the checkbox itself, to change placement. |
| Editing the chart title instead of the legend | The title and legend are separate elements; changing one does not affect the other. | Edit legend text through Select Data or the source cell, not the title box. |
| Changing one legend entry expects all to update | Each series has its own name; no automatic propagation. | Repeat the edit for every series whose legend text needs to change. |
| Legend still shows old value after typing a new name in Select Data | The Series name field may still point to a cell reference that overrides your typed text. | Replace the cell reference with a hard‑typed name, or update the referenced cell. |
| Trying to edit legend text by clicking it directly | Unlike the chart title, legend entries are not editable inline. | Use one of the two official rename methods above. |
How Do You Edit a Legend Without Changing the Data?
Sometimes the source data cell holds a value you need to keep, but you want a different label shown in the chart. Microsoft Learn guidance shows you can enter a direct text string or a point‑to‑a‑different‑cell formula in the Series name field in Select Data. [Microsoft Learn answer]
For example, if the original cell is =Sheet1!$B$2, replace it with =Sheet1!$D$5 to pull text from a different cell, or just type the new label directly (e.g., “2025 Sales”). The underlying data remains untouched, but the legend shows whatever you want.
Comparing the Two Main Editing Methods
| Method | Best For | When to Use |
|---|---|---|
| Edit worksheet cell | Fastest when the legend name is a cell you control, and you want the label to stay linked to that cell | Use when the data source itself should be updated and the chart follows automatically. |
| Edit via Select Data | More control when you need a custom label that’s different from the data | Use when you want a one‑off label, or the series name is not in an easy‑to‑edit cell. |
Final Checklist for Editing an Excel Legend
- Identify which series (data column) the legend entry belongs to.
- Choose your method: worksheet cell or Select Data.
- For multiple series, repeat the edit for each one.
- If the legend doesn’t show up at all, click the chart, press the + button, and check Legend.
- To format the legend box (border, font, fill), right‑click the legend and choose Format Legend – this does not rename entries but lets you change appearance.
That’s it. You now have two reliable ways to edit an Excel chart legend, plus the fixes for the most common mistakes that trip people up. Open your chart, pick the method that fits, and the legend will show exactly what you need.
References & Sources
- Microsoft Support. “Change Names in Legend Entries on a Chart.” Official documentation for renaming legend entries in Excel.
- Microsoft Learn Answers. “How can I change the legend text in a chart without changing the data?” Describes using a direct cell reference or text in the Series name field.