Turn the Legend On and Off in Your Excel Chart

excel logo

As you most likely already know, when you create a chart in MS Excel, it will automatically create a chart legend for you, depending on which type of chart you have created. You are not, however, limited to using that particular legend. You do not even have to have a legend should you not care to.

Follow the steps below to learn how to take control of your chart legend:

  1. Click one time on your legend to select it. Handles will appear around the perimeter of your legend.
  2. Select the Layout tab on your Ribbon, which is only visible when your legend is selected.
  3. In the Labels group, click the Legend drop-down list.
  4. Select None from the options offered.

See?  You have the final say as to whether your chart displays a legend or not!

About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.