Share via


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

See Also

Concepts

ChartGroup Object

ChartGroup Object Members