Skip Dates in Excel Charts

Ignore gaps in Excel horizontal chart axis

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

The new Excel Dashboards course is here!

Now available on Udemy

Visually Effective Excel Dashboards for your reports.
Redeem your coupon for 75% off below.

Free Ebook


  1. Raymond May 14, 2018 at 8:14 pm - Reply

    Very nice this technic, but my data is horizontally so I can not create a table right? or do you have another solution for me

  2. George June 14, 2018 at 12:03 pm - Reply

    Really helpful … you have no idea how much. Thank you

Leave A Comment

Share This