Share via


ChartGroup.GapWidth Property

Excel Developer Reference

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.

Visual Basic for Applications
  Charts("Chart1").ChartGroups(1).GapWidth = 50

See Also