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

AWESOME, THANK YOU.

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

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.

Thank you!

GOD BLESS U !!!

how to do this in google sheets?

Thank you!

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

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

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.