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