MaximumScale Property
Returns or sets the maximum value on the axis. Read/write Double.
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