GapWidth property (Excel Graph)

For 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.

For Pie of Pie and Bar of Pie charts: Returns or sets the space between the primary and secondary sections of the specified chart. The value of this property must be between 5 and 200. Read/write Long.

Syntax

expression.GapWidth

expression Required. An expression that returns one of the objects in the Applies To list.

Example

This example sets the space between column clusters to be 50 percent of the column width.

myChart.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.