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.

GET 75% OFF THE COURSE
Free Ebook

Leave A Comment

Share This