Edit

Share via

ChartGroup.GapWidth property (Excel)

  • Article

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 on Chart1 to be 50 percent of the column width.

Charts("Chart1").ChartGroups(1).GapWidth = 50

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.