Share via


ChartGroup.VaryByCategories Property (Excel)

True if Microsoft Excel assigns a different color or pattern to each data marker. The chart must contain only one series. Read/write Boolean.

Syntax

expression .VaryByCategories

expression A variable that represents a ChartGroup object.

Example

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

Charts("Chart1").ChartGroups(1).VaryByCategories = True

See Also

Concepts

ChartGroup Object Members

ChartGroup Object