ATTACHEDLABEL: Series Data/Value Labels (100Ch)

The ATTACHEDLABEL record defines the data label type. The ATTACHEDLABEL record applies to the label data identified in the associated DATAFORMAT record.

Record Data�BIFF8

Offset

Name

Size

Contents

4

grbit

2

Value label flags


The grbit field contains the following option flags.

Offset

Bits

Mask

Name

Contents

0

0

01h

fShowValue

1 = show the actual value of the data point

1

02h

fShowPercent

1 = show value as a percent of the total. This bit applies only to pie charts

2

04h

fShowLabPct

1 = show category label and value as a percentage (pie charts only). Should be 1 if fShowLabel and fShowPerecent are both 1.

3

08h

fSmoothedLine

1 = show smoothed line

4

10h

fShowLabel

1 = show category label

5

20h

fShowBubbleSizes

1 = show bubble sizes

7-6

C0h

(reserved)

Reserved; must be zero

1

7�0

FFh

(reserved)

Reserved; must be zero


Record Data�BIFF7 and earlier

Offset

Name

Size

Contents

4

grbit

2

Value label flags


The grbit field contains the following option flags.

Offset

Bits

Mask

Name

Contents

0

0

01h

fShowValue

1 = show the actual value of the data point

0

1

02h

fShowPercent

1 = show value as a percent of the total. This bit applies only to pie charts

0

2

04h

fShowLabPct

1 = show category label and value as a percentage (pie charts only). Should be 1 if fShowLabel and fShowPerecent are both 1.

0

3

08h

(reserved)

Reserved; must be zero

0

4

10h

fShowLabel

1 = show category label

0

7-5

E0h

(reserved)

Reserved; must be zero

1

7�0

FFh

(reserved)

Reserved; must be zero