Applies To
ChartGroup Object.
Description
If this property is True, Microsoft Excel assigns a different color or pattern to each data marker. The chart must contain only one series. Read-write.
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