Excel Graph - Ignore Blank Cells | Hide #N/A Values | Stop Line Graph Dropping to Zero

In this video I explain how to ignore the following when creating a chart in Excel:

1) Blank cells ( missing data )
2) Formulas that return the #N/A error
------------------------

[mikedear]

It took me several hours tinkering with formula data and even trying a pivot table to reach this answer! Thank you!

[TheHillsInTheUK]

Thanks, just what I was looking for. Thank you for the effort you put into making this video.

[ExtaTer]

Thanks. Finally was able to make Excel ignore the missing data and connect all the dots in the plot.

[Elsith]

How do you handle the exact same graph except you don't have October, November or December numbers. Is there a way to omit the last months from the graph entirely? So it will end at September? Without having to delete the last three months, because they could be future numbers.

[inisolation]

Thanks for the video, I use this #N/A method but I struggle to find a way to hide the "#N/A" in the table because it simply looks ugly, especially with large datasets. I have tried other formulas and conditional formatting but I just can not hide the "#N/A". Any ideas?

[gaikbee]

Hi, morning, really helpful, first time ever fall in love with #N/A

[nanwijanarko]

Concise and failproof. Thanks for adding another tool in my box!

[IvanCortinas_ES]

Thanks for this video. I was unaware of this functionality Chester. Great tutotial!!

[wayneedmondson]

Great chart tips Chester! Many thanks for sharing what you know. Thumbs up!!

[chetrshah]

I have a worksheet with many "#N/A" from different formulae spread across various cells. Is there anyway of globally making them blank or zero?

[FahedSalahat]

Hello Chester, I have a question if you don't mind!! I want to import data from excel sheet to another excel sheet using VBA button command, is that possible ?

For example I press the button on VBA sheet a pop up window asks me to select which sheet I want to import data from then select okay.

[UnknownChannel]

the "Connect data points" is not able to select? It is greyed out