Excel Line Chart don't chart blanks

[@mikedunn6266]

Awesome, i have spent all afternoon looking for a solution, found heaps of info but not a fix that has worked. You have a great explaination, very clean and hit the nail on the head. Thanks

[@Tonester666101]

Within 2 minutes, you told me what I needed to know. Thank you.

[@WalaaMaher]

Simple and Perfect solution!!.. 2019 and still this is the most simple one\

[@aylee71]

This works for scatter plots too...exactly the help I was looking for.

[@realsugeknight]

I second Andrew's question! If my data source for my x axis gets to a blank (for items to be filled in at a later date) how can I make it so that the chart doesn't come out wider on the x axis than necessary?

[@srinivasank7334]

Excellent solution and very easy to adopt. Great.

[@travellerla0814]

This doesn't work if you also have a sum function. The NA() in the formula results in an addition error for the blank cells. Plus whiting the font is a a workaround. Does Excel not have a true function to not graph "" or zeros?

[@paulmcd5454]

Very Very good way to explain this gradually. Many thanks P

[@cardguys]

This isn't solving the problem. You might as well just turn the line values transparent. How do you have the chart only reflect what is present in the table and suppress the remainder? I can do it in VBA, but it is a huge headache.

Worked for my situation. Thank you.

[@mokdekd]

very useful. you are great. Thank you

[@edamerdna]

Thank you, solved my problem....

[@philrichardson2654]

Great info - It Works and that's great

[@mohdalamri4]

Thanks A LOT, it worked

[@ghostwhowalks5623]

very interesting. For some reason, it doesn't work on a combo/stacked area and line chart. Going manual for now...

[@Robert-rd3ik]

Thank you!