SERIES: Series Definition (1003h)

This record describes the series of the chart, and contains the type of data and number of data fields that make up the series. Series can contain 4000 points in Microsoft Excel version 5.

The sdtX and sdtY fields define the type of data that is contained in this series. At present, the two types of data used in Microsoft Excel chart series are numeric and text (date and sequence information is not used). The cValx and cValy fields contain the number of cell records in the series.

Record Data—BIFF8

Offset

Name

Size

Contents

4

sdtX

2

Type of data in categories
0 = categories contain date information (not used)
1 = categories contain numeric information
2 = categories contain sequence information (not used)
3 = categories contain text information

8

sdtY

2

Type of data in values
0 = values contain date information (not used)
1 = values contain numeric information
2 = values contain sequence information (not used)
3 = values contain text information

10

cValx

2

Count of categories

12

cValy

2

Count of values

14

sdtBSize

2

Type of data in Bubble size series:
0 = dates
1 = numeric
2 = sequence
3 = text

16

cValBSize

2

Count of Bubble series values


Record Data—BIFF7 and earlier

Offset

Name

Size

Contents

4

sdtX

2

Type of data in categories
0 = categories contain date information (not used)
1 = categories contain numeric information
2 = categories contain sequence information (not used)
3 = categories contain text information

8

sdtY

2

Type of data in values
0 = values contain date information (not used)
1 = values contain numeric information
2 = values contain sequence information (not used)
3 = values contain text information

10

cValx

2

Count of categories

12

cValy

2

Count of values