Applies To
Axis Object.
Description
Returns or sets the point on the specified axis where the other axis crosses, as shown in the following table. Read-write.
Value |
Meaning |
xlAutomatic |
Microsoft Excel sets the axis crossing. |
xlMinimum |
The axis crosses at the minimum value. |
xlMaximum |
The axis crosses at the maximum value. |
xlCustom |
The CrossesAt property specifies the crossing point. |
Remarks
This property is not available for 3-D charts or radar charts.
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.
xlMinimum and xlMaximum can have different meanings, depending on the axis.
See Also
CrossesAt Property.
Example
This example sets the value axis in Chart1 to cross the category axis at the maximum x value.
Charts("Chart1").Axes(xlCategory).Crosses = xlMaximum