Adding a legend to your Excel chart
A legend is the box that identifies what each color, pattern, or line in your chart represents. Excel can add one automatically, or you can place and format it yourself. The fastest way is to click the chart, then click the plus sign (+) that appears in the upper right corner, find "Legend," and toggle it on.
If that plus sign does not appear, click once on the chart to select it. The plus sign should show up when ready. Once the legend appears, you can move it by clicking and dragging it to a new spot — typically to the right of the chart, below it, or in a corner where it does not cover your data.
For more control over where the legend sits and how it looks, right-click the chart and select "Edit Chart." This opens the chart editor where you can access legend settings directly.
Key Takeaways
- Click the chart once, then click the plus sign in the upper right corner and toggle "Legend" on to add one in seconds.
- Drag the legend to move it — place it to the right, below, or in a corner so it does not hide your data.
- Right-click the chart and choose "Edit Chart" to access detailed legend formatting options like font size, position, and label text.
- If your legend shows the wrong labels, check that your data range in the chart is correct — the legend reads directly from your source data.
Moving the legend to a better position
By default, Excel often places the legend to the right of the chart. If that overlaps your data or looks crowded, you can move it. Click once on the legend itself (not the whole chart) and drag it to a new location. The legend will snap to common positions like bottom, top, left, or right.
If you want the legend in a specific spot that is not a standard position, right-click the chart and select "Edit Chart." In the chart editor panel on the right, look for "Legend" settings. Click on the dropdown next to "Position" and choose from options like "Right," "Bottom," "Top," or "Left." Some versions of Excel also offer "Overlay" options that let the legend float over the chart itself.
Changing what the legend says
The legend pulls its labels directly from your spreadsheet data. If your legend shows "Series 1" instead of a meaningful name, it means that column or row in your data does not have a header. Go back to your original data table and add a label to the first cell of each series you want to chart.
For example, if you charted columns B, C, and D but left the top cells empty, the legend will show "Series 1," "Series 2," and "Series 3." Add headers like "January Sales," "February Sales," and "March Sales" to cells B1, C1, and D1. Then click the chart and it will update automatically.
If you need to edit the legend text without changing your source data, right-click the chart, select "Edit Chart," and look for the legend settings. Some versions let you edit labels directly in the chart editor, though this is less common in newer Excel versions.
Formatting the legend's appearance
Once your legend is in place, you can change its font size, color, and border. Right-click directly on the legend box itself (not the chart background) and select "Format Legend." A panel will open where you can adjust the fill color, border style, and text formatting.
To change just the text size, right-click the legend, select "Format Legend," and look for text or font options. You can make the text larger if it is hard to read, or smaller if the legend takes up too much space. If you want to remove the border around the legend entirely, find the "Border" or "Line" option and set it to "None."
Removing the legend if you do not need it
If your chart is straightforward enough that the legend is not necessary, you can delete it. Click the chart once, then click the plus sign in the upper right corner and toggle "Legend" off. The legend will disappear when ready.
Alternatively, click the legend itself and press Delete. This removes only the legend, not the chart. If you change your mind, use the plus sign method to add it back.
When a legend shows the wrong data
Sometimes a legend includes series you did not intend to chart, or it is missing a series you wanted. This happens when the chart's data range is wrong. Right-click the chart and select "Edit Chart." Look for a "Data" or "Data Range" option in the editor panel. Check that the range includes only the columns and rows you want to display.
If you added new data to your spreadsheet after creating the chart, the chart may not include it automatically. You will need to edit the data range to include the new columns or rows. Once you adjust the range, the legend will update to match.
Frequently Asked Questions
Can I put the legend inside the chart instead of outside?
Yes. Right-click the chart, select "Edit Chart," and find the legend position options. Choose "Overlay" or a position like "Top Right" to place the legend over the chart area itself. This saves space but can cover some of your data, so use it only when the chart is straightforward.
Why does my legend say "Series 1" instead of a real name?
Your data does not have a header row. Go back to your spreadsheet and add a label to the first cell of each column or row you charted. The legend will read those labels and update automatically.
Can I edit the legend text without changing my spreadsheet?
In most recent versions of Excel, the legend is linked to your source data and updates automatically when you change it. Editing the legend text directly in the chart is not straightforward. The best approach is to update the labels in your original data table.
How do I make the legend text bigger so it is easier to read?
Right-click the legend, select "Format Legend," and look for font or text size options. Increase the size as needed. You can also change the font style or color in the same menu.
What if I want different colors in the legend?
The legend colors match the colors in your chart. To change them, right-click the data series (the bars, lines, or points themselves) in the chart, select "Format Data Series," and change the color. The legend will update to match.