Share via

HasSplit Property

  • Article

True if the scale for the specified axis has a split point between the value of its SplitMinimum property and the value of its SplitMaximum property. The default value is False. Read/write Boolean.

expression.HasSplit

*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

Applies to | ChScaling Object

See Also | SplitMaximum Property | SplitMinimum Property