Axis.Crosses property (Word)
Returns or sets the point on the specified axis where the other axis crosses. Read/write Long.
Syntax
expression.Crosses
expression A variable that represents an Axis object.
Remarks
This property is not available for radar charts. For 3D charts, this property can be applied only to the value axis and indicates where the plane defined by the category axes crosses the value axis.
Use this property 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. xlMinimum and xlMaximum are constants in the xlAxisCrosses enumeration.
Note that xlMinimum and xlMaximum can have different meanings, depending on the axis.
Example
The following example sets the value axis in for the first chart in the active document to cross the category axis at the maximum x-axis value.
With ActiveDocument.InlineShapes(1)
If .HasChart Then
.Chart.Axes(xlCategory).Crosses = xlMaximum
End If
End With
See also
Support and feedback
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.