Customize the Legend in a chart

You can hide or show the legend and change its position relative to the chart area, chart body, or a data item. For example, in a bar chart showing revenue for each product line by country or region, you could use the expression [Country or Region] = 'Canada' to position the legend relative to the Canada bar.

Note: When you choose a preset legend position, that position appears inside any padding that you have added to the chart object. Customized legend positions do not include any chart padding.

Procedure

  1. Select the chart object.
  2. In the Properties pane, under Chart Annotations, double-click the Legend property.
  3. To show the legend on the chart, select the Show Legend check box.
  4. To choose a preset legend position, click Preset and click a position from the diagram.
  5. To choose a customized legend position, do the following:
    1. Click Advanced and click the ellipsis button.
    2. To display the legend at a set distance from the sides of the chart area, from the Anchor list, click Relative to Chart.
    3. To display the legend at a set distance from the sides of the chart body, from the Anchor list, click Relative to Chart Body.
    4. To display the legend at a set distance from a data item, such as a specific pie slice in a pie chart, from the Anchor list, click Report Expression, click the ellipsis button beside Expression, and enter an expression in the Report Expression dialog box.
    5. Set the horizontal and vertical distances from the anchor.