Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

2.4.25 BopPop

Office

The BopPop record specifies that the chart group is a bar of pie chart group or a pie of pie chart group and specifies the chart group 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

pst

fAutoSplit

split

iSplitPos

pcSplitPercent

pcPie2Size

pcGap

numSplitValue

...

A

reserved

pst (1 byte): An unsigned integer that specifies whether this chart group is a bar of pie chart group or a pie of pie chart group. MUST be a value from the following table:

Value

Subtype

0x01

Pie of pie chart group

0x02

Bar of pie chart group

fAutoSplit (1 byte): A Boolean (section 2.5.14) that specifies whether the split point of the chart group is determined automatically. If the value is 1, when a bar of pie chart group or pie of pie chart group is initially created the data points from the primary pie are selected and inserted into the secondary bar/pie automatically.

split (2 bytes): An unsigned integer that specifies what determines the split between the primary pie and the secondary bar/pie. MUST be ignored if fAutoSplit is set to 1. MUST be a value from the following table:

Value

Type of split

Meaning

0x0000

Position

The data is split based on the position of the data point in the series as specified by iSplitPos.

0x0001

Value

The data is split based on a threshold value as specified by numSplitValue.

0x0002

Percent

The data is split based on a percentage threshold and the data point values represented as a percentage as specified by pcSplitPercent.

0x0003

Custom

The data is split as arranged by the user. Custom split is specified in a following BopPopCustom record.

iSplitPos (2 bytes): A signed integer that specifies how many data points are contained in the secondary bar/pie. Data points are contained in the secondary bar/pie starting from the end of the series. For example, if the value is 2, the last 2 data points in the series are contained in the secondary bar/pie. MUST be a value greater than or equal to 0 and less than or equal to 32000. If the value is more than the number of data points in the series, the entire series will be in the secondary bar/pie, except for the first data point. If split is not set to 0x0000 or fAutoSplit is set to 1, this value MUST be ignored.

pcSplitPercent (2 bytes): A signed integer that specifies the percentage below which each data point is contained in the secondary bar/pie as opposed to the primary pie. The percentage value of a data point is calculated using the following formula:

(value of the data point x 100) / sum of all data points in the series

If split is not set to 0x0002 or if fAutoSplit is set to 1, this value MUST be ignored

pcPie2Size (2 bytes): A signed integer that specifies the size of the secondary bar/pie as a percentage of the size of the primary pie. MUST be a value greater than or equal to 5 and less than or equal to 200.

pcGap (2 bytes): A signed integer that specifies the distance between the primary pie and the secondary bar/pie. The distance is specified as a percentage of the average width of the primary pie and secondary bar/pie. MUST be a value greater than or equal to 0 and less than or equal to 500, where 0 is 0% of the average width of the primary pie and the secondary bar/pie, and 500 is 250% of the average width of the primary pie and the secondary bar/pie.

numSplitValue (8 bytes): An Xnum (section 2.5.342) value that specifies the split when the split field is set to 0x0001. The value of this field specifies the threshold that selects which data points of the primary pie move to the secondary bar/pie. The secondary bar/pie contains any data points with a value less than the value of this field. If split is not set to 0x0001 or if fAutoSplit is set to 1, this value MUST be ignored.

A - fHasShadow (1 bit): A bit that specifies whether one or more data points in the chart group have shadows.

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

Show:
© 2016 Microsoft