Description
Represents one or more series plotted in a chart using 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 a line chart group, containing all the series plotted using the line chart format, and a bar chart group, containing all the series plotted using the bar chart format.
Accessors
The ChartGroup object is a member of the ChartGroups collection. To access a single member of the collection, use the ChartGroups method with the chart group index number as an argument. The following example adds drop lines to chart group one.
Charts(1).ChartGroups(1).HasDropLines = True
If the chart has been activated, you can use the ActiveChart property:
Charts(1).Activate ActiveChart.ChartGroups(1).HasDropLines = True
The chart group index number for a particular chart group can change if the chart format used for that group is changed. For this reason, it may be easier to use one of the named chart group shortcut methods to access 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 to return a ChartGroups collection. The following chart group methods are available:
AreaGroups Method, BarGroups Method, ColumnGroups Method, DoughnutGroups Method, LineGroups Method, PieGroups Method, DownBars, DropLines, HiLoLines, Series, SeriesLines, UpBars
Properties
Application Property, AxisGroup Property, Creator Property, DoughnutHoleSize Property, DownBars Property, DropLines Property, FirstSliceAngle Property, GapWidth Property, HasDropLines Property, HasHiLoLines Property, HasRadarAxisLabels Property, HasSeriesLines Property, HasUpDownBars Property, HiLoLines Property, Overlap Property, Parent Property, RadarAxisLabels Property, SeriesLines Property, SubType Property, Type Property, UpBars Property, VaryByCategories Property.
Methods
SeriesCollection Method.