Exploding Pies
A slice of a pie chart can be emphasized by exploding it, which extrudes the slice from the rest of the pie. Use the Offset property to set the exploded slice’s offset from the center of the pie. The offset is measured as a percentage of the radius of the pie.
Exploding slices must be set programmatically, and can be set by series, or by a single slice. To set the properties for an exploding slice for a specific slice of all pies, access the Slice object through the Style object for the corresponding series.
' Sets the offset for the first series to 10% of the pie's radius
Chart2D1.ChartGroups(1).Styles(1).Slice.Offset = 10
' Resets the exploded slices.
Chart2D1.ChartGroups(1).Styles(1).Slice.Offset = 0
To set the properties for an exploding slice for a single point, access the Slice object through the PointStyles collection. The first number in the PointStyle’s Item method specifies the Series, and the second number specifies the point.
' Sets the offset for the third point of the second
' series to 15% of the pie's radius
Chart2D1.ChartGroups(1).PointStyles.Item(2,3).Slice.Offset = 15
' Resets the exploded slice.
Chart2D1.ChartGroups(1).PointStyles.Item(2,3).Slice.UseDefault = True