Export (0) Print
Expand All
Expand Minimize

2.4.15 Bar

Office

The Bar record specifies that the chart group (section 2.2.3.7) is a bar chart group (section 2.2.3.7) or a column chart group (section 2.2.3.7), and specifies the chart group (section 2.2.3.7) attributes.


0

1

2

3

4

5

6

7

8

9
1
0

1

2

3

4

5

6

7

8

9
2
0

1

2

3

4

5

6

7

8

9
3
0

1

pcOverlap

pcGap

A

B

C

D

reserved

pcOverlap (2 bytes): A signed integer that specifies the overlap between data points (section 2.2.3.10) in the same category (3) as a percentage of the data points (section 2.2.3.10) width. MUST be greater than or equal to -100 and less than or equal to 100. MUST be a value from the following table:

Value

Meaning

-100 to -1

Size of the separation between data points (section 2.2.3.10).

0

No overlap.

1 to 100

Size of the overlap between data points (section 2.2.3.10).

pcGap (2 bytes): An unsigned integer that specifies the width of the gap between the categories (3) and the left and right edges of the plot area as a percentage of the data point (section 2.2.3.10) width divided by 2. It also specifies the width of the gap between adjacent categories (3) as a percentage of the data point (section 2.2.3.10) width. MUST be less than or equal to 500.

A - fTranspose (1 bit): A bit that specifies whether the data points (section 2.2.3.10) and value axis (section 2.2.3.6) are horizontal (for a bar chart group (section 2.2.3.7)) or vertical (for a column chart group (section 2.2.3.7)). MUST be a value from the following table:

Value

Meaning

0

Data points (section 2.2.3.10) and value axis (section 2.2.3.6) are vertical.

1

Data points (section 2.2.3.10) and value axis (section 2.2.3.6) are horizontal.

B - fStacked (1 bit): A bit that specifies whether the data points (section 2.2.3.10) in the chart group (section 2.2.3.7) that share the same category (3) are stacked.

C - f100 (1 bit): A bit that specifies whether the data points (section 2.2.3.10) in the chart group (section 2.2.3.7) are displayed as a percentage of the sum of all data points (section 2.2.3.10) in the chart group (section 2.2.3.7) that share the same category (3). MUST be 0 if fStacked is 0.

D - fHasShadow (1 bit): A bit that specifies whether one or more data points (section 2.2.3.10) in the chart group (section 2.2.3.7) has shadows.

reserved (12 bits): MUST be zero, and MUST be ignored.

Show:
© 2014 Microsoft