How to get Excel Chart Columns with no gaps

When you create a column chart, you may want to change the gap size between the series, normally to remove the gap from the column chart. So below we want to have no gaps in the chart.

How to get Excel Chart Columns with no gaps

In order to do this you can right click on any one of the data series and choose Format Data Series. You will notice that one of the options is Gap Width and the default is 150%.

You can play with this gap width but the extreme would be to remove the gap completely (make it 0%) as shown below.

How to get Excel Chart Columns with no gaps

In this case it is important to note even though we only chose one series, all the series on that axis (the primary axis in this case) HAVE to have the same gap width. You can’t have one series having no gap and another series on the same vertical axis having a gap. In order to generate that appearance you need to trick Excel. We cover this is our Excel Dashboards Course.