How to handle Data Gaps in Charts in Excel



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

5/5 - (1 bình chọn)

Bài viết liên quan

Theo dõi
Thông báo của
guest
6 Comments
Cũ nhất
Mới nhất Được bỏ phiếu nhiều nhất
Phản hồi nội tuyến
Xem tất cả bình luận
Ayah Adhi Channel

Nice post sir thanks alot

Anish Mehta

plzz provide sample of these excel data for practice also.It ill be great help.

Alaa Mosad

Thanks so much Sir, but what about having large gaps ….

Jack Lavoie

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

Ajay Anand

👍

Deepak Gauniyal

really nice work you have awesome knowledge, ….. Thank you so much