BarGroups Method [Excel 2003 VBA Language Reference]

On a 2-D chart, returns an object that represents either a single bar chart group (a ChartGroup object) or a collection of the bar chart groups (a ChartGroups collection).


expression Required. An expression that returns a Chart object.

Index   Optional Variant. Specifies the chart group.


This example sets the space between bar clusters in the 2-D bar chart group to be 50 percent of the bar width.

Charts(1).BarGroups(1).GapWidth = 50

Applies to | Chart Object

See Also | AreaGroups Method | Bar3DGroup Property | ChartGroups Method | ColumnGroups Method | DoughnutGroups Method | LineGroups Method | PieGroups Method