How to Change Gap Width in Excel Bar Chart

This post will guide you how to change gap width for an existing bar chart in Excel. How do I change the width of charts columns in Excel.

Change Gap Width in Bar Chart


When you created a bar chart based on data in your worksheet, it will have gaps between their bars by default. And you maybe not like this default appearance, and you want to change the size of the gaps between bars or you want to remove gaps between data series in your bar chart. How to do it. You can do the following steps to change it:

#1 right click on one of the data series in your bar chart, and select Format Data Series from the popup menu list. And the Format Data Series pane will appear on the right side of the window.

change gap width in bar chart1

#2 click Series Options button in the Format Data Series pane, and you can drag the slider to change the gap widths in Gap Width section.

change gap width in bar chart2

#3 you should see that your bar chart is changed immediately.

change gap width in bar chart3

#4 close Format Data Series pane.

 

You might also like:

Sidebar