SplitMinimum Property

Microsoft Office Web Components Object Model

SplitMinimum Property

       

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

expression.SplitMinimum

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