Muokkaa

Jaa

Axis.Crosses property (Excel)

  • Artikkeli

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

Can be one of the XlAxisCrosses constants.

This property isn't available for radar charts. For 3D charts, this property can only be applied to the value axis, and indicates where the plane defined by the category axes 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.

Example

This example sets the value axis on Chart1 to cross the category axis at the maximum x value.

Charts("Chart1").Axes(xlCategory).Crosses = xlMaximum

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.