Chart & Visualization Issues

How to Change Bar Width and Gap in Excel Charts

Amos GikundaAmos Gikunda Nov 4, 2026 870 views

Question details

Adjust the width of bars and the spacing (gap width) between them in an Excel bar or column chart.

How to Change Bar Width and Gap in an Excel Chart
Product
Excel
Device & OS
not provided
Scenario
Customizing the visual appearance of a bar or column chart to make the data more readable and professionally formatted.
Observed behavior
The default chart layout may display bars that are too thin or gaps that are too wide, requiring manual adjustment.
Before you start

Ensure you have already inserted a bar or column chart into your spreadsheet and that it is populated with your desired data series.

Solution 1Recommended

Adjust Gap Width via the Format Data Series Pane

Use the built-in Format Data Series options to manually drag the Gap Width slider, which directly controls the thickness of your chart bars.

In Excel, bar widths are not determined by an exact pixel measurement but rather by the space between them. By decreasing the 'Gap Width', you automatically increase the width of the bars.

1
Select the data series

Click anywhere on your chart to activate it, then click directly on one of the bars. This will select the entire data series.

2
Open Format Selection

Right-click the selected bar and choose 'Format Data Series' from the context menu, or navigate to the Format tab and click 'Format Selection' in the Current Selection group.

3
Modify the Gap Width

In the Format Data Series pane that appears on the right, look under 'Series Options'. Drag the 'Gap Width' slider to the left (decreasing the percentage) to make your bars wider.

4
Adjust Series Overlap

If your chart contains multiple data series side-by-side, adjust the 'Series Overlap' slider to change the spacing between bars within the same category.

Adjust Gap Width via the Format Data Series Pane
Pro Tip: A Gap Width of 0% will make the bars touch each other completely. A typical aesthetic range for clean data presentation is between 50% and 100%.
Professional Spreadsheet Editor

Easily Adjust Chart Formatting in WPS Spreadsheet

WPS Spreadsheet provides intuitive charting tools that make adjusting bar widths, colors, and layouts a breeze. Enjoy full compatibility with Microsoft Excel formats while using a lightweight, efficient, and feature-rich interface.

  1. 1. Open your file: Launch WPS Spreadsheet and open the workbook containing your bar or column chart.
  2. 2. Select the data series: Double-click on one of the bars in your chart to instantly open the formatting pane on the right side of the screen.
  3. 3. Navigate to series options: In the formatting pane, click on the 'Series Options' icon to access the specific layout settings for your bars.
  4. 4. Adjust gap width: Drag the 'Gap Width' slider to customize the bar thickness, and tweak the 'Series Overlap' if you are displaying multiple sets of data.
Fully compatible with Microsoft Excel (.xlsx, .xls) files and complex chart formats.Intuitive side-panel for instant gap width and series overlap adjustments.Rich gallery of professional chart templates built-in for better visualization.
microsoft office alternative - wps office

Frequently Asked Questions

What is the difference between Gap Width and Series Overlap?

Gap Width controls the empty space between different categories on the chart's axis. Series Overlap, on the other hand, controls the spacing between multiple bars of different data series within the exact same category.

Why is the Format Data Series option missing or grayed out?

This usually happens if you have selected the entire chart area or plot area instead of the data itself. Make sure you click directly on one of the colored bars inside the chart to specifically select the data series.

Can I set an exact pixel width for my chart bars?

No, Excel and most spreadsheet programs use percentage-based spacing (Gap Width) rather than exact pixel measurements for bar widths. This ensures that the bars scale correctly if the overall chart size is expanded or shrunk.

Can I change the width of just one single bar?

By default, adjusting the Gap Width applies to the entire data series to maintain correct chart proportions. While you can click a second time on a single bar to change its individual color, its width will remain tied to the series settings.