How to Turn the Excel Chart Legend On or Off


As you know, when you create a chart in Excel, a chart legend is automatically created right along with your chart depending upon which type of chart you are creating. It doesn’t have to be that way. You have a choice.

Follow the steps below to learn how:

  1. Click once on your legend to select it. You will note that handles now appear around the perimeter of your legend.
  2. On your Ribbon In the Chart Tools Tab, in the Layout group (which is only visible when your legend has been selected),

Chart-Tools

  1. In the Labels group, clck the Legend drop-down.

Legend-Drop-Down

  1. From the drop-down list, select None.

Now you can be like Burger King and have it your way!

Posted in:
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.