HasAutoMaximum Property

True if the maximum scale value for the specified axis is set to be determined automatically. The default value is True. Read/write Boolean.

expression   Required. An expression that returns a ChScaling object.

Example

This example sets the maximum scale value for the specified axis if the maximum value is currently set to be determined automatically.

Sub SetScale()
    Dim chConstants
    dim axisScale
    
    Set chConstants = ChartSpace1.Constants
    Set axisScale = ChartSpace1.Charts(0).Axes(chConstants.chAxisPositionValue).Scaling
    If axisScale.HasAutoMaximum Then axisScale.Maximum = 50000
End Sub