How to Change Bar Width and Gap in Excel Charts
Question details
Adjust the width of bars and the spacing (gap width) between them in an Excel bar or column 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.
Ensure you have already inserted a bar or column chart into your spreadsheet and that it is populated with your desired data series.
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.
Click anywhere on your chart to activate it, then click directly on one of the bars. This will select the entire data series.
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.
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.
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.

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. Open your file: Launch WPS Spreadsheet and open the workbook containing your bar or column chart.
- 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. Navigate to series options: In the formatting pane, click on the 'Series Options' icon to access the specific layout settings for your bars.
- 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.

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.




