How do you create gaps on the horizontal axis of a line chart when the data values are empty – i.e. contain blank cells?

Excel normally fills the empty dates on the x-axis and connects the line (where the gap should be).

How do you avoid this?

How do you skip dates in Excel chart axis?

Here is one method that shows you that.

This basically means that the chart that looks like a simple column chart, is in fact two sets of stacked charts.

Yes, it does require some work, but once you have it setup, you can re-use as much as you want.

Watch the steps in this video:

 

Feel free to Download the Workbook HERE.

Free Excel Download

Excel Dashboards that Inform & Impress

Use these techniques in your own reports

Unbeatable value!

LEARN MORE