Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

2.2.3.13 Error Bar

Office

An error bar is a set of lines displayed on a chart (section 2.2.3.3) that indicates a range of uncertainty in the measurement of each data points (section 2.2.3.10) in a series (section 2.2.3.9).

An error bar is specified by a sequence of records that conforms to the SERIESFORMAT rule (section 2.1.7.20.1) specified by the chart sheet substream (section 2.1.7.20.1) ABNF that contains a SerAuxErrBar record (section 2.4.249).

The following records and rules define the significant parts of an error bar:

  • The sequence of records that conforms to the SS rule (section 2.1.7.20.1) specifies the formatting properties of the error bar. The yi field of the DataFormat record (section 2.4.74) MUST specify the zero-based index of the Series record (section 2.4.252) associated with this error bar in the collection of all Series record in the current chart sheet substream. Each error bar MUST contain zero or one sequences of records that conform to the SS rule.

  • The SerParent record (section 2.4.255) specifies the series associated with the error bar.

  • The SerAuxErrBar record specifies properties of the error bar, including the direction and type of the error bar.

The following restrictions apply to error bars:

  • All fields except the cValx and cValy fields in the Series record MUST be ignored.

  • The cValx field MUST equal the cValx field of the Series record in the associated series specified by the SerParent record.

  • If the ebsrc field of the SerAuxErrBar record equals 0x04 and the sertm field of the SerAuxErrBar equals 0x01 or 0x02, the cValx field MUST equal the number of values represented by the formula field of the second BRAI record (section 2.4.29) in the sequence of records that conforms to the AI rule (section 2.1.7.20.1).

  • If the ebsrc field of the SerAuxErrBar record equals 0x04 and the sertm field of the SerAuxErrBar equals 0x03 or 0x04, the cValy field MUST equal the number of values represented by the formula field of the second BRAI record in the sequence of records that conforms to the AI rule.

  • If the ebsrc field of the SerAuxErrBar record does not equal 0x04, the cValy field MUST equal the cValy field of the Series record in the associated series specified by the SerParent record.

  • The BRAI records in the first, third, and fourth sequences of records that conform to the AI rule MUST be ignored and the ifmt field of the BRAI records MUST equal 0x0000.

  • If the ebsrc field of the SerAuxErrBar record equals 0x04, the ifmt field of the BRAI records contained in the second collection of records that conform to the AI rule specifies a Formula (section 2.4.127) that specifies custom values of the error bar.

  • If the ebsrc field of the SerAuxErrBar record equals 0x04, the BRAI records in the second sequence of records that conforms to the AI rule MUST be ignored and the ifmt field of the BRAI records MUST equal 0x0000.

  • The LegendException record (section 2.4.153) in the chart sheet substream MUST NOT exist.

Show:
© 2016 Microsoft