Syntax

expression.CrossesAt

expression A variable that represents an Axis object.

Remarks

Setting this property causes the property to change to xlAxisCrossesCustom.

This property cannot be used on radar charts. For 3-D charts, this property indicates where the plane defined by the category axes crosses the value axis.

Example

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

Visual Basic for Applications 
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. Charts.Add 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. ActiveChart.Axes(xlValue).Select Selection.CrossesAt = 3 End Sub
Cross y-axis at value 3 units? crosses crosses at Crosses At Property CrossesAt CrossesAt Property Customize crossing of value axis? Set crossing point of category axis?

See also: