How to Edit the Legend in Microsoft Excel

Microsoft Excel 2007
1. Highlight a chart by clicking on it.
2. Click on the “Design” tab near the middle of the top of the page.
3. Click on “Select Data”, the fourth icon from the top left of the page. A box titled “Select Data Source” will appear.
4. Click on the name of the “Legend entry” that you wish to edit.
5. Press the “Edit” button. The “Edit” button is located directly above the list of the names of the legend entries in your chart. When you press the “Edit” button, a box titled “Edit Series” will appear.
6. Type the name that you wish to title the “Legend entry” into the box titled “Series name”.
7. Click “OK”. This will edit the legend and return you to the “Edit Series” box.
8. Add another “legend entry” to the legend by clicking on the “Add” button. The “Add” button is located directly to the left of the “Edit” button. When you press the “Add” button, another box titled “Edit Series” will appear.
9. Type the name that you wish to title the new “legend entry” into the box titled “Series name.”
10. Insert the values for the x-coordinates in the “Series X values” box.
11. Insert the values for the y-coordinates in the “Series Y values” box.
12. Click “OK”. This will edit the legend and return you to the “Edit series” box.
13. Repeat this process if you wish to add or edit any additional legend entries.
14. Click “OK” when you are finished.
Microsoft Excel 2003
15. Highlight a chart by clicking on it to modify its legend. A menu will appear.
16. Select “Source Data…” from the menu. It is the third option from the top of the menu. A box titled “Source Data” will appear.
17. Click on the tab labeled “Series”. It is one of two tabs displayed at the top of the “Chart Wizard” box.
18. Highlight the “Data series name” you wish to change.
19. Place your cursor in the text box titled “Name.” Type the name that you wish to title the “Legend entry” into the box.
20. Press the “Finish” button when you are done.