HasAutoMaximum Property

Microsoft Office Web Components Visual Basic

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.HasAutoMaximum

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