The quickest way to change a legend title

Open your chart in Excel, right-click directly on the legend itself (the box that shows what each color or line represents), and select Edit Legend Entry or Format Legend depending on your Excel version. A dialog box will open where you can type a new title or label for that legend entry. Click OK and the change takes effect when ready.

If you want to change the overall legend title — the heading that appears above all the legend entries — the path is slightly different. Click once on the chart to select it, then click on the legend itself. Go to the Chart Design tab at the top, find Add Chart Element, hover over Legend, and select Legend Title. A text box will appear on your chart where you can type the title you want.

Key Takeaways

  • Right-click the legend box itself to edit individual legend entries or change how the legend displays.
  • Use the Chart Design tab and Add Chart Element menu to add or modify a legend title that appears above all entries.
  • Double-click the legend title text box directly to edit it without opening menus.
  • Legend changes only affect the chart — they do not change the underlying data in your spreadsheet.

Editing individual legend entries

Each colored line, bar, or data series in your chart gets its own legend entry. If you want to rename one of these — for example, changing "Series 1" to "Q1 Sales" — right-click on that specific entry in the legend box. Select Edit Legend Entry (in Excel 2016 and earlier) or look for the entry in the Format Legend Entry pane that opens on the right side of your screen (in Excel 2019 and later).

The fastest way to change multiple entries at once is to go back to your original data. The legend pulls its labels directly from your spreadsheet — from row headers, column headers, or the names you gave your data ranges. If you change "Series 1" to "Q1 Sales" in the spreadsheet itself, the legend updates automatically the next time you refresh the chart.

Adding a legend title from scratch

Many charts start without a legend title at all — just the colored boxes and labels. To add one, click on the chart to select it. Then click the Chart Design tab in the ribbon at the top of Excel. Look for the Add Chart Element button (it looks like a plus sign in a box), click it, and hover over Legend

A submenu will appear with options including Legend Title. Click that option. Excel will add a text box labeled "Legend Title" directly above your legend entries. Click on that text box and type whatever heading you want — "Product Lines," "Regions," "Years," or anything else that describes what the legend shows.

Repositioning and formatting the legend title

Once you have added a legend title, you can move it by clicking and dragging the text box. You can also change how it looks — the font, size, color, or style. Click on the legend title text box to select it, then right-click and choose Format Legend Title. A pane will open on the right side where you can adjust text color, font size, bold, italic, and other formatting options.

If the legend title is in the way of your data or labels, drag it to a different position. The legend itself can also be moved by right-clicking the legend box, selecting Format Legend, and choosing a new position — top, bottom, left, right, or overlaid on the chart area.

Removing a legend title you no longer need

If you added a legend title but want to remove it, click on the chart, then click the Chart Design tab. Open Add Chart Element, hover over Legend, and select None. This removes the legend entirely. To keep the legend but remove only the title, click on the title text box itself and press Delete.

Alternatively, right-click the legend title and select Delete. The legend entries will remain, but the heading above them will disappear.

Common reasons legend changes do not appear

If you changed the legend title but do not see the change on your chart, make sure you clicked outside the chart afterward to deselect it and explore the change. Sometimes Excel shows the change only after you click away from the chart area.

If you edited the legend entry names in your spreadsheet but the chart legend did not update, the chart may not be linked to the original data range. This happens if the data was deleted or moved after the chart was created. Right-click the chart, select Select Data, and check that the data ranges listed match your current spreadsheet layout. If they do not, update them to point to the correct cells.

Frequently Asked Questions

Can I change the legend title without opening the chart in edit mode?

No. You must click on the chart to select it, then click inside it to enter edit mode before you can change the legend title. Once you click outside the chart, edit mode closes and you cannot make changes until you click the chart again.

What is the difference between a legend entry and a legend title?

A legend entry is the label for one data series — for example, "Product A" or "2023." The legend title is the heading that appears above all the entries, like "Products" or "Year." You can have many entries but only one title.

If I change the legend title, does it change the data in my spreadsheet?

No. The legend is part of the chart only. Changing legend titles or entry names does not affect the numbers or labels in your spreadsheet. However, if you change the data labels in the spreadsheet, the legend will update automatically to match.

Why does my legend not have a title option in the Add Chart Element menu?

Some older chart types or 3D charts have limited legend options. Try selecting a different chart type or checking that you are using Excel 2013 or later. If the option is grayed out, the chart type may not support legend titles.