MaximumScale Property

Microsoft Excel Visual Basic

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