BarGroups Method

Microsoft Excel Visual Basic

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.BarGroups(Index)

expression    Required. An expression that returns a Chart object.

Index    Optional Variant. Specifies the chart group.

Example

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