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
-
1:58:10
Robert Gouveia
16 hours agoMatt Gaetz REJECTS Report, Sues Committee; Luigi Fan Club Arrives; Biden Commutes; Festivus Waste
194K135 -
58:10
Kimberly Guilfoyle
17 hours agoAmerica is Back & The Future is Bright: A Year in Review | Ep. 183
103K59 -
3:03:27
vivafrei
22 hours agoEp. 242: Barnes is BACK AGAIN! Trump, Fani, J6, RFK, Chip Roy, USS Liberty AND MORE! Viva & Barnes
197K203 -
8:09:50
Dr Disrespect
20 hours ago🔴LIVE - DR DISRESPECT - MARVEL RIVALS - GOLD VANGUARD
208K34 -
1:15:00
Awaken With JP
19 hours agoMerry Christmas NOT Happy Holidays! Special - LIES Ep 71
257K211 -
1:42:21
The Quartering
21 hours agoTrump To INVADE Mexico, Take Back Panama Canal Too! NYC Human Torch & Matt Gaetz Report Drops!
190K114 -
2:23:15
Nerdrotic
20 hours ago $15.60 earnedA Very Merry Christmas | FNT Square Up - Nerdrotic Nooner 453
141K13 -
1:14:05
Tucker Carlson
20 hours ago“I’ll Win With or Without You,” Teamsters Union President Reveals Kamala Harris’s Famous Last Words
244K388 -
1:58:31
The Dilley Show
20 hours ago $37.78 earnedTrump Conquering Western Hemisphere? w/Author Brenden Dilley 12/23/2024
179K50 -
1:09:59
Geeks + Gamers
21 hours agoSonic 3 DESTROYS Mufasa And Disney, Naughty Dog Actress SLAMS Gamers Over Intergalactic
122K21