Table of contents
Collapse the table of content
Expand the table of content

ChartGroup.SplitValue Property (PowerPoint)

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

Returns or sets the threshold value separating the two sections of either a pie-of-pie chart or a bar-of-pie chart. Read/write Variant.


expression. SplitValue

expression A variable that represents a ChartGroup object.


Note Although the following code applies to Microsoft Word, you can readily modify it to apply to PowerPoint.

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. You must run this 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

        End With

    End If

End With

See also


ChartGroup Object

© 2018 Microsoft