Author: Oscar Cronquist Article last updated on October 15, 2018

You can easily customize the font, font size, font color etc of the chart legend:

  1. Select legend.
  2. Go to tab "Home" on the ribbon.
  3. Click on "Font text" to change the font.
  4. Click on "Font size" to change the font size.
  5. Click on letter A to choose a font color.

Double click on legend with the left mouse button to open "Format Legend" settings.

Here you can choose where you want to position the legend relative to the plot area.

  • Top
  • Bottom
  • Left
  • Right
  • Top right

You also have the option to move the legend manually. Click and hold with left mouse button and then drag the legend to the position you want.

The usual effects like shadows, glow, soft and 3-d are also available for you if you click the "Effects" tab button.
More important, in my opinion, is the "Fill and Line" tab where you can customize the background color, picture, and gradient or apply a border around the legend.

 

How to remove the legend

  1. Select the legend.
  2. Click "Delete" button on your keyboard.

How to show the legend

  1. Select the chart.
  2. Click "plus" sign next to the chart.
  3. Click on checkbox "Legend" to show the legend.

Weekly Blog EMAIL

Welcome! I am Oscar and here to help you out.

Feel free to comment and ask Excel questions.

Make sure you subscribe to my newsletter so you don't miss new blog articles.

Related articles