Automatically skip blanks in Excel charts with formulas (ignore gaps in Excel chart axis)

September 12, 2017 Excel Charts
Download the workbook here: http://www.xelplus.com/skip-dates-in-excel-charts/

In this video I show you how to dynamically ignore blank dates in charts. This trick doesn't just apply to dates, but to any data set that has gaps in it and you'd like Excel to completely ignore the gaps, even for cases where you have values in front of the gaps.

This video shows you how to use the Aggregate functions, Index & Match and Name Manager to get the desired result automatically.

Links to related videos:
Part 1: Manual approach to removing gaps in charts: https://rumble.com/v2tni3q
Index & Match basics: https://rumble.com/v2skkko
Index & Match advanced: https://rumble.com/v2skkns
Changing Chart Ranges with Index: https://rumble.com/v2tncdg

★ My Online Excel Courses ► https://courses.xelplus.com/

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel