2.4.74 DataFormat

Office

The DataFormat record specifies the data point or series that the formatting information that follows applies to and specifies 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 or 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 of the data point within the series specified by yi.  If this value is 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 31999.  This value MUST be less than or equal to 3999 for a chart that contains a Chart2.4.46d record. This value MUST be 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 of a Series record in the collection of Series records in this chart sheet substream.  MUST<75> be less than or equal to 254.

iss (2 bytes):  An unsigned integer that specifies properties of the data series, trendline or error bar, depending on the type of records in 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 SerAuxErrBar record, then this field specifies the plot order of the data series.  If the series order was changed, this field can be different from yi. MUST<76> 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 SerAuxErrBar record.

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

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

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

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

Show: