Change a legend name by editing the data range or the legend entry itself

A legend in an Excel chart pulls its labels from your data — usually from the row or column headers you selected when you created the chart. To change what the legend says, you can either rename the source data in your spreadsheet, edit the legend entry directly in the chart, or adjust which cells Excel reads as the legend source. The fastest method depends on whether you want the change to affect your underlying data or just the chart display.

Excel gives you three main paths: edit the original cell (the legend updates automatically), rename the legend entry without touching your data, or swap out which data range the legend reads from entirely. Each approach takes about the same time, but they produce different results depending on what you need.

Key Takeaways

  • The simplest way to change a legend name is to edit the cell that contains the original label in your spreadsheet, and the chart updates automatically.
  • You can also right-click the legend entry in the chart itself and select "Edit Data Label" to rename it without touching your data.
  • If you need to change which data range the legend reads from, right-click the chart, select "Select Data", and modify the legend entries there.
  • Changes made directly to the chart legend do not affect your spreadsheet data, so your source numbers stay intact.

Edit the source data to change the legend automatically

The legend label comes from a cell in your spreadsheet. If you change that cell, the legend updates right away. Find the cell that contains the text the legend is showing — usually a column header or row header near your data — and type the new name.

For example, if your chart legend says "Sales Q1" and that text lives in cell B1, click B1, type "Revenue Q1", and press Enter. The chart legend changes instantly. This method works best when you want the new name to appear both in the spreadsheet and in the chart, because they stay linked.

Rename a legend entry directly in the chart

You can edit the legend text without changing your source data. Right-click the legend entry you want to rename — click directly on the text itself, not the legend box. A menu appears with options including "Edit Data Label" or "Format Data Label".

Click "Edit Data Label" and type the new name in the text field that appears. When you finish, the legend shows your new text, but the original cell in your spreadsheet stays unchanged. This approach is useful when you want a different name in the chart than in your data table. If right-clicking does not show an edit option, try double-clicking the legend entry instead — some versions of Excel respond to a double-click by opening an edit box directly.

Change which data range the legend reads from

If you want to swap out the entire legend source — for instance, use a different row or column as the legend labels — you need to access the Select Data dialog. Right-click the chart itself (not the legend) and choose "Select Data" from the menu.

The Select Data Source dialog opens. On the left side, you see "Legend Entries (Series)". Click the entry you want to change, then click "Edit". A dialog appears where you can point to a new cell or range that contains the label you want. Type the cell reference (like =Sheet1!$A$1) or click the cell directly, then click OK. This method is most useful when your data structure changes or you realize you selected the wrong column as your legend source when you first built the chart.

Use the chart design tools to manage legend labels

Excel's Chart Design tab (visible when you click the chart) also lets you control legend behavior. Click the chart to select it, then look for the Chart Design tab in the ribbon. Some versions show a small icon or button labeled "Select Data" or "Edit Data" — clicking it opens the same Select Data dialog described above.

You can also use the Chart Design tab to hide or show the legend entirely, move it to a different position, or change its formatting. These options do not rename the legend entries themselves, but they let you control how the legend appears alongside your chart. The legend position and visibility settings are often grouped together in the same menu.

Troubleshoot when the legend will not change

If you edit the source cell and the legend does not update, the chart may be using a hardcoded text value instead of a cell reference. Right-click the legend entry and look for an option to "Reset to Match Style" or check whether the data range is still linked to your spreadsheet.

If the legend entry is locked or protected, you may need to unprotect the sheet first. Go to the Review tab, click "Unprotect Sheet", and try again. If you still cannot edit it, the chart itself may be locked — right-click the chart border and look for an "Unprotect" option. Another common issue: you edited the cell, but the chart is showing a cached version. Click the chart, press F9 to recalculate, or close and reopen the file. If the legend still does not match your data, delete the chart and create a new one with the correct data range selected.

Frequently Asked Questions

Can I change a legend name without changing the data in my spreadsheet?

Yes. Right-click the legend entry in the chart and select "Edit Data Label" to rename it. The original cell in your spreadsheet stays the same, and only the chart legend shows the new name.

What if I have multiple series and want to rename just one?

Right-click the specific legend entry you want to change — the one that corresponds to that series. Edit or rename only that entry. The other legend labels stay as they are.

Does changing the legend name affect my chart data or calculations?

No. The legend is a label only. Changing it does not alter the numbers in your chart, the underlying spreadsheet data, or any formulas. It only changes what the legend displays.

How do I change the legend if I used a formula to create the chart?

If your chart data comes from a formula, edit the cell that the legend reads from, just as you would with static data. The chart updates automatically. If you need to change which formula result the legend displays, use the Select Data dialog to point to a different cell.

Can I rename the legend in an older version of Excel?

The steps are the same in Excel 2010 and later. Right-click the legend entry or use the Select Data dialog. If you are using Excel 2007 or earlier, the menu options may be slightly different, but the Select Data option should still be available when you right-click the chart.