CrossesAt Element (Microsoft Excel)

Contains the x or y value at which a primary axis crosses its orthogonal primary axis.

Contained In

Axis

Remarks

The CrossesAt element allows users to place the origin of the two primary axes at a point other than (0,0).

This element contains a numeric value, or one of the following string constants specifying the maximum or minimum point on the axis: Maximum or Minimum. If a numeric value is specified, the value is in the range of the displayed units of the axis as defined by the DisplayUnits element.

The CrossesAt element can also contain the string constant Automatic, which means that Microsoft Excel automatically determines the crossing point. If this element is not specified, the default crossing point is Automatic.

For 100% stacked charts, the CrossesAt element contains a number from 0 to 1 representing a percentage. For example, a crossing value of 50% would be specified as 0.5.