MaximumScale Property

Axis.MaximumScale Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

expression .MaximumScale

expression A variable that represents an Axis object.

Setting this property sets the MaximumScaleIsAuto 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:
© 2016 Microsoft