CrossesAt Property

Microsoft Graph Visual Basic

CrossesAt Property


Returns or sets the point on the value axis where the category axis crosses it. Applies only to the value axis. Read/write Double.


Setting this property causes the Crosses property to change to xlAxisCrossesCustom.

This property cannot be used on 3-D charts or radar charts.


This example sets the category axis in the ActiveChart to cross the value axis at value 3.

Sub Chart()
    ' Create a sample source of data.
    Range("A1") = "2"
    Range("A2") = "4"
    Range("A3") = "6"
    Range("A4") = "3"
    ' Create a chart based on the sample source of data.
    With ActiveChart
        .ChartType = xlLineMarkersStacked
        .SetSourceData Source:=Sheets("Sheet1").Range("A1:A4"), PlotBy:= xlColumns
        .Location Where:=xlLocationAsObject, Name:="Sheet1"
    End With
    ' Set the category axis to cross the value axis at value 3.
    Selection.CrossesAt = 3
End Sub