Chart & Visualization Issues

How to Change Spacing Between Bars in an Excel Column Chart

Muhammad TalhaMuhammad Talha Nov 2, 2026 872 views

Question details

The user wants to adjust the gap width between columns in an Excel clustered column chart to customize the chart layout.

How to Change Spacing Between Bars in an Excel Column Chart
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.
Before you start

Ensure you have inserted a clustered column chart or bar chart in your spreadsheet and that it contains at least one visible data series.

Solution 1Recommended

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

1
Select a data series

Click on your chart, then right-click on one of the data columns (bars) within the chart area to open the context menu.

2
Open Format Data Series

Choose 'Format Data Series...' from the right-click menu. This will open a formatting pane, typically on the right side of your screen.

3
Locate Series Options

In the formatting pane, ensure the 'Series Options' icon (which usually looks like a small column chart) is selected.

4
Adjust the Gap Width

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 Gap Width Using Format Data Series
Chart Type Compatibility: If the Gap Width option is unavailable in the formatting pane, verify that you are using a standard 2D clustered column or bar chart. Certain custom, specialized, or 3D chart types might not support adjusting the gap width.
Customize Charts Easily

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. 1. Open Spreadsheet: Launch WPS Office, open your spreadsheet, and click on your existing column chart.
  2. 2. Access Data Series Formatting: Right-click any data column in the chart and select 'Format Data Series'.
  3. 3. Navigate to Series Options: In the right-side properties pane, click the 'Series Options' icon.
  4. 4. Change Spacing: Drag the 'Gap Width' slider to smoothly increase or decrease the spacing between your chart bars.
Directly adjust Gap Width and Series Overlap in a familiar formatting pane.Fully compatible with Microsoft Excel (.xlsx) chart formats and layouts.Lightweight, fast, and free office suite with powerful data visualization tools.
microsoft office alternative - wps office

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.