How to Change Spacing Between Bars in an Excel Column Chart
Question details
The user wants to adjust the gap width between columns in an Excel clustered column chart to customize the chart layout.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Customizing chart layouts to improve data visualization, clarity, and overall aesthetics by controlling column width and spacing.
- Observed behavior
- The user needs to locate and modify the series overlap and gap width settings, which dictate how close the columns are to one another.
Ensure you have inserted a clustered column chart or bar chart in your spreadsheet and that it contains at least one visible data series.
Adjust Gap Width Using Format Data Series
This is the standard and most direct method to change the spacing between your chart's columns in modern spreadsheet interfaces.
The gap between columns is controlled by a percentage setting. Increasing the percentage creates a wider gap (thinner bars), while decreasing it shrinks the gap (wider bars).
Click on your chart, then right-click on one of the data columns (bars) within the chart area to open the context menu.
Choose 'Format Data Series...' from the right-click menu. This will open a formatting pane, typically on the right side of your screen.
In the formatting pane, ensure the 'Series Options' icon (which usually looks like a small column chart) is selected.
Find the 'Gap Width' slider or input box. Drag the slider to the left to decrease the gap (making bars wider and closer together), or drag it to the right to increase the gap (making bars thinner and further apart).

Adjust Chart Bar Spacing in WPS Spreadsheet
WPS Office provides an intuitive, highly compatible interface for customizing charts. You can easily adjust the gap width and series overlap in WPS Spreadsheet exactly as you would in Microsoft Excel, entirely for free.
- 1. Open Spreadsheet: Launch WPS Office, open your spreadsheet, and click on your existing column chart.
- 2. Access Data Series Formatting: Right-click any data column in the chart and select 'Format Data Series'.
- 3. Navigate to Series Options: In the right-side properties pane, click the 'Series Options' icon.
- 4. Change Spacing: Drag the 'Gap Width' slider to smoothly increase or decrease the spacing between your chart bars.

Frequently Asked Questions
Why can't I find the Gap Width option in my chart?
The Gap Width setting is exclusively available for specific chart types, such as 2D clustered column and bar charts. If you are using a scatter plot, pie chart, or certain 3D surface charts, the option will be hidden because those visual formats do not support gap width adjustments.
How do I change the spacing between multiple data series within the same category?
To adjust the spacing between different data series inside a single category group, use the 'Series Overlap' setting located directly above the Gap Width option in the Format Data Series pane. A negative percentage separates the series, while a positive percentage makes them overlap.
Does setting the gap width to 0% merge the bars entirely?
Yes. Setting the Gap Width to 0% completely removes the spacing between the categories, causing the bars to touch each other side-by-side. This configuration is widely used when converting a standard column chart into a histogram.




