According to Microsoft, a legend is a "box that identifies the patterns or colours that are assigned to the data series or categories in a chart." The legend in a chart created in Microsoft Excel can be edited using the program.
- Skill level:
- Moderately Easy
Other People Are Reading
Things you need
- Computer with Microsoft Excel
Highlight a chart by clicking on it.
Click on the "Design" tab near the middle of the top of the page.
Click on "Select Data", the fourth icon from the top left of the page. A box titled "Select Data Source" will appear.
Click on the name of the "Legend entry" that you wish to edit.
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.
Type the name that you wish to title the "Legend entry" into the box titled "Series name".
Click "OK". This will edit the legend and return you to the "Edit Series" box.
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.
Type the name that you wish to title the new "legend entry" into the box titled "Series name."
Insert the values for the x-coordinates in the "Series X values" box.
Insert the values for the y-coordinates in the "Series Y values" box.
Click "OK". This will edit the legend and return you to the "Edit series" box.
Repeat this process if you wish to add or edit any additional legend entries.
Click "OK" when you are finished.
Microsoft Excel 2007
Highlight a chart by clicking on it to modify its legend. A menu will appear.
Select "Source Data..." from the menu. It is the third option from the top of the menu. A box titled "Source Data" will appear.
Click on the tab labelled "Series". It is one of two tabs displayed at the top of the "Chart Wizard" box.
Highlight the "Data series name" you wish to change.
Place your cursor in the text box titled "Name." Type the name that you wish to title the "Legend entry" into the box.
Press the "Finish" button when you are done.
Microsoft Excel 2003
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for