Line graphs dropping to 0 at the end of of chart - data is pulled from other spreadsheet

[jglenn1996]

I have a line graph where the data is continuously populated from data from another spreadsheet as it comes in.
An example of the formula I am using is =+'683 LWN'!F7

What formula would I use to make these cells disregard the zeros that are at the end of the data set (disregard the zero in July - that is intentional)

 

[Misca]

Welcome to the msg board!

Try replacing the zeros with NA() with something like

=IF(F7=0,NA(),F7)

This way the line breaks instead of dropping down.