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 fShowPercent 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 fShowPercent 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 |