BAR: Chart Group is a Bar or Column Chart Group (1017h)

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)
0 = vertical bars (column 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 = vertical bars (column 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.