Export (0) Print
Expand All
Expand Minimize

2.4.76 DataLabExtContents

Office

The DataLabExtContents record specifies the contents of an extended data label.


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

frtHeader

...

...

A

B

C

D

E

reserved

rgchSep (variable)

...

frtHeader (12 bytes): An FrtHeader structure. The frtHeader.rt field MUST be 0x086B.

A - fSerName (1 bit): A bit that specifies whether the name of the series is displayed in the extended data label.

B - fCatName (1 bit): A bit that specifies whether the category (3) name, or the horizontal value on bubble or scatter chart groups, is displayed in the extended data label. MUST be a value from the following table:

Value

Meaning

0

Neither of the data values are displayed in the extended data label.

1

If bubble or scatter chart group, the horizontal value is displayed in the extended data label. Otherwise, the category (3) name is displayed in the extended data label.

C - fValue (1 bit): A bit that specifies whether the data value, or the vertical value on bubble or scatter chart groups, is displayed in the extended data label. MUST be a value from the following table:

Value

Meaning

0

Neither of the data values are displayed in the data label.

1

If bubble or scatter chart group, the vertical value is displayed in the extended data label. Otherwise, the data value is displayed in the extended data label.

D - fPercent (1 bit): A bit that specifies whether the value of the corresponding data point, represented as a percentage of the sum of the values of the series the data label is associated with, is displayed in the extended data label.

MUST equal 0 if the chart group type of the corresponding chart group, series, or data point is not a bar of pie, doughnut, pie, or pie of pie chart group.

E - fBubSizes (1 bit): A bit that specifies whether the bubble size is displayed in the data label.

MUST equal 0 if the chart group type of the corresponding chart group, series, or data point is not a bubble chart group.

reserved (11 bits): MUST be zero, and MUST be ignored.

rgchSep (variable): A case-sensitive XLUnicodeStringMin2 structure that specifies the string that is inserted between every data value to form the extended data label. For example, if fCatName and fValue are set to 1, the labels will look like "Category Name<value ofrgchSep>Data Value". The length of the string is contained in the cch field of the XLUnicodeStringMin2 structure.

Show:
© 2015 Microsoft