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 how do we get Excel chart columns with no gaps in the chart below?

How to get Excel Chart Columns with no gaps

YouTube Remove gaps in Excel charts

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.

Want to learn more about Microsoft Excel? If you prefer attending a course and live in South Africa look at the Johannesburg MS Excel 3 Day Advanced Course  or the Cape Town MS Excel 3 Day Advanced training course. If you prefer online learning or live outside South Africa, look at our online MS Excel training courses.

Date Axis in Excel Chart is wrong

Make Excel charts primary and secondary axis the same scale

How to make a smooth line chart in Excel

Copy Excel chart into PowerPoint or Word