Change Legend Text by Editing the Source Data

The fastest way to change what your legend says is to edit the cell values that Excel is reading. When you create a chart, Excel pulls legend labels directly from your data — usually from column headers or row labels. If you change those cells, your legend updates automatically without touching the chart itself.

Open your spreadsheet and find the cells that feed your legend. For a column chart with sales data by region, this might be cells A2:A5 that contain "North", "South", "East", "West". Click the cell, type the new text, and press Enter. Your chart legend refreshes when ready. This method works for any chart type — pie, bar, line, area — as long as the legend is pulling from your worksheet.

The advantage here is that your chart stays linked to real data. If you ever update those cells again, the legend changes with them. You are not creating a separate label that can drift out of sync.

Key Takeaways

  • Excel legend text comes from your worksheet cells, so editing those cells updates the legend automatically.
  • You can also right-click a legend entry and select "Format Legend Entry" to change how it looks, but the text itself must come from your data.
  • If you need a legend label that does not match your data, create a helper column with the text you want and rebuild the chart to use that column instead.
  • Deleting a row or column from your data removes that entry from the legend, so check your chart after any data changes.

Edit Legend Text Through the Chart's Data Range

If you want to change the legend without editing your original data, you can modify which cells the chart reads. Right-click the chart and select "Select Data". This opens the Select Data Source dialog, which shows every series the chart is using and where it is pulling from.

In the dialog, you will see a list called "Legend Entries (Series)". Click the entry you want to change, then click "Edit". A small window appears with a text field labeled "Series name". This field shows the cell reference — something like "=Sheet1!$A$2" — that the chart is reading for that legend label. You can change this reference to point to a different cell, or you can type plain text directly into the field instead of a cell reference. Type your new legend text and click OK.

This approach is useful when your data labels are codes or abbreviations that you want to display differently in the legend. You keep your data clean and change only what the chart shows.

Rename a Legend Entry Without Changing Your Data

For a quick one-off change, you can edit the legend entry directly on the chart. Click the chart to select it, then click the specific legend text you want to change — for example, click the word "Sales" in the legend box. The text becomes editable and a cursor appears. Type your new text and press Enter.

Be aware that this breaks the link between the legend and your data. If you later edit the original cell in your worksheet, the legend will not update — it now contains text you typed manually instead of a reference to a cell. Use this method only when you are certain the legend text will not need to change again.

Use a Helper Column for Complex Legend Changes

If you need legend labels that are completely different from your data, create a new column with the text you want. For example, if your data has column headers like "Q1_2024" and "Q2_2024" but you want the legend to say "First Quarter" and "Second Quarter", add a helper column with those labels.

Then delete your chart and rebuild it using the helper column instead of the original headers. Select your data range to include the helper column, insert a new chart, and Excel will read the legend from the new column. This keeps your original data unchanged and gives you full control over what appears in the legend.

Fix Legend Text After Deleting or Moving Data

When you delete a row or column from your data, Excel removes that entry from the chart legend automatically. If you deleted something by mistake, undo the deletion with Ctrl+Z (or Cmd+Z on Mac) to restore both the data and the legend entry.

If you moved data to a different location, the chart may show a broken reference or a blank legend entry. Right-click the chart, select "Select Data", and update the cell references to point to the new location. Click "Edit" next to the series name and change the reference from the old cell to the new one.

Format Legend Text Appearance

Changing what the legend says is different from changing how it looks. Once your legend text is correct, you can adjust the font, size, and color. Right-click the legend itself (not a specific entry) and select "Format Legend". A panel opens on the right side with options for text formatting.

You can also right-click a single legend entry to format just that one. This is useful if you want to make one series stand out — for example, making "Target" bold or a different color. These formatting changes do not affect the text itself, only its appearance on the chart.

Frequently Asked Questions

Can I change legend text without editing my data?

Yes. Right-click the chart, select "Select Data", click "Edit" next to the series you want to change, and type new text directly into the "Series name" field instead of a cell reference. This keeps your data unchanged but breaks the automatic link — if your original data changes, the legend will not update.

What happens to the legend if I delete a row from my data?

The legend entry for that row disappears from the chart. If you deleted it by mistake, press Ctrl+Z to undo and restore both the data and the legend entry. If the deletion was intentional, the chart updates automatically.

Why does my legend show a cell reference instead of text?

This usually means the chart is reading from an empty cell or a cell with a formula error. Right-click the chart, select "Select Data", and check the "Series name" field for that entry. Make sure it points to a cell that contains actual text, not a blank or broken formula.

Can I have different legend text than my column headers?

Yes. Create a helper column with the text you want, delete your current chart, and rebuild it using the helper column instead of the original headers. Excel will read the legend from the new column.

Does changing legend text affect my data?

Only if you edit the cells that the legend is reading from. If you edit the legend text directly on the chart or through the Select Data dialog, your worksheet data stays the same.