You can define and format labels for the primary and secondary axis in a chart. For a combo chart, you can specify and format a secondary axis label. You can also display and format metadata labels.
To define axis labels:
On the Chart Properties property sheet, click the Format Chart button.
Select the Axes tab and perform one or more of the following actions:
To use the default range of values on the primary axis, select the check box for Primary Axis Label.
To enter a range of values, including minimum, maximum, and step, on the primary axis, select the check box for Primary Axis Label and the Custom Range check box.
To use the default range of values on the secondary axis of a combo chart, select the check box for Secondary Axis Label.
To display the percentage of the default range of values on the secondary axis in a bar of line chart, select the check box for Secondary Axis Label.
To enter a range of values, including minimum, maximum, and step, on the secondary axis in a bar or line chart, select the check box for Secondary Axis Label and the Custom Range check box.
Click the Font button, , to set font options for the data labels, and then click OK.
Click the Borders and Background icon, , then specify border and background options for the data labels, and then click OK.
To show the metadata labels with a standard display, select the Show Metadata Labels check box.
Click the Font button, , to set font options for the metadata labels, then click OK.