Labels page (Primary Y-Axis Properties dialog box)

The Labels page of the Primary Y-Axis Properties dialog box controls the appearance of the labels, scale, and gridlines associated with the primary y-axis. If you choose to display labels, they appear at each division of the primary y-axis to identify the value of the scale.

Display Labels

Enable to display labels along the primary y-axis.

Maximum Value: Automatic

Enable to automatically set the highest point on the primary y-axis scale to conform to the value of the largest value in your spreadsheet data. The default setting of this check box is on. If you wish to change the value of the highest point of the scale, disable this check box and enter the new value in the Maximum Value box.

Maximum Value

Specifies the value of the highest point on the scale of the primary y-axis.

Minimum Value: Automatic

Enable to automatically set the lowest point on the scale of the primary y-axis to conform to smallest value in your spreadsheet data. The default setting of this check box is on. If you wish to change the value of the lowest point of the scale, disable this check box and enter the new value in the Minimum Value box.

Minimum Value

Specifies the value of the lowest point on the scale of the primary y-axis.

Major Grid Value: Automatic

Enable to automatically set the value of the major gridlines associated with the primary y-axis. The default setting of this check box is on. If you wish to change the value of the major gridlines, disable this check box and enter the new value in the Major Grid Value box.

Major Grid Value

Specifies the value each gridline measures.

Label scale factor

Specifies the factor by which the scale is labeled.