How to Add a Legend in Excel Chart (And Customize It Your Way)

A chart without a legend is like a map without labels — technically readable if you already know what everything means, but confusing for anyone else. Excel makes adding and managing chart legends relatively straightforward, though the exact steps and options available depend on your version of Excel, your chart type, and how much control you want over the final result.

What Is a Chart Legend in Excel?

A chart legend is a small key that identifies what each color, pattern, or line in your chart represents. If you have a bar chart comparing sales across three product lines, the legend tells viewers which bar belongs to which product. Excel generates legend entries automatically based on your data series names — the column or row headers in your source data.

If your source data is labeled clearly, Excel's auto-generated legend is often good enough. If it isn't, you'll find yourself needing to edit the legend entries at their source rather than just clicking on the legend text directly.

How to Add a Legend to an Excel Chart

Method 1: Using the Chart Elements Button ➕

This is the fastest route in Excel 2013 and later (including Microsoft 365):

1. Click anywhere on your chart to select it
2. Look for the green "+" (Chart Elements) button that appears to the upper-right of the chart
3. Click it to open the Chart Elements panel
4. Check the box next to Legend
5. Hover over the Legend option to reveal an arrow — click it to choose placement: Right, Top, Left, or Bottom

If the legend was already hidden, this brings it back. If it was already showing, checking the box keeps it visible and lets you reposition it.

Method 2: Through the Chart Design Tab

1. Click your chart to activate the Chart Tools ribbon tabs
2. Go to Chart Design (sometimes called Design in older versions)
3. Click Add Chart Element in the upper-left of the ribbon
4. Hover over Legend
5. Select your preferred position from the submenu

This method gives you the same placement options and works across a broader range of Excel versions, including Excel 2010.

Method 3: Format Legend Pane for Precise Control

For more control over where the legend sits:

1. Right-click the legend once it's visible
2. Select Format Legend
3. The Format Legend pane opens on the right side of your screen
4. Under Legend Options, choose a position or check Show the legend without overlapping the chart
5. You can also adjust fill, border, shadow, and text formatting from this same pane

How to Edit Legend Text

Here's a point that trips up a lot of users: you cannot directly edit legend text by double-clicking it. The legend text is pulled from your data series names. To change what appears in the legend, you need to change the series name itself.

Editing Series Names via Select Data

1. Right-click the chart and choose Select Data
2. In the Select Data Source dialog, you'll see your series listed on the left under Legend Entries (Series)
3. Click a series name and then click Edit
4. In the Edit Series dialog, change the Series name field — either type a name directly or point to a cell in your spreadsheet
5. Click OK and the legend will update automatically

This approach also works if your legend is showing generic labels like Series 1, Series 2 — a sign that your source data headers weren't picked up correctly.

Legend Placement: What Works for Different Chart Types

Not every legend position works equally well for every chart. Here's how placement tends to behave across common scenarios:

These are general patterns — your actual layout will depend on how much data you're displaying and the chart's proportions.

Hiding or Removing the Legend

If you want to remove the legend entirely:

• Click the legend to select it, then press Delete
• Or uncheck Legend in the Chart Elements panel

This is sometimes the right move for simple single-series charts, where the chart title alone makes the data self-evident. For multi-series charts, removing the legend usually creates confusion unless you're using data labels as an alternative.

Formatting the Legend Visually 🎨

Beyond placement, you can style the legend to match your design:

• Font size and color — right-click the legend, select Font or use the Home tab while the legend is selected
• Background fill — in the Format Legend pane, add a solid fill or gradient to make the legend stand out
• Border — add a box around the legend for a more formal or print-ready look
• Legend entry size — individual legend marker sizes can sometimes be adjusted through series formatting rather than the legend itself

Excel's formatting options vary slightly between Windows and Mac versions. The Mac version of Excel (particularly older builds) has fewer right-click options and relies more heavily on the Format menu in the top navigation bar.

What Affects Your Results

The experience of adding and customizing a legend differs based on a few key variables:

• Excel version — Microsoft 365 has the most current interface; Excel 2010/2013 users may see different menu layouts
• Chart type — some chart subtypes (like 3D charts or stock charts) have restricted legend formatting options
• Data structure — poorly labeled source data means the legend will reflect those unclear names until you rename your series
• Number of series — charts with many series can produce crowded legends that need manual resizing or repositioning to remain readable

Whether a right-side legend works better than a bottom legend, or whether your data labels make the legend redundant entirely, comes down to how your chart is sized, how many series you're displaying, and who your audience is.