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.
expression A variable that represents a Chart object.
|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.|
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
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.