ChartGroups Method

Applies To

Chart Object.

Description

Accessor. Returns an object that represents a single chart group (a ChartGroup object, Syntax 1) or a collection of all the chart groups in the chart (a ChartGroups object, Syntax 2). Every type of group is included in the returned collection.

Syntax 1

object.ChartGroups(index)

Syntax 2

object.ChartGroups

object

Required. The Chart object.

index

Required for Syntax 1. The number of the chart group.

Example

This example turns on up and down bars for chart group one on Chart1 and then sets their colors. The example should be run on a 2-D line chart containing two series that cross each other at one or more data points.

With Charts("Chart1").ChartGroups(1)
    .HasUpDownBars = True
    .DownBars.Interior.ColorIndex = 3
    .UpBars.Interior.ColorIndex = 5
End With