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
Barry Cunningham
2 hours agoPRESIDENT TRUMP UNLEASHES HIS WRATH! NOW IT'S DEFINITELY GAME ON! HUGE TRADE WIN!
8,331 watching -
LIVE
RalliedLIVE
3 hours ago $1.37 earnedHIGH OCTANE WARZONE SOLOS ALL DAY
446 watching -
LIVE
SpartakusLIVE
3 hours agoThe $1,000 Spartakus Gauntlet || Huskerrs and Twitty
356 watching -
10:19
MattMorseTV
7 hours ago $0.58 earnedTrump just went SCORCHED EARTH.
85311 -
1:27:56
Glenn Greenwald
4 hours agoSemafor Editor Ben Smith on Epstein Saga; How do MAGA Supporters Really Feel About Trump's Foreign Policy? Eddington Movie Review: Reflections on 2020 | SYSTEM UPDATE #490
101K45 -
1:05:20
BonginoReport
5 hours agoEpstein: From “Case Closed” to “To Be Continued” - Nightly Scroll w/ Hayley Caronia (Ep.95)
115K49 -
48:41
The Mel K Show
3 hours agoMel K & Aaron Day | Wake up! Walking Blindly into Totalitarian Technocracy | 7-22-25
15.5K3 -
LIVE
Anthony Rogers
1 day agoEpisode 375 - Randy Valerio
39 watching -
1:32:14
Kim Iversen
5 hours ago"Obama Belongs In Jail!" Tulsi Gabbard Exposes Entire Russiagate Hoax
101K92 -
LIVE
AlphaZeroOmega
1 hour agoHitman: ⚔ Ozzy Osbourne Tribute ⚔ | 🚨Rumble Studio Direct RTMP🚨
25 watching