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 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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for