Skip Dates in Excel Charts (ignore gaps and blank cells)

[@LeilaGharani]

Grab the file I used in the video from here 👉 pages.xelplus.com/remove-gaps-in-charts-file

[@excelisfun]

Thanks for the Filter Fun!

[@LeilaGharani]

:) You'r welcome Mike.

[@elancelian1668]

Very much thank you. Helped me alot. And i improved alot by ur videos.

[@chiarabertelli5940]

Brilliant, fix to an issue I couldn't find anywhere else. Thanks!

[@21121990jay]

Thanks Leila for sharing ! help a lot !

[@akgoyal2402]

I am looking for a chart that shows daily progress.
Today’s date is 06/06/20, I want the chart where it shows production progress from 1/6/20 to 30/6/20. But line chart data should be only upto 6/6/20 and all other dates after 6/6/20 should remain blank unless data is updated.
( just like Sensex day chart from morning to evening )
On other hand,
How to make Multiple line charts of months, with just date numbers on x axis ( 1, 2, 3, 4 and so on) and production trend compared to past months on plot area.
You have been a great teacher.

[@PrishaAggarwal]

very useful, thanks

[@rundhamadeh1497]

exactly what I needed .. thank you!!

[@LeilaGharani]

You're welcome!

[@oodlesofArt24]

Thank you! This helped a lot.

[@scottcampbell4622]

As ever, a quick solution from Leila, thanks. :)

[@نضالالبرديني]

It is possible to give the blanks a specific color on the curve without making a filter
Thank you

[@robertakwasiadjei8223]

Great video Leila. Stay blessed.

[@LeilaGharani]

Thank you Robert. Glad you like it.

[@ashishrnjn30]

thanx buddy .. it totally works.

[@devendrabartwal1876]

It will help me a lot
Thanks a ton❤️

[@LeilaGharani]

Great! You're very welcome.

[@hosseinhosseinpoor4845]

thanks thanks

[@mohamedchakroun4973]

Very Nice leilouna waiting for dynamic solution

[@LeilaGharani]

Thanks :) stay tuned....

[@alexrosen8762]

Great tip! Thanks for sharing Leila😊

[@LeilaGharani]

You're welcome Alex.

[@Dev_Bartwal]

Thanks a ton Leila❤️

[@LeilaGharani]

You're welcome Dev.

[@RahulKumar-ly6ly]

Thanks mam

[@clydonmicallef3509]

Your videos are very well explained and informative. Thanks a lot! #Malta :)

[@LeilaGharani]

Glad you like them!

[@angelasohn9513]

This is great, but is there a way for the table to automatically refilter when you add data, including when you add it to the blank spaces?

[@LeilaGharani]

You actually have to refresh the filter - or use VBA to refresh automatically when data's changed using the sheet change event procedure. For VBA free method, this video will help: ruclips.net/video/T8P8xMBkH4I/видео.html

[@rrrprogram8667]

Good one .. thanks

[@LeilaGharani]

You're welcome.

[@ashu76mac]

hi, how can i ignore error (auto date or cell # 44032 etc), while copying date from other cell?

[@leahrae6132]

When I change to text from date it puts the dates as 44850 etc. how do you stop this from happening?

[@robertojunqueira]

good !

[@Sal_A]

Tashakar! Very Helpful.

[@LeilaGharani]

You're welcome Sal.

[@rajyalakshmidasari3706]

How to ignore scatter chart gaps and zero

[@donnieraylim2382]

informative

[@junesu3741]

cannot function if more data

[@ReverendHogwash]

No, first of all, how were those dates on your chart if those dates didnt exist in the dataset? What if you eliminate those blank rows in your dataset?

[@muhaiminmahfudzjauhar]

leila ghaharani: how to delete permanent empty rows together

[@jameszack7158]

You are talking so soft and smooth. I want a wife like you ❤️

[@robertprehn3765]

Super helpful, thank you!

[@donnieraylim2382]

informative

[@LeilaGharani]

You're welcome Donnie.