Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
2.4.249 SerAuxErrBar
Collapse the table of content
Expand the table of content

2.4.249 SerAuxErrBar

Office

The SerAuxErrBar record specifies properties of an error bar.


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

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.

Show:
© 2015 Microsoft