Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

2.4.252 Series

Office

The Series record specifies properties of the data for a series, a trendline, or error bars, and specifies the beginning of a collection of records as defined by the Chart Sheet SubstreamABNF. The collection of records specifies a series, a trendline, or error bars.


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

sdtX

sdtY

cValx

cValy

sdtBSize

cValBSize

sdtX (2 bytes): An unsigned integer that specifies the type of data in categories (3), or horizontal values on bubble and scatter chart groups, in the series. MUST be a value from the following table:

Value

Meaning

0x0001

The series contains categories (3), or horizontal values on bubble and scatter chart groups, with numeric information.

0x0003

The series contains categories (3), or horizontal values on bubble and scatter chart groups, with text information.

sdtY (2 bytes): An unsigned integer that specifies that the values or vertical values on bubble and scatter chart groups, in the series contain numeric information. It MUST be 0x0001 and MUST be ignored.

cValx (2 bytes): An unsigned integer that specifies the count of categories (3), or horizontal values on bubble and scatter chart groups, in the series. The value MUST be less than or equal to 32767.

cValy (2 bytes): An unsigned integer that specifies the count of values, or vertical values on bubble and scatter chart groups, in the series. The value MUST be less than or equal to 32767.

sdtBSize (2 bytes): An unsigned integer that specifies that the bubble size values in the series contain numeric information. The value MUST be 0x0001, and MUST be ignored.

cValBSize (2 bytes): An unsigned integer that specifies the count of bubble size values in the series. The value MUST be less than or equal to 32767.

Show:
© 2015 Microsoft