How to Add Chart Legends in Excel 2010

1. Double-click the Excel 2010 file that you want to work with to open up the spreadsheet.
2. Click anywhere on the chart to select it. Then click the “Layout” tab at the top of the screen.
3. Click the “Legend” button, which is located in the Labels area of the ribbon. Choose one of the four direction buttons to place the legend above, to the right, to the left or below the chart. Alternatively, click either of the “Overlay” buttons to place the legend at the right or left side of the chart, overlapping the chart itself.
4. Right-click the legend on the chart, and choose “Format Legend” from the pop-up menu. The Format Legend window will appear.
5. Select any of the options on the left side of the window other than “Legend Options” to adjust how the legend will appear on your chart. These settings will let you add a filled-in background, adjust the border color or style, add a shadow element and adjust the edges of the legend. Click “Close” when you are done adjusting the legend’s appearance.