What a legend does and when you need one
A legend in Excel is a box that labels the different data series in your chart. If you have a chart showing sales by region, the legend tells you which color or pattern represents North, South, East, and West. Without it, your chart is just colored bars or lines with no way to know what they mean.
You need a legend whenever your chart shows more than one data series — that is, more than one line, set of bars, or group of values. A single-series chart (one line, one set of bars) may not need one. A chart comparing multiple things across time almost always does.
Excel adds a legend automatically when you create most chart types, but it often lands in the wrong spot or includes entries you do not want. Learning to move it, resize it, and control what appears in it makes your charts readable at a glance.
Key Takeaways
- Excel adds a legend by default to most charts, but you can move it, hide it, or edit it using the Chart Design tab.
- Right-click the legend itself to change its position, font size, or whether it shows at all.
- If your legend includes unwanted entries, delete those data series from your chart or hide them in the source data.
- A legend works best when placed to the right or below the chart, where it does not cover the data you are trying to read.
Adding or showing a legend that is hidden
If your chart has no legend or the legend has been turned off, you can add one back in seconds. Click anywhere on the chart to select it — you will see a border around the entire chart area. At the top of the screen, the Chart Design tab appears in the ribbon.
Click Chart Design, then look for the Add Chart Element button (it looks like a plus sign with a small chart icon). A dropdown menu opens. Hover over Legend and you will see four position options: Right, Top, Left, and Bottom. Click the one you want. The legend appears when ready in that location.
If you do not see the Chart Design tab, click the chart once more to make sure it is selected. The tab only appears when a chart is active.
Moving the legend to a better spot
The default position is usually the right side of the chart, which works well for most layouts. But if your chart is tall and narrow, a legend on the right eats up space. If it is wide and short, a legend below it might work better.
Click the chart to select it, then click Chart Design. Click Add Chart Element, hover over Legend, and choose a new position. The legend moves when ready. You can also right-click the legend box itself and select Format Legend. A panel opens on the right side of the screen where you can choose Legend Position and pick Right, Left, Top, Bottom, or Top Right Corner.
If you want the legend in a custom spot not listed in the menu, drag it by hand. Click and hold the legend box, then drag it anywhere within the chart area. Release to drop it in place.
Removing entries from the legend
Sometimes your legend includes data series you do not want to display. For example, you might have a column in your spreadsheet for notes or totals that Excel included in the chart by mistake. The legend shows it, but you do not want it there.
The cleanest way to fix this is to remove that data series from the chart entirely. Right-click the unwanted series (the line or bars themselves, not the legend) and select Delete. The series and its legend entry both disappear. If you need that data later, you can undo the deletion or edit the chart's data range to add it back.
Alternatively, click the chart, then click Chart Design and select Select Data. A dialog box opens showing all the data series in your chart. Highlight the series you do not want and click Remove. Click OK. The legend updates to match.
Changing how the legend looks
You can make the legend text larger, change the font, or adjust the box itself. Right-click the legend and select Format Legend. A panel opens on the right side of the screen.
Under Legend Options, you can choose whether the legend appears at all (toggle it on or off), where it sits, and whether it overlaps the chart. Under Text Options, you can change the font, size, and color of the legend text. Under Fill & Line, you can add a border around the legend box or change its background color.
Most of the time, the defaults work fine. The main reason to adjust the legend is to make the text larger if it is hard to read, or to move it so it does not hide part of your data.
Hiding the legend entirely
If your chart is straightforward enough that it does not need a legend — for example, a single line showing one company's revenue over time — you can turn it off. Click the chart, then click Chart Design. Click Add Chart Element, hover over Legend, and select None. The legend disappears.
You can always turn it back on the same way. This is useful when you are building a chart step by step and want to see how it looks without the legend taking up space.
Editing legend text and labels
The legend pulls its labels from the names of your data series. If your spreadsheet column is labeled "Q1 Sales" and that is the series name, the legend shows "Q1 Sales." To change what the legend says, you change the series name in your data.
Click the chart to select it, then click Chart Design and select Select Data. The Select Data Source dialog opens. Highlight the series you want to rename and click Edit. A small dialog appears with a text field showing the current name. Type the new name and click OK. The legend updates when ready.
Do not try to edit the legend text directly by clicking on it — Excel will not let you. The legend always reflects what is in your data, so change the source if you want the legend to change.
Frequently Asked Questions
Can I put the legend inside the chart area instead of outside?
Yes. Right-click the legend and select Format Legend. Under Legend Options, check the box for "Show the legend without overlapping the chart." Uncheck it to let the legend float over the data. You can then drag it to any spot inside the chart area, including the corners.
Why does my legend show entries I did not create?
Excel includes every column or row in your data range as a potential series. If you selected too much data when you created the chart — for example, a column with notes or totals — those appear in the legend. Use Select Data to remove unwanted series, or rebuild the chart with a smaller data range.
How do I make the legend text bigger?
Right-click the legend and select Format Legend. Under Text Options, change the font size. You can also select just the legend text by clicking it once (not double-clicking), then use the font size dropdown in the main toolbar to resize it.
Can I have multiple legends in one chart?
No. Excel allows only one legend per chart. If you need to show multiple groupings of data, consider splitting the data into separate charts or using a different chart type that better shows the relationships you want to highlight.
What if the legend covers part of my data?
Move it. Right-click the legend and choose a different position from the Format Legend panel, or drag it by hand to an empty area of the chart. If no position works, try making the chart larger or the legend text smaller.