Export (0) Print
Expand All
Expand Minimize

2.4.5 AttachedLabel

Office

The AttachedLabel record specifies properties of a data label (section 2.2.3.11) on a chart group (section 2.2.3.7), series (section 2.2.3.9), or data point (section 2.2.3.10). Refer to the data label (section 2.2.3.11) overview for additional information about how this record is used and when this record is ignored.


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

A

B

C

D

E

F

G

reserved

A - fShowValue (1 bit): A bit that specifies whether the value, or the vertical value on bubble or scatter chart groups (section 2.2.3.7), is displayed in the data label (section 2.2.3.11).

This value MUST be 0 if this record is in a chart group (section 2.2.3.7) and either fShowLabelAndPerc or fShowPercent is equal to 1.

B - fShowPercent (1 bit): A bit that specifies whether the value, represented as a percentage of the sum of the values of the series (section 2.2.3.9) the data label (section 2.2.3.11) is associated with, is displayed in the data label (section 2.2.3.11).

MUST equal 0 if the chart group (section 2.2.3.7) type of the corresponding chart group (section 2.2.3.7), series (section 2.2.3.9), or data point (section 2.2.3.10), is not bar of pie, doughnut, pie, or pie of pie chart group (section 2.2.3.7).

If this record is contained in a chart group (section 2.2.3.7) and fShowLabelAndPerc is equal to 1 then this field MUST equal 1.

C - fShowLabelAndPerc (1 bit): A bit that specifies whether the category (3) name and value, represented as a percentage of the sum of the values of the series (section 2.2.3.9) the data label (section 2.2.3.11) is associated with, are displayed in the data label (section 2.2.3.11).

MUST equal 0 if the chart group (section 2.2.3.7) type of the corresponding chart group (section 2.2.3.7), series (section 2.2.3.9), or data point (section 2.2.3.10), is not bar of pie, doughnut, pie, or pie of pie chart group (section 2.2.3.7).

D - unused (1 bit): Undefined and MUST be ignored.

E - fShowLabel (1 bit): A bit that specifies whether the category (3), or the horizontal value on bubble or scatter chart groups (section 2.2.3.7), is displayed in the data label (section 2.2.3.11) on a non-area chart group (section 2.2.3.7), or the series (section 2.2.3.9) name is displayed in the data label (section 2.2.3.11) on an area chart group (section 2.2.3.7).

This field MUST equal 0 if this record is contained in a chart group (section 2.2.3.7) and one of the following conditions is satisfied:

  • The fShowValue field is equal to 1.

  • The fShowLabelAndPerc field is equal to 0 and the fShowPercent field is equal to 1.

F - fShowBubbleSizes (1 bit): A bit that specifies whether the bubble size is displayed in the data label (section 2.2.3.11).

MUST equal 0 if the chart group (section 2.2.3.7) type of the corresponding chart group (section 2.2.3.7), series (section 2.2.3.9), or data point (section 2.2.3.10) is not bubble chart group (section 2.2.3.7).

If the current record is contained in a chart group (section 2.2.3.7) and fShowPercent, fShowValue, or fShowLabel equal 1, this field MUST equal 0.

G - fShowSeriesName (1 bit): A bit that specifies whether the data label (section 2.2.3.11) contains the name of the series (section 2.2.3.9).

If the current record is contained in a chart group (section 2.2.3.7) and fShowLabelAndPerc, fShowPercent, fShowValue, fShowValue, fShowLabel, or fShowBubbleSizes equal 1 then this MUST equal to 0.

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

Show:
© 2014 Microsoft