2.4.25 BopPop
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.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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.