ChartGroup.GapWidth Property (Excel)
Bar and Column charts: Returns or sets the space between bar or column clusters, as a percentage of the bar or column width. Pie of Pie and Bar of Pie charts: Returns or sets the space between the primary and secondary sections of the chart. Read/write Long.
Syntax
expression .GapWidth
expression A variable that represents a ChartGroup object.
Remarks
The value of this property must be between 0 and 500.
Example
This example sets the space between column clusters in Chart1 to be 50 percent of the column width.
Charts("Chart1").ChartGroups(1).GapWidth = 50