ChartGroups Collection [Excel 2003 VBA Language Reference]

Multiple objects

A collection of all the ChartGroup objects in the specified chart. Each ChartGroup object represents one or more series plotted in a chart with the same format. A chart contains one or more chart groups, each chart group contains one or more series, and each series contains one or more points. For example, a single chart might contain both a line chart group, containing all the series plotted with the line chart format, and a bar chart group, containing all the series plotted with the bar chart format.

Using the ChartGroups Collection

Use the ChartGroups method to return the ChartGroups collection. The following example displays the number of chart groups on embedded chart one on worksheet one.

MsgBox Worksheets(1).ChartObjects(1).Chart.ChartGroups.Count

Use ChartGroups(index), where index is the chart-group index number, to return a single ChartGroup object. The following example adds drop lines to chart group one on chart sheet one.

Charts(1).ChartGroups(1).HasDropLines = True

If the chart has been activated, you can use ActiveChart:

ActiveChart.ChartGroups(1).HasDropLines = True

Because the index number for a particular chart group can change if the chart format used for that group is changed, it may be easier to use one of the named chart group shortcut methods to return a particular chart group. The PieGroups method returns the collection of pie chart groups in a chart, the LineGroups method returns the collection of line chart groups, and so on. Each of these methods can be used with an index number to return a single ChartGroup object, or without an index number to return a ChartGroups collection. The following chart group methods are available:

Properties | Application Property | Count Property | Creator Property | Parent Property

Methods | Item Method

Parent Objects

Child Objects | DownBars | DropLines | HiLoLines | SeriesLines | TickLabels | UpBars