Chart & Visualization Issues

How to Find Chart Gap Width Settings in Excel

Elise WilliamsElise Williams Oct 14, 2026 873 views

Question details

The user is unable to locate the Gap Width setting in the Format Data Series pane to adjust chart spacing.

How to Find Chart Gap Width Settings in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the chart columns

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.

2
Open the Format Data Series pane

Right-click the highlighted data series and choose 'Format Data Series' from the context menu.

3
Navigate to Series Options

In the pane that opens on the right, click the 'Series Options' icon, which resembles three vertical bars.

4
Adjust the Gap Width

Scroll down to find the 'Gap Width' slider. Drag the slider or type a specific percentage to adjust the spacing between your columns.

Select the Data Series and Verify Chart Type
Tip: Lowering the Gap Width percentage makes the bars wider and the spaces narrower. Setting it to 0% makes the columns touch each other.
Create and Format Charts Easily

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. 1. Open your spreadsheet: Launch WPS Office and open the workbook containing your chart data.
  2. 2. Access series formatting: Double-click directly on the chart's bars or columns to automatically open the right-side properties panel.
  3. 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.
Seamlessly open, edit, and save Microsoft Excel file formats (.xlsx, .xls) without formatting loss.Easily accessible chart formatting tools, including Gap Width and Series Overlap sliders.Lightweight installation ensures fast performance even with data-heavy charts.Free to use with a highly familiar user interface, requiring zero learning curve.
microsoft office alternative - wps office

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.