How to Edit the Legend in Microsoft Excel

Written by morgan owens
  • Share
  • Tweet
  • Share
  • Email

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

Show MoreHide

Instructions

    Microsoft Excel 2007

  1. 1

    Highlight a chart by clicking on it.

  2. 2

    Click on the "Design" tab near the middle of the top of the page.

  3. 3

    Click on "Select Data", the fourth icon from the top left of the page. A box titled "Select Data Source" will appear.

  4. 4

    Click on the name of the "Legend entry" that you wish to edit.

  5. 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. 6

    Type the name that you wish to title the "Legend entry" into the box titled "Series name".

  7. 7

    Click "OK". This will edit the legend and return you to the "Edit Series" box.

  8. 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. 9

    Type the name that you wish to title the new "legend entry" into the box titled "Series name."

  10. 10

    Insert the values for the x-coordinates in the "Series X values" box.

  11. 11

    Insert the values for the y-coordinates in the "Series Y values" box.

  12. 12

    Click "OK". This will edit the legend and return you to the "Edit series" box.

  13. 13

    Repeat this process if you wish to add or edit any additional legend entries.

  14. 14

    Click "OK" when you are finished.

    Microsoft Excel 2003

  1. 1

    Highlight a chart by clicking on it to modify its legend. A menu will appear.

  2. 2

    Select "Source Data..." from the menu. It is the third option from the top of the menu. A box titled "Source Data" will appear.

  3. 3

    Click on the tab labelled "Series". It is one of two tabs displayed at the top of the "Chart Wizard" box.

  4. 4

    Highlight the "Data series name" you wish to change.

  5. 5

    Place your cursor in the text box titled "Name." Type the name that you wish to title the "Legend entry" into the box.

  6. 6

    Press the "Finish" button when you are done.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.