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.
#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.
#3 you should see that your bar chart is changed immediately.
#4 close Format Data Series pane.