The quickest way to change a legend title in Excel
To change a legend title in Excel, right-click the legend box itself and select Edit Legend. A dialog opens where you can type a new title directly into the Legend Entries field. Click OK, and the change applies when ready. This works in Excel 2016, 2019, 2021, and Microsoft 365 on both Windows and Mac.
If that option does not appear, your version of Excel may require a different path: click the legend once to select it, then click it again to enter edit mode. You should see a text cursor. Type your new title and press Enter.
The legend title is separate from the legend itself — changing one does not affect the other. If you want to remove the title entirely rather than rename it, the same menu offers a delete option.
Key Takeaways
- Right-click the legend box and choose Edit Legend to open the dialog where you can type a new title.
- The legend title sits above or beside the legend box and identifies what the colors or patterns in your chart represent.
- Changes to the legend title do not affect the data in your chart, only how the legend is labeled.
- If Edit Legend does not appear in your menu, click the legend twice — once to select it, once to enter edit mode — then type directly.
Where the legend title appears on your chart
The legend title is the text that appears above or to the side of your legend box. In a sales chart with multiple product lines, for example, the legend might show colored squares next to "Product A," "Product B," and "Product C" — and the legend title would be something like "Sales by Product" or "Product Lines."
By default, Excel may label it "Series 1," "Series 2," or leave it blank. Changing the title to something meaningful makes the chart easier to read, especially if you are sharing it in a report or presentation.
The legend title is optional. You can have a legend without a title, or you can add one later if your chart did not start with one.
Step-by-step: the right-click method
Open your chart in Excel. If the chart is embedded in a worksheet (not a separate sheet), double-click it to enter edit mode — you will see a gray border around the chart.
Right-click directly on the legend box. A context menu appears. Look for Edit Legend or Format Legend. Click Edit Legend. A dialog box opens with fields for the legend title and entries.
In the dialog, find the field labeled Legend Title or Title. Clear the existing text and type your new title. Click OK. The chart updates when ready, and the new title appears on your legend.
Click outside the chart to exit edit mode and see the final result.
The direct-edit method if right-click does not work
Some versions of Excel do not show an Edit Legend option in the context menu. If that happens, use the direct-edit approach instead.
Double-click the chart to enter edit mode. Click the legend box once to select it — you should see selection handles (small squares) around the legend. Click the legend title text itself a second time. A text cursor appears, and you can now type directly into the title.
Type your new title and press Enter. The change takes effect when ready. Click outside the chart to exit edit mode.
Removing or hiding the legend title
If you want to remove the legend title altogether, the process is the same as renaming it. Right-click the legend, select Edit Legend, and delete the text in the title field. Leave it blank and click OK.
Alternatively, if you want to hide the entire legend (not just the title), right-click the legend and select Delete. The legend disappears from the chart. You can add it back later by going to the Chart Design tab, clicking Add Chart Element, and selecting Legend.
Why your legend title might not be showing
If your chart has a legend but no title appears above or beside it, Excel may have created the legend without a title by default. This is common in newer versions. To add one, follow the same steps: right-click the legend, select Edit Legend, and type a title in the title field.
Another reason a title might not show is if it is formatted with white text on a white background, making it invisible. If you suspect this, select the legend title and check the font color in the toolbar. Change it to a visible color like black or dark gray.
Changing the legend title formatting
Once you have set the title text, you can change how it looks. Right-click the legend title specifically (not the whole legend) and select Format Legend Title. A panel opens on the right side of the screen with options for font, size, color, and alignment.
You can make the title bold, italic, or larger to make it stand out. You can also change the text color to match your chart design. These changes are purely visual and do not affect the data or the legend itself.
Frequently Asked Questions
Can I have different legend titles for different series in the same chart?
No. The legend title applies to the entire legend, not to individual series. All series share the same legend title. If you need to label different groups differently, consider using data labels on the chart itself instead of relying on the legend title.
What if I change the legend title and it does not update?
Click outside the chart to exit edit mode, then click the chart again to refresh it. If the change still does not appear, make sure you clicked OK in the Edit Legend dialog. Some older versions of Excel require you to click the chart border to confirm changes.
Does changing the legend title change the data in my chart?
No. The legend title is purely a label for display. Changing it does not alter any numbers, formulas, or data in your worksheet or chart. You can rename the legend title as many times as you want without affecting your data.
Can I use special characters or line breaks in the legend title?
Yes, you can use most special characters. Line breaks are harder — Excel does not support them in the standard Edit Legend dialog. If you need a multi-line title, format the legend title text directly after creating it, though this may require manual adjustment.