SplitMaximum Property

If the specified ChScaling object has a split, this property returns or sets the maximum value for the split. This value should be greater than the value of the SplitMinimum property. Read/write Double.

expression   Required. An expression that returns a ChScaling object.

Example

This example splits the value axis of the first chart in ChartSpace1 and sets the split minimum and split maximum values. The value axis is split, and values between 1000 and 5000 will not be displayed.

Sub Split_Value_Axis()
    Dim chConstants
    Dim scValueAxis
    
    Set chConstants = ChartSpace1.Constants
    
    ' Set a variable to the scaling object of the value axis.
    Set scValueAxis = ChartSpace1.Charts(0).Axes(chConstants.chAxisPositionValue).Scaling
    
    ' Add a split to the value axis.
    scValueAxis.HasSplit = True
    
    ' Specify the minnimum value of the split.
    scValueAxis.SplitMinimum = 1000
    
    ' Specify the maximum value for the split.
    scValueAxis.SplitMaximum = 5000
End Sub