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
-
15:51
GritsGG
14 hours agoWinning a Warzone Match From a Tree! #1 Player's POV!
6.26K1 -
2:31:01
The Connect: With Johnny Mitchell
1 day ago $36.22 earned"It's About To Get Worse"- CIA Agent Andrew Bustamante Explains Why It's Time To Leave America
42.2K72 -
16:21
The Pascal Show
1 day ago $1.80 earned'THE FEDS MADE THIS UP!' Candace Owens Drops BOMBSHELL Pushing Back On Details In Charlie Kirk Case
6.44K6 -
LIVE
Lofi Girl
2 years agoSynthwave Radio 🌌 - beats to chill/game to
270 watching -
25:39
DeVory Darkins
13 hours ago $20.83 earnedMass shooting erupts in Michigan as bombshell study shows left wing political violence skyrocketed
38.5K108 -
5:55:33
MattMorseTV
11 hours ago $127.42 earned🔴Portland ANTIFA vs. ICE.🔴
168K324 -
3:13:00
Badlands Media
1 day agoThe Narrative Ep. 40: Acceleratia.
75.6K27 -
6:57:01
SpartakusLIVE
10 hours ago#1 Solo Spartan Sunday || TOXIC Comms, TACTICAL Wins, ENDLESS Content
63.5K5 -
49:45
Sarah Westall
9 hours agoComedians take Center Stage as World goes Nuts w/ Jimmy Dore
45.6K20 -
3:26:14
IsaiahLCarter
17 hours ago $12.40 earnedAntifa Gets WRECKED. || APOSTATE RADIO 030 (Guests: Joel W. Berry, Josie the Redheaded Libertarian)
53.5K1