2.4.249 SerAuxErrBar
The SerAuxErrBar record specifies properties of an error bar.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
sertm |
ebsrc |
fTeeTop |
reserved |
||||||||||||||||||||||||||||
|
numValue |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
cnum |
|||||||||||||||||||||||||||||||
sertm (1 byte): An unsigned integer that specifies the direction of the error bars. MUST be a value from the following table.
-
Value
Meaning
0x01
Error bars are horizontal in the plus direction.
0x02
Error bars are horizontal in the minus direction.
0x03
Error bars are vertical in the plus direction.
0x04
Error bars are vertical in the minus direction.
ebsrc (1 byte): An unsigned integer that specifies the error amount type of the error bars. MUST be a value from the following table:
-
Value
Meaning
0x01
Percentage
0x02
Fixed value
0x03
Standard deviation
0x04
Custom values (array of values or range)
0x05
Standard error
-
If the cce field of the ChartParsedFormula record contained in the formula field of the closest preceding BRAI record with id field equal to 0x0001 is 0x0000, then the error bars value source is an array of values. Each value in this array MUST be stored in a Number record in the SERIESDATA part of the Chart Sheet substream as specified in the Chart Sheet Substream ABNF. The cell.col field of each Number record MUST store the zero-based position index of the closest preceding Series record, as it is calculated across all Series records in the current Chart Sheet substream. The cell.rw field MUST store the zero-based index of this value in the array.
-
Otherwise, the value source is a range. The closest preceding BRAI record with the id field equal to 0x0001 specifies a link to the Rgce structure that describes this range.
fTeeTop (1 byte): A Boolean (section 2.5.14) that specifies whether the error bars are T-shaped.
reserved (1 byte): MUST be 0x01 and MUST be ignored.
numValue (8 bytes): An Xnum (section 2.5.342) value that specifies the fixed value, percentage, or number of standard deviations for the error bars. If ebsrc is equal to 0x05 or 0x04, MUST be ignored.
cnum (2 bytes): An unsigned integer that specifies the number of value or cell references used for custom error bars when ebsrc is equal to 0x04. This value MUST be ignored if ebsrc does not equal 0x04.
-
If the value source is an array of values, this value MUST equal the count of Number records whose cell.col field stores the zero-based index of the closest preceding Series record in the collection of Series records in the current chart sheet substream.
-
If the value source is a range, this value MUST equal the count of cell references of the range as specified in the rgce field of the ChartParsedFormula contained in the formula field of the closest preceding BRAI record that has an id field equal to 0x0001.