Axis.MinimumScale Property (Excel)

Returns or sets the minimum value on the value axis. Read/write Double.

expression .MinimumScale

expression A variable that represents an Axis object.

Setting this property sets the MinimumScaleIsAuto property to False.

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

Concepts

Other resources

Show:
© 2014 Microsoft