CrossesAtValue Property

Microsoft Office Web Components Visual Basic

Returns or sets the crossing point for the specified axis. When you set this value for an axis, you are setting the value on the other axis where the axis you are setting will cross that other axis. For example, setting this property on the value (y) axis sets the category number where the value axis will cross the category (x) axis. Read/write Double.

expression.CrossesAtValue

expression    Required. An expression that returns a ChAxis object.

Example

This example sets the category axis to cross the value axis at value zero (0) in the chart workspace.

Sub SetCrossingValue()
    Dim chConstants
    Dim axValueAxis
    Dim axCategoryAxis
    
    Set chContants = ChartSpace1.Constants
    
    Set axValueAxis = ChartSpace1.Charts(0).Axes(chConstants.chAxisPositionValue)
    Set axCategoryAxis = ChartSpace1.Charts(0).Axes(chConstants.chAxisPositionCategory)
    
    axValueAxis.CrossingAxis = axCategoryAxis
    
    axCategoryAxis.CrossesAtValue = 0
End Sub
		

The following example causes the value axis to cross the category axis at the third category.

Sub SetCrossingCategory()
    Dim chConstants
    
    Set chConstants = ChartSpace1.Constants
    ChartSpace1.Charts(0).Axes(chConstants.chAxisPositionLeft).CrossesAtValue = 3
End Sub