XYGroups Method [Excel 2003 VBA Language Reference]

  • Article

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 line chart with a single series.

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

Applies to | Chart Object