ChartGroup.SplitType (Excel)

Returns or sets the way the two sections of either a Pie of Pie chart or a Bar of Pie chart are split. Possible return values are xlSplitByCustomSplit - Arbitrary slides are displayed in the second chart, xlSplitByPercentValue - Second chart displays values less than some percentage of the total value. The percentage is specified by the SplitValue property, xlSplitByPosition - Second chart displays the smallest values in the data series. The number of values to display is specified by the SplitValue property, xlSplitByValue - Second chart displays values less than the value specified by the SplitValue property.

ActiveChart.ChartGroups(1).SplitType = xlSplitByCustomSplit