2.4.35 DataFormat

Office

This record specifies the data point and series to which the formatting information that follows applies and the beginning of a collection of records as defined by the chart sheet substream ABNF. This collection of records specifies formatting properties for the data point and series.


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

xi

yi

iss

A

reserved

xi (2 bytes): An unsigned integer that specifies the zero-based index into the data point in the series specified by yi. If this field is set to 0xFFFF, the formatting information that follows applies to the series. Otherwise, the formatting information that follows applies to a data point. This value MUST be less than or equal to 0x7CFF. This value MUST be less than or equal to 0x0F9F for a chart that contains a Chart3d record. This value MUST be set to 0xFFFF if the formatting information in this record is applied to a trendline or error bar.

yi (2 bytes): An unsigned integer that specifies the zero-based index into a Series record in the collection of Series records in this chart sheet substream. SHOULD<48> be less than or equal to 0x00FE.

iss (2 bytes): An unsigned integer that specifies properties of the data series, trendline, or error bar, depending on the type of records contained in the sequence of records that conforms to the SERIESFORMAT rule that contains the sequence of records that conforms to the SS rule that contains this record.

If the SERIESFORMAT rule does not contain a SerAuxTrend or a SerAuxErrBar record, this field specifies the plot order of the data series. If the series order has been changed, this field can be different from yi. SHOULD<49> be less than or equal to the number of series in the chart. MUST be unique among iss values for all instances of this record contained in the SERIESFORMAT rule that does not contain a SerAuxTrend or a SerAuxErrBar record.

If the SERIESFORMAT rule contains a SerAuxTrend record in the chart group, this field specifies the trendline number for the series.

If the SERIESFORMAT rule contains a SerAuxErrBar record in the chart group, this field specifies a zero-based index into a Series record in the collection of Series records in the current chart sheet substream to which the error bar applies.

A - fXL4iss (1 bit): MUST be zero and MUST be ignored.

reserved (15 bits): MUST be zero, and MUST be ignored.

Show: