The quickest way to change a legend title in Excel

Open your chart and double-click the legend to select it. Right-click the legend title itself (the text at the top or side of the legend box), then choose Edit Text. Type your new title and click outside the chart. That's the fastest route for most charts.

If that doesn't work, your chart may be using an older format or the legend title may be locked to the data. In that case, you'll need to use the Format Legend Title dialog instead, which gives you more control and works on any chart type Excel supports.

Key Takeaways

  • Double-click your chart to enter edit mode, then right-click the legend title and select Edit Text to type a new name directly.
  • If the legend title is grayed out or won't respond to right-click, use the Format Legend Title dialog by clicking the legend title once and opening the Format menu.
  • Legend titles in Excel charts are separate from the data labels in your spreadsheet, so changing one does not affect the other.
  • Some chart types (like pie charts) don't display a legend title by default, but you can add one through the Legend Options menu.

Entering chart edit mode and selecting the legend

Before you can change anything in a chart, you need to enter edit mode. Double-click anywhere inside the chart area. You'll see a gray border appear around the chart and the spreadsheet behind it will dim slightly. This tells you the chart is now active and ready for editing.

Once you're in edit mode, click on the legend box itself—the colored box that shows what each line, bar, or slice represents. The legend will show small square handles around its border when selected. Do not click the legend title yet; just select the whole legend first.

Selecting and editing the legend title directly

Now right-click on the legend title text itself—the words at the top or side of the legend box. A small menu will appear. Look for the option that says Edit Text and click it. The title text will become editable, and you'll see a cursor blinking inside it.

Delete the old text and type your new legend title. You can use any text you want: "Product Sales," "Regional Performance," "Quarterly Results," or anything else that describes what the legend shows. When you're done typing, click outside the chart to exit edit mode and save your change.

Using the Format Legend Title dialog for more control

If right-clicking the legend title doesn't show an Edit Text option, or if the title is grayed out and won't respond, you'll need to use the Format Legend Title dialog instead. Click the legend title once to select it (you should see small handles around just the title, not the whole legend). Then go to the Format menu at the top of the screen.

In the Format menu, look for an option called Format Legend Title or Format Selection. Click it, and a dialog box will open. Find the tab labeled Text Options or Fill depending on your Excel version. In the text area, you can type your new title. Click OK when you're finished, then click outside the chart to explore the change.

Adding a legend title when none exists

Some chart types—especially pie charts and doughnut charts—don't show a legend title by default. If you want to add one, you'll need to use the Legend Options menu. Double-click your chart to enter edit mode, then right-click the legend box (not the title, since there isn't one yet).

Select Format Legend from the menu. A dialog will open. Look for a tab or section called Legend Options or Legend Entry. You should see a checkbox or toggle for Show Legend Title or Display Legend Title. Check that box. A default title (often "Series 1" or "Legend") will appear. Follow the steps above to edit it to whatever you need.

Changing legend titles when data is linked

If your legend title is linked to a cell in your spreadsheet, changing the cell text will change the legend title automatically. To check if this is the case, click the legend title once in edit mode and look at the formula bar at the top of the screen. If you see a cell reference (like =Sheet1!$A$1), the title is linked to that cell.

You can either edit the text in that cell directly, or you can break the link and type a new title manually. To break the link, right-click the legend title, choose Edit Text, and type new text. This will replace the cell reference with plain text that won't change if the cell changes.

Troubleshooting legend title problems

If you double-click your chart and nothing happens, make sure you're clicking inside the chart area itself, not on the border. Some charts are embedded as objects and need a clear double-click to set up. If the legend title still won't select, try clicking the legend box first, then clicking the title text a second time.

If your changes aren't saving, make sure you're clicking outside the chart to exit edit mode. Changes made inside the chart won't stick unless you click outside the gray border. If the legend title is still locked or uneditable after trying both methods above, your chart may be using a protected template or an older Excel format. In that case, you can delete the legend and recreate it from scratch using the Chart Design menu.

Frequently Asked Questions

Can I change the legend title without entering edit mode?

No. You must double-click the chart to enter edit mode before you can edit any part of it, including the legend title. Once you're in edit mode, the legend becomes editable. If you try to click the legend while the chart is not in edit mode, nothing will happen.

Will changing the legend title affect my data in the spreadsheet?

No. The legend title is part of the chart object only. Changing it will not change any data in your spreadsheet cells. However, if the legend title is linked to a cell (you can see this in the formula bar), editing the cell will change the legend title automatically.

What if my legend doesn't have a title at all?

Some chart types don't display a legend title by default. Right-click the legend, select Format Legend, and look for an option to show or display the legend title. Once you enable it, a default title will appear that you can then edit using the steps above.

Can I use special characters or line breaks in a legend title?

You can use most special characters (like hyphens, parentheses, and symbols) in a legend title. Line breaks within the title text are not supported in the same way they are in cells, but you can make the legend box wider to let long titles wrap naturally.

Why is my legend title grayed out and won't let me edit it?

This usually means the chart is using an older format or the legend title is locked. Try using the Format Legend Title dialog instead of right-clicking. If that doesn't work, you may need to delete the legend and recreate it, or save the file in a newer Excel format.