You define a legend to identify and describe the data sets used in your chart. You can specify font and background options and border color. You can also specify the placement location for the legend within the chart boundaries.
You can also suppress repeating labels, through which you can inherit settings from the referenced grid. Repeating labels are axis labels that repeat in a chart if you do not suppress them.
To define chart legend options:
On the Chart Properties property sheet, click the Format Chart button.
Select the Legend tab to display the formatting and placement options for legends.
Select the Place Legend check box to select the vertical and horizontal positions of the chart legend relative to the chart boundaries. Vertical positioning options include Top, Middle, and Bottom. Horizontal positioning options include Left, Center, Right.
Click the Borders and Background icon, , to format the border and background of the legend.
Click the Font button, to set font options, including font, font size, effects, and angle, for the legend title and its labels, then click OK.
To suppress X-axis labels that would otherwise repeat, select from the following options for Suppress Repeating Labels: Inherit Settings from Grid, On, or Off.