You have created a chart in Excel, but the legend is in the wrong place or looks unprofessional. The legend is a key element that identifies the data series in your chart. This article explains how to reposition the legend and change its appearance to improve your chart’s readability and design.
Key Takeaways: Moving and Formatting a Chart Legend
- Click and drag the legend: This is the fastest way to manually reposition the legend anywhere on the chart area.
- Chart Elements button > Legend > Arrow: Use this menu to place the legend in a standard position like top, bottom, left, or right.
- Right-click legend > Format Legend: Opens a task pane to change the legend’s fill, border, text effects, and position precisely.
Understanding the Excel Chart Legend
A legend is a box that labels the colors, patterns, or symbols used in a chart. It maps each data series name to its visual representation. You must have a chart with at least one data series to see a legend. Excel adds a legend automatically when you create most chart types, but you have full control over its placement and style. The legend is a single object you can select, move, and format independently from the chart title or plot area.
Steps to Reposition and Style the Legend
You can move the legend using quick preset locations or by dragging it manually. Use the Format Legend pane for detailed customization.
Method 1: Use the Chart Elements Menu for Quick Placement
- Select your chart
Click anywhere on the chart you want to edit. This action displays the Chart Design and Format tabs on the ribbon. - Open the Chart Elements menu
Click the plus sign icon that appears to the right of the chart. This is the Chart Elements button. - Hover over Legend and click the arrow
In the menu that appears, point to the word Legend. A right-facing arrow will appear next to it. Click this arrow. - Choose a preset position
A submenu shows options like Right, Top, Left, and Bottom. Click one to move the legend to that standard location relative to the plot area.
Method 2: Manually Drag the Legend
- Click on the legend to select it
Click once on the legend box. You will see a border around it with small circular handles. - Drag the legend to a new location
Click and hold the border of the legend box, not the handles. Drag it to any location within the chart area. Release the mouse button to drop it.
Method 3: Format the Legend in Detail
- Open the Format Legend pane
Right-click directly on the legend and select Format Legend from the context menu. A task pane will open on the right side of the Excel window. - Adjust legend options
In the Format Legend pane, click the Legend Options icon, which looks like a column chart. Here you can set the position relative to the chart and choose to overlay the legend on the plot area without resizing it. - Change the fill and border
Click the Fill & Line icon, which looks like a paint bucket. Use the Fill section to set a solid color, gradient, or picture background. Use the Border section to add a line around the legend and set its color and style. - Format the text
Click the Text Options header in the pane. Then click the Text Fill & Outline icon to change the font color. Click the Text Effects icon to add shadows or glow. To change the font itself, use the Home tab on the ribbon after selecting the legend.
Common Formatting Mistakes and Limitations
Legend Disappears or Shows Incorrect Series
If your legend vanishes, click the Chart Elements button and ensure the Legend checkbox is selected. If the legend shows wrong names, edit the data series names in your source worksheet. The legend pulls labels directly from the chart data range.
Legend Overlaps Chart Data
A manually dragged legend can block bars or lines. In the Format Legend pane, under Legend Options, check the Show the legend without overlapping the chart box. Alternatively, choose a preset position from the Chart Elements menu to avoid overlap automatically.
Cannot Format Individual Legend Entries
Excel treats the legend as one object. You cannot directly change the color of just one label’s text. To change the color of a legend key icon, format the corresponding data series in the chart. The legend icon will update to match.
Manual Drag vs. Preset Position vs. Format Pane
| Item | Manual Drag | Preset Position | Format Legend Pane |
|---|---|---|---|
| Primary Use | Free, pixel-perfect placement | Quick, standard alignment | Detailed styling and precise control |
| Speed | Fast | Fastest | Slower, for fine-tuning |
| Best For | Unique chart layouts | Reports needing consistent style | Professional formatting and overlays |
| Overlap Prevention | Manual adjustment required | Automatic | Checkbox control available |
You can now place your chart legend exactly where you need it and change its background, border, and text. Try using the Format Legend pane to add a subtle shadow to the legend text for better readability. For advanced control, remember that selecting the legend and using the Font group on the Home tab is the only way to change the font size and typeface directly.