Premium Only Content

Skip Dates in Excel Charts (Ignore gaps in Excel horizontal chart axis)
Sep 7, 2017 Excel Charts
Download the workbook here: http://www.xelplus.com/skip-dates-in-excel-charts/
For Part 2: Dynamic approach using formulas: https://rumble.com/v2tni5o
In this video I show you how to create gaps on the horizontal axis of a line chart when the data values are empty - i.e. contain blank cells. Excel normally fills the empty dates on the x-axis and connects the line (where the gap should be). How do you avoid this? How do you skip dates in Excel chart axis? Here is one method that shows you that.
★ 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
-
29:08
Afshin Rattansi's Going Underground
1 day agoCol. Lawrence Wilkerson: World War 3 is ALREADY HERE, Netanyahu is INTENT on Greater Israel
10K21 -
LIVE
SpartakusLIVE
6 hours agoNONSTOP Snipes, Rockets, and BICEPS = Monday MOTIVATION
492 watching -
Rallied
7 hours ago $0.39 earnedSolo Challenges All Day
42.4K2 -
1:27:53
Flyover Conservatives
9 hours agoIs AI Actually Alien Intelligence? Dr. Jason Dean Exposes the Dark Side | FOC Show
21.9K -
1:47:36
Glenn Greenwald
6 hours agoJD Vance and Rand Paul Clash on Due Process: War on Terror Echoes; Has the U.S. Given Up on Confronting China? Ben Shapiro's Latest Falsehoods About Israel | SYSTEM UPDATE #510
93.2K67 -
LIVE
RaikenNight
4 hours ago $0.39 earnedExploring the Galaxy of No Mans Sky
206 watching -
LIVE
Spartan
5 hours agoRanked and Expedition 33 (NG+4 and all enemies Set to 10x health)
86 watching -
2:54:31
Jokeuhl Gaming and Chat
9 hours agoDARKTIDE - Warhammer 40k w/ Nubes and AoA
11.9K1 -
2:19:56
Nerdrotic
15 hours ago $1.07 earnedNerdrotic Nooner 513
46.2K2 -
BigTallRedneck
4 hours agoRANKED FINALS W OMEGA
16K1