Friday, September 1, 2017

Add and format a chart legend

Add and format a chart legend

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

Add a chart legend

  1. Click the chart to which you want to add a legend, click the Chart Elements button 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

Format a chart legend

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

1 comment:

  1. Download microsoft office 2010 professional (Retail License this specialized and efficient tool to enhance business productivity in a quick and easy way. Get your favorites applications to be downloaded absolutely free, which includes Word, Excel, Power-point, One-note, Outlook.

    ReplyDelete