Turn the Legend On and Off in Your Excel Chart

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!

Exit mobile version


Get great content like this delivered to your inbox!

It's free, convenient, and delivered right to your inbox! We do not spam and we will not share your address. Period!