Premium Only Content

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
-
LIVE
Michael Franzese
41 minutes agoThis Is the Most Important Thing I’ll Ever Say
526 watching -
LIVE
Barry Cunningham
1 hour agoPRESIDENT TRUMP TOURS JEROME POWELL SCENE OF THE CRIME AT THE FEDERAL RESERVE
2,639 watching -
LIVE
The White House
1 hour agoPresident Trump Visits the Federal Reserve
1,495 watching -
LIVE
Kimberly Guilfoyle
2 hours agoRussia Hoax Reality Check, Live! | Ep240
451 watching -
1:07:35
vivafrei
2 hours agoWall Street Journal DOUBLING DOWN on Epstein! Lawyer in Canada DEBANKED! AND MORE!
83.9K17 -
4:42:20
Donut Operator
5 hours agoI'M BACK/ CRIME/ GAMEBOY CAMERA CHAD
88.6K4 -
9:51
Warren Smith - Secret Scholar Society
5 days agoThe Moment Tim Pool Discovered Why Andrew Wilson is so Unstoppable
11.3K23 -
28:23
Film Threat
4 hours agoLIVE FROM SAN DIEGO COMIC-CON! (Thursday) | Film Threat Live
364 -
1:40:00
The Quartering
2 hours agoEpstein Burnout, Hulk Hogan Dies, South Park Flops & Much More
113K28 -
10:05
Michael Button
6 hours ago $0.10 earnedGroundbreaking Discovery at Stonehenge Rewrites History
9.76K6