When you work with data in Excel. sometimes you may have some gaps due to unavailability of data or delays in data collection.
With such data gaps, it becomes difficult to plot it on Excel charts.
Fortunately, there are options in Excel that allow you to choose how to want Excel charting to treat such data gaps.
You can leave it as a gap in the chart, make the value of these gaps 0, or connect these with a line.
In this video, I will show you how to handle these data gaps in Excel Charts and select the best possible way to represent your data.
Read FULL Tutorial:
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Nice post sir thanks alot
plzz provide sample of these excel data for practice also.It ill be great help.
Thanks so much Sir, but what about having large gaps ….
I use live a live data feed into excel RTD and it all updates live but when I chart the data the chart does not update live, how would I make that happen? thanks
👍
really nice work you have awesome knowledge, ….. Thank you so much