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](./Excel.ChartGroup(Graph object).md) 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

See also

ChartGroup Object