Bar and Column charts: Returns or sets the space between bar or column clusters, as a percentage of the bar or column width. The value of this property must be between 0 and 500. Read/write Long.
Pie of Pie and Bar of Pie charts: Returns or sets the space between the primary and secondary sections of the chart. The value of this property must be between 5 and 200. Read/write Long.
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