Axis.MaximumScale Property (Excel)
Returns or sets the maximum value on the value axis. Read/write Double.
Syntax
expression .MaximumScale
expression A variable that represents an Axis object.
Remarks
Setting this property sets the MaximumScaleIsAuto property to False.
Example
This example sets the minimum and maximum values for the value axis in Chart1.
With Charts("Chart1").Axes(xlValue)
.MinimumScale = 10
.MaximumScale = 120
End With