How to Edit a Legend in Excel: A Complete Guide
Excel chart legends are small but mighty — they tell your audience what each data series represents. But the default legend Excel generates isn't always accurate, well-placed, or formatted the way you need it. Here's exactly how to edit, move, rename, and format legends in Excel charts.
What Is a Chart Legend in Excel?
A chart legend is the key that identifies each data series in your chart. It typically appears as a colored box paired with a label — for example, "Q1 Sales" next to a blue bar.
Excel generates the legend automatically based on your data series names, which it pulls from your spreadsheet. This means editing the legend usually involves one of two things:
- Changing the source data labels in your spreadsheet
- Adjusting the legend's appearance, position, or formatting directly on the chart
These are meaningfully different operations, and knowing which one you need saves a lot of frustration.
How to Rename a Legend Entry in Excel
Legend text in Excel reflects the series names in your data range — it doesn't exist independently. You can't simply double-click a legend label and type new text (at least not in the way you'd edit a text box).
Method 1: Edit the Source Data Directly
This is the most straightforward approach:
- Find the cell in your spreadsheet that contains the series name (usually a column or row header in your data table).
- Click that cell and type your new label.
- The legend updates automatically.
This works well when your data is structured with clear headers.
Method 2: Use "Select Data" to Rename a Series
When your data isn't neatly labeled, or you want the chart legend to show something different from your spreadsheet headers:
- Click on your chart to select it.
- Go to the Chart Design tab (or Design in older Excel versions) in the ribbon.
- Click Select Data.
- In the Legend Entries (Series) panel on the left, select the series you want to rename.
- Click Edit.
- In the Series name field, either reference a cell or type a custom name directly.
- Click OK.
This method lets you display a different name in the legend without changing anything in your underlying data — useful when you want cleaner chart labels without touching your source table.
How to Move or Reposition the Legend 📍
Excel gives you several placement options:
- Click the chart, then click the + (Chart Elements) button that appears at the top-right corner.
- Hover over Legend and click the arrow that appears.
- Choose from: Right, Top, Left, Bottom, or None.
Alternatively:
- Click directly on the legend to select it.
- Click and drag it anywhere inside the chart area.
You can also resize it by dragging the handles that appear when the legend is selected.
How to Format the Legend's Appearance
Once the legend is selected (single-click), right-click and choose Format Legend to open the formatting pane. From here you can control:
| Option | What It Does |
|---|---|
| Border | Adds or removes a box around the legend |
| Fill | Sets background color or makes it transparent |
| Font | Changes text size, color, and typeface |
| Shadow/Glow | Adds visual effects |
| Legend Position | Fine-tunes placement within or outside the chart |
To format individual legend entries differently (e.g., bold one label), double-click the legend to enter editing mode, then select just the text you want to change and apply formatting from the Home tab.
How to Show or Hide the Legend
- Click the chart, then click the + icon.
- Check or uncheck the Legend checkbox.
Hiding the legend is appropriate for single-series charts, where a title alone communicates the data clearly.
Common Issues When Editing Excel Legends 🔧
Legend shows "Series 1," "Series 2," etc. This means your data headers weren't included in the chart's data range. Use the Select Data method above to assign proper series names.
Legend entry color doesn't match the chart The color box in the legend is tied to the series color in the chart. Change the series color (right-click the data series → Format Data Series) and the legend color updates automatically.
Legend text is cut off Resize the legend box by dragging its edges, or reduce the font size via Format Legend → Text Options.
Legend appears outside the chart area This can happen after dragging. Select the legend and use the arrow keys to nudge it back inside, or reset position using the Chart Elements menu.
The Variables That Affect Your Approach
How you edit a legend depends on several factors specific to your setup:
- Excel version: The ribbon layout and option labels differ between Excel 2016, 2019, Microsoft 365, and Excel for Mac. The core functionality is the same, but menu paths can vary slightly.
- Chart type: Some chart types (like pie charts) handle legend entries differently than bar or line charts, because the legend entries correspond to data point labels rather than series names.
- Data structure: Tightly organized tables with clear headers make source-data edits simple. Pivot charts or charts built from non-contiguous ranges may require the Select Data dialog for any renaming.
- Purpose of the chart: A chart for a quick internal report has different legend requirements than one going into a formatted presentation or a published document, where visual precision matters more.
What's straightforward for a simple two-series bar chart can get more layered with a combination chart, a secondary axis, or data sourced from multiple sheets — and those situations each pull you toward different editing paths.