How to Find Chart Gap Width Settings in Excel
Question details
The user is unable to locate the Gap Width setting in the Format Data Series pane to adjust chart spacing.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Formatting a chart's data series to change the spacing between bars or columns.
- Observed behavior
- The Format Data Series pane only displays Plot Series and Axis options, and the Gap Width setting is entirely missing.
Ensure that your chart is formatted as a column or bar chart, as the Gap Width setting is not supported for chart types like line, pie, or scatter charts.
Select the Data Series and Verify Chart Type
Access the specific Series Options by explicitly selecting a data column or bar within your chart.
The Gap Width setting only appears when a supported data series (like a column or bar) is actively selected. Clicking the chart background or the axes will display different formatting options.
Click directly on one of the data columns or bars inside your chart. This selects the entire data series, indicated by small highlight dots on the bars.
Right-click the highlighted data series and choose 'Format Data Series' from the context menu.
In the pane that opens on the right, click the 'Series Options' icon, which resembles three vertical bars.
Scroll down to find the 'Gap Width' slider. Drag the slider or type a specific percentage to adjust the spacing between your columns.

Test in a New Workbook to Rule Out File Corruption
If the setting is still missing on a valid chart type, check if the issue is limited to the current file or affects the entire Excel application.
Adjust Chart Spacing Effortlessly with WPS Spreadsheet
WPS Spreadsheet offers a highly intuitive interface for building and customizing charts. You can instantly access Series Options to adjust gap widths, overlap, and colors without navigating through complex menus.
- 1. Open your spreadsheet: Launch WPS Office and open the workbook containing your chart data.
- 2. Access series formatting: Double-click directly on the chart's bars or columns to automatically open the right-side properties panel.
- 3. Modify the Gap Width: Under the 'Series' tab in the panel, find the 'Gap Width' input box or slider and adjust it to set your preferred chart spacing.

Frequently Asked Questions
Why is the Gap Width option missing in my Excel chart?
The Gap Width option is specific to certain chart types, such as column, bar, and histogram charts. If you have selected a line chart, pie chart, or the chart axis instead of the data series, the Gap Width setting will not appear.
How do I make my Excel chart bars wider?
To increase the width of the bars, you must decrease the Gap Width. Right-click the data series, select Format Data Series, and lower the percentage in the Gap Width setting. A lower percentage means less empty space and wider bars.
Can I adjust the gap width for a combo chart?
Yes, but you must select the specific data series that is formatted as a column or bar. Click exactly on the column portion of your combination chart, right-click it, and choose Format Data Series to reveal the Gap Width option.
What is the default gap width percentage in Excel?
The default gap width for a standard column chart in modern versions of Excel is typically set to 219%, which means the empty space between the columns is slightly more than twice the width of a single column.




