Crosses Property

Applies To

Axis object.

Description

Returns or sets the point on the specified axis where the other axis crosses. Read/write Long.

Can be one of the following XlAxisCrosses constants.

Constant

Meaning

xlAxisCrossesAutomatic

Microsoft Excel sets the axis crossing point.

xlMinimum

The axis crosses at the minimum value.

xlMaximum

The axis crosses at the maximum value.

xlAxisCrossesCustom

The CrossesAt property specifies the axis crossing point.


Remarks

This property isn't 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.

Note that 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