Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

This article shows you how to add a chart legend in Office 2016, and also how to customize the appearance of the legend, including the font, the border, and the background.

  1. Click the chart to which you want to add a legend, click the Chart Elements button , and then click Legend.

    Chart Elements > Legend in Excel
  2. To change the location of the legend, click the arrow next to Legend and then click the location that you want.

Tips: 

  • By default, a legend does not overlap the chart. If you have space constraints, you may be able to reduce the size of the chart by clicking More Options and then clearing the Show the legend without overlapping the chart check box.

  • To remove a legend, right-click it, and then click Delete.

    Delete command on the Format Legend Font shortcut menu in Excel

Once you add the chart legend, there are many things that you can do to change how it looks.

Change font or font size

  1. Right-click the legend, and then click Font.

    Font command on the shortcut menu used to change the chart legend font
  2. On the Font tab, make the changes that you want to the font or font size.

    Font dialog box in Excel

Change legend border or background

  1. Right-click the legend, and then click Format Legend.

  2. In the Format Legend task pane, pick the options that you want.

    Format Legend border task pane

Tip: You can really make your legend stand out by adding an effect. Click Effects and then pick the effect that you want. A wide variety of effects is available, including shadows, glows, and soft edges. (Just be careful not to go overboard: you probably don't want to clutter the presentation of your data.)

Format Legend Effects task pane

A legend can make your chart easier to read because it positions the labels for the data series outside the plot area of the chart. You can change the position of the legend and customize its colors and fonts. You can also edit the text in the legend and change the order of the entries in the legend.

  1. This step applies to Word 2016 for Mac only: On the View menu, click Print Layout.

  2. Click the chart, and then click the Chart Design tab.

  3. Click Add Chart Element > Legend.

  4. To change the position of the legend, choose Right, Top, Left, or Bottom. To change the format of the legend, click More Legend Options, and then make the format changes that you want.

    Depending on the chart type, some options may not be available.

A legend can make your chart easier to read because it positions the labels for the data series outside the plot area of the chart. You can change the position of the legend and customize its colors and fonts. You can also edit the text in the legend and change the order of the entries in the legend.

  1. This step applies to Word for Mac 2011 only: On the View menu, click Print Layout.

  2. Click the chart, and then click the Chart Layout tab.

  3. To change the position of the legend, under Labels, click Legend, and then click the legend position that you want.

  4. To change the format of the legend, under Labels, click Legend, click Legend Options, and then make the format changes that you want.

    Depending on the chart type, some options may not be available.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×