This record defines a bar or column chart group.
Record Data — BIFF8
|
Offset |
Name |
Size |
Contents |
|
4 |
pcOverlap |
2 |
Space between bars (percent of bar width), default = 0 |
|
6 |
pcGap |
2 |
Space between categories (percent of bar width), default = 50 |
|
8 |
grbit |
2 |
Format flags |
The grbit field contains the bar chart display attributes as follows.
|
Offset |
Bits |
Mask |
Name |
Contents |
|
0 |
0 |
01h |
fTranspose |
1 = horizontal bars (bar chart) |
|
1 |
02h |
fStacked |
Stack the displayed values | |
|
2 |
04h |
f100 |
Each category is displayed as a percentage | |
|
3 |
08h |
fHasShadow |
1 = this bar has a shadow | |
|
7 – 4 |
F0h |
(reserved) |
Reserved; must be zero | |
|
1 |
7 – 0 |
FFh |
(reserved) |
Reserved; must be zero |
When fStacked is true, the bars or columns within a category are stacked one on top of the next. The f100 bit can be set only when the fStacked bit is set, and indicates that each category is broken down into percentages.
Record Data — BIFF7 and earlier
|
Offset |
Name |
Size |
Contents |
|
4 |
pcOverlap |
2 |
Space between bars (percent of bar width), default = 0 |
|
6 |
pcGap |
2 |
Space between categories (percent of bar width), default = 50 |
|
8 |
grbit |
2 |
Format flags |
The grbit field contains the bar chart display attributes as follows.
|
Offset |
Bits |
Mask |
Name |
Contents |
|
0 |
0 |
01h |
fTranspose |
1 = horizontal bars (bar chart) |
|
0 |
1 |
02h |
fStacked |
Stack the displayed values |
|
0 |
2 |
04h |
f100 |
Each category is displayed as a percentage |
|
0 |
7 – 3 |
FCh |
(reserved) |
Reserved; must be zero |
|
1 |
7 – 0 |
FFh |
(reserved) |
Reserved; must be zero |
When fStacked is true, the bars or columns within a category are stacked one on top of the next. The f100 bit can be set only when the fStacked bit is set, and indicates that each category is broken down into percentages.