ChartGroup.SecondPlotSize property (Word)
Returns or sets the size, as a percentage of the primary pie, of the secondary section of either a pie-of-pie chart or a bar-of-pie chart. Read/write Long.
Syntax
expression.SecondPlotSize
expression A variable that represents a ChartGroup object.
Remarks
This property can have a value from 5 through 200.
Example
The following example splits the two sections of the chart by value, combining all values under 10 in the primary pie and displaying them in the secondary section. The secondary section is 50 percent of the size of the primary pie. You must run the example on either a pie-of-pie chart or a bar-of-pie chart.
With ActiveDocument.InlineShapes(1)
If .HasChart Then
With .Chart.ChartGroups(1)
.SplitType = xlSplitByValue
.SplitValue = 10
.VaryByCategories = True
.SecondPlotSize = 50
End With
End If
End With
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.