Adding Legends to Excel Charts: A Step-by-Step Guide
Legends in Excel charts serve a crucial purpose: they help viewers understand the data by providing a key to the colors, shapes, or patterns used in the chart. Adding a legend to your chart can significantly enhance its clarity and professionalism. Here's a comprehensive guide on how to add a legend in Excel, tailored to various chart types and Excel versions.
Understanding Legends in Excel
Before we dive into the process, let's understand what a legend is and its importance. A legend in Excel is a key that explains the data series in your chart. It's typically displayed as a list of items with corresponding symbols or colors. Legends are particularly useful in charts with multiple data series, as they help viewers distinguish between different datasets.
Adding a Legend to a Chart
Adding a legend to your chart is a straightforward process. Here's how you can do it in Excel 2016 and later versions:

- Select the chart to which you want to add a legend.
- Go to the Chart Design or Format Selection tab (depending on your Excel version).
- In the Add Chart Element group, click on Legend.
- Choose the position for your legend: Right, Left, Top, or Bottom.
If your chart already has a legend but you want to move it, you can do so by clicking and dragging the legend box to your desired location.
Customizing the Legend
Once you've added a legend to your chart, you can customize its appearance to match your workbook's theme. Here's how:
- Select the legend in your chart.
- Go to the Format Selection or Chart Design tab (depending on your Excel version).
- In the Format Selection or Add Chart Element group, click on Format Legend.
- Use the options in the Format Legend pane to customize the legend's fill, border, font, and other properties.
Legends in Specific Chart Types
While legends are typically added to column, bar, line, and area charts, they can also be added to other chart types. Here are a few examples:

Pie and Doughnut Charts
In pie and doughnut charts, the legend is added automatically. However, you can move it or customize its appearance as described above.
Stock and Surface Charts
For stock and surface charts, you'll need to add the legend manually. Follow the steps outlined earlier, but keep in mind that the legend may not appear immediately. You might need to adjust the chart area or add a secondary axis to make room for the legend.
Troubleshooting: Legend Not Appearing
If you've followed the steps above but your legend still isn't appearing, here are a few troubleshooting tips:
- Check that your chart has more than one data series. Legends are not displayed in charts with a single data series.
- Ensure that your chart area is large enough to accommodate the legend. You might need to resize the chart or move other chart elements to make room.
- Try adding a secondary axis to your chart. This can sometimes trigger the legend to appear.
- If none of the above solutions work, try creating a new chart and pasting your data into it. Sometimes, Excel can get "stuck" with certain chart settings.
Adding a legend to your Excel chart is a simple yet powerful way to enhance your data's clarity and readability. By following the steps outlined above, you can create engaging and informative charts that effectively communicate your data's story. Happy charting!