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
-
10:17
Dr Disrespect
19 hours agoIt's Time To Get Serious
72.1K11 -
3:39:10
"What Is Money?" Show
4 days agoBitcoin and the Mystery of Money w/ Robert Breedlove
19.6K -
12:57
Zoufry
19 hours ago $1.34 earnedThe Car Theft Epidemic in America
29.8K5 -
9:05
MattMorseTV
16 hours ago $4.72 earnedThis changes EVERYTHING.
89K37 -
2:20:23
Side Scrollers Podcast
20 hours agoElon Musk Creates GOONING AI, DSP Lawsuit?, Disney Adults Hit NEW LOW | Side Scrollers Live
42.4K6 -
1:58:04
FreshandFit
9 hours agoWhy Women Are Always Single?
211K33 -
1:12:39
Man in America
16 hours agoThe Frightening Truth About Weather Warfare & Depopulation w/ Kim Bright
128K51 -
2:59:21
TimcastIRL
10 hours agoTrump Calls Epstein Case A HOAX By Democrats, GOP Votes TO BLOCK Release | Timcast IRL
272K312 -
7:55:30
SpartakusLIVE
12 hours agoDuos w/ Sophie || Charity stream tomorrow!
84.3K1 -
58:43
Sarah Westall
11 hours agoBecause Voluntary Extermination is a Thing: Israel-Gaza w/ Award Winning Journalist James Robins
62.1K25