Crosses property (Excel Graph)
Returns or sets the point on the specified axis where the other axis crosses. Read/write XlAxisCrosses.
expression.Crosses
expression Required. An expression that returns one of the objects in the Applies To list.
This property isn't available for radar charts. For 3D charts, this property indicates where the plane defined by the category axis crosses the value axis.
This property can be used for both category and value axes. On the category axis, xlMinimum sets the value axis to cross at the first category, and xlMaximum sets the value axis to cross at the last category.
Note that xlMinimum and xlMaximum can have different meanings, depending on the axis.
This example sets the value axis to cross the category axis at the maximum x value.
myChart.Axes(xlCategory).Crosses = xlMaximum
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.