Change space between bars in an Excel chart

By default Excel column and bar charts leave you with a lot of space between bars, which doesn’t look great visually and is a bit of a waste of space.

 

Fortunately it is simple to change the gap widths between the bars. Right-click on a bar and select Format Series, under Series Options you will see Gap Width. Adjust it to a % figure that looks about right and it’s job done.

 

changebarspace1

Leave a Reply

Your e-mail address will not be published. Required fields are marked *