Axis.MaximumScaleIsAuto Property (Excel)

True if Microsoft Excel calculates the maximum value for the value axis. Read/write Boolean .

Syntax

expression. MaximumScaleIsAuto

expression A variable that represents an [Axis](./Excel.Axis(Graph object).md) object.

Remarks

Setting the MaximumScale property sets this property to False .

Example

This example automatically calculates the minimum scale and the maximum scale for the value axis in Chart1.

With Charts("Chart1").Axes(xlValue) 
 .MinimumScaleIsAuto = True 
 .MaximumScaleIsAuto = True 
End With

See also

Axis Object