CrossingAxis Property

Returns or sets the crossing axis. If the specified axis is deleted, this property is set to Null, and the Crosses property is reset to chAxisCrossesAutomatic. Read/write ChAxis.

expression.CrossingAxis

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 chtContants = 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