XYGroups Method
On a 2-D chart, returns an object that represents either a single scatter chart group (a ChartGroup object) or a collection of the scatter chart groups (a ChartGroups collection).
expression.XYGroups(Index)
expression Required. An expression that returns a Chart object.
Index Optional Variant. Specifies the chart group.
Example
This example sets X-Y group (scatter group) one to use a different color for each data marker. The example should be run on a 2-D chart.
Charts("Chart1").XYGroups(1).VaryByCategories = True