What a legend does and why your chart needs one
A legend is the box on your chart that explains what each color, pattern, or line represents. Without it, someone looking at your chart has to guess whether the blue bar means sales or expenses, or whether the red line is this year's numbers or last year's. A legend solves that problem by labeling each element so the chart tells a complete story on its own.
Excel adds a legend automatically when you create most chart types, but it often appears in the wrong spot or shows information you don't need. Learning to move it, resize it, and control what it displays takes about two minutes and makes your chart readable instead of confusing.
Key Takeaways
- Excel places a legend on new charts automatically, usually on the right side, but you can move it to the top, bottom, left, or remove it entirely.
- Right-click the legend itself (not the chart) and choose "Format Legend" to change its position, size, and whether it shows labels or symbols.
- If your legend shows data series you don't want displayed, delete those rows or columns from your data before creating the chart.
- A legend positioned at the bottom or top takes up less horizontal space than one on the side, which matters if your chart is narrow.
Finding and selecting the legend on your chart
Click anywhere on the chart itself to select it — you'll see a gray border around the entire chart area. Now look for the legend, which is usually a small box with colored squares or lines and text labels next to them. It's typically on the right side of the chart, but it might be at the top, bottom, or left depending on the chart type.
Click directly on the legend box itself. You should see small square handles appear around just the legend, not around the whole chart. If you see handles around the entire chart instead, you clicked the chart background — click the legend again. Once the legend is selected, you can move it or change how it looks.
Moving the legend to a different position
With the legend selected, right-click it and choose "Format Legend" from the menu. A panel will open on the right side of your screen (or a dialog box, depending on your Excel version). Look for an option called "Legend Position" or just "Position."
You'll see choices like Right, Left, Top, Bottom, or Top Right. Click the position you want. Right is the default and works well for tall, narrow charts. Bottom works best for wide charts because it doesn't steal horizontal space. Top and Left are less common but useful if your chart layout demands it. Click outside the legend when you're done, and it will move to the new spot.
Resizing the legend if it's too large or too small
If the legend is covering part of your chart or looks too cramped, you can resize it. Select the legend by clicking it, then grab one of the small square handles around its edge and drag it to make it bigger or smaller. Drag a corner handle to resize both width and height at once, or drag a side handle to change just one dimension.
Be careful not to make it so small that the text becomes unreadable. If the legend text is hard to read, the problem is usually that the legend itself is too narrow — widen it by dragging the right edge to the right.
Removing the legend if you don't need it
Some charts don't need a legend — for example, a straightforward bar chart with only one data series, or a pie chart where the slice labels already explain everything. Select the legend and press Delete. The legend disappears when ready. You can always add it back by right-clicking the chart, choosing "Add Chart Element," then "Legend," and picking a position.
If you want to keep the legend but hide certain data series from it, the better approach is to delete those columns or rows from your data before you create the chart. That way the legend only shows what matters.
Changing what the legend displays
Sometimes your legend shows more information than you need. For example, if you charted sales by month and by region, the legend might list all 12 months when you only want to see the regions. The cleanest fix is to restructure your data before creating the chart — put months across the top as column headers and regions down the left as row headers, so each row becomes one data series.
If you've already created the chart and want to change what it displays, right-click the chart (not the legend), choose "Select Data," and you'll see a list of all the data series the chart is using. You can remove series from this list, reorder them, or change their names. Changes here update the legend automatically.
Formatting the legend text and appearance
Right-click the legend and choose "Format Legend" to open the formatting panel. Here you can change the font size, font style, and text color. You can also add a border around the legend box or change its background color, though most charts look cleaner without these extras.
If the legend text is too small to read, increase the font size. If it's so large that it takes up half the chart, make it smaller. A good rule is to match the legend text size to the size of your axis labels — they should look like they belong together.
Frequently Asked Questions
Why does my legend show data I didn't put in the chart?
Excel treats every row and column in your data range as a potential data series. If you selected too large a range when creating the chart, or if you have extra rows or columns nearby, they get included. Delete the unwanted rows or columns from your data, then right-click the chart, choose "Select Data," and remove the series you don't want.
Can I move the legend inside the chart area instead of outside?
Yes. In the Format Legend panel, look for an option called "Include in Layout" or "Legend Position." Some versions of Excel let you drag the legend anywhere on the chart, including over the data itself. This saves space but can make the chart harder to read if the legend covers important information.
How do I change the labels that appear in the legend?
The legend pulls its labels from your data — usually from row headers or column headers. To change a label, edit the text in that cell in your spreadsheet, and the legend updates automatically. You don't edit the legend itself.
What if the legend appears but it's completely empty?
This usually means Excel couldn't find clear labels for your data series. Check that your data has headers — the first row should contain column names, or the first column should contain row names. If headers are missing, add them and recreate the chart.
Can I have multiple legends on one chart?
No, Excel allows only one legend per chart. If you need to explain multiple things, consider splitting the data into two separate charts, or adding text boxes with explanations directly on the chart.