ChartGroup.VaryByCategories property (PowerPoint)

True if Microsoft Word assigns a different color or pattern to each data marker. Read/write Boolean.

Syntax

expression.VaryByCategories

expression A variable that represents a ChartGroup object.

Remarks

The chart must contain only one series.

Example

Note

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

The following example assigns a different color or pattern to each data marker in chart group one. You should run the example on a 2D line chart that has data markers on a series.

With ActiveDocument.InlineShapes(1)

    If .HasChart Then

        .Chart.ChartGroups(1).VaryByCategories = True

    End If

End With

See also

ChartGroup Object

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.