Chart.ChartGroups property (Word)

Returns an object that represents either a single chart group or a collection of all the chart groups in the chart.

Syntax

expression. ChartGroups (Index)

expression A variable that represents a Chart object.

Parameters

Name Required/Optional Data type Description
Index Optional Variant The chart group number. If specified, a single ChartGroup object is returned. If omitted, a ChartGroups object, which contains a collection of every ChartGroup object for that chart, is returned.

Example

The following example enables up and down bars for the first chart group of the first chart, and then sets their colors. You should run this example on a 2D line chart that contains two series that intersect at one or more data points.

With ActiveDocument.InlineShapes(1).Chart.ChartGroups(1) 
 .HasUpDownBars = True 
 .DownBars.Interior.ColorIndex = 3 
 .UpBars.Interior.ColorIndex = 5 
End With

See also

Chart Object

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.