2.1.1438 Part 1 Section 21.2.2.34, crossesAt (Crossing Value)

For additional notes that apply to this portion of the standard, please see the notes for custUnit, §21.2.2.36(a); splitPos, §21.2.2.195(c).

a.   The standard states the value's data type is determined by the parent element.

In Office, the value data type is inferred from the type of axis being crossed, as follows:

When the axis to cross is specified by a valAx element, the value is a decimal number on the value axis.

When the axis to cross is specified by a dateAx element, the date is defined as an integer number on the date axis.

When the axis to cross is specified by a catAx element, the value is an integer category number, starting with 1 as the first category.

b.   The standard states that the possible values for the val attribute are defined by the XML Schema double datatype.

In Office, INF, -INF, and NaN are not supported values.

Show: