title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
---|---|---|---|---|---|---|---|---|
ChartGroup.GapWidth property (Excel) |
vbaxl10.chm568078 |
|
|
2bf93d07-9181-f43c-5a0f-9350fc1ebd62 |
04/20/2019 |
medium |
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.
expression.GapWidth
expression A variable that represents a ChartGroup object.
The value of this property must be between 0 and 500.
This example sets the space between column clusters on Chart1 to be 50 percent of the column width.
Charts("Chart1").ChartGroups(1).GapWidth = 50
[!includeSupport and feedback]