Share via

CrossingAxis Property

  • Article

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

Applies to | ChAxis Object

See Also | Crosses Property | CrossesAtValue Property