Labels page (Secondary Y-Axis Properties dialog box)

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

Only bipolar and dual axis charts have a secondary y-axis.

Display Labels

Enable to display labels along the secondary y-axis.

Maximum Value: Automatic

Enable to automatically set the highest point on the scale of the secondary y-axis to conform to the value of the greatest data point in your spreadsheet data.

Maximum Value

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

Minimum Value: Automatic

Enable to automatically set the lowest point on the scale of the secondary y-axis to conform to the value of the least data point in your spreadsheet data.

Minimum Value

Specifies the value of the least point on the scale of the secondary y-axis.

Major Grid Value: Automatic

Enable to automatically set the value of the major gridlines associates with the secondary y-axis.

Major Grid Value

Specifies the value each gridline measures.

Label scale factor

Specifies the factor by which the scale is labeled.