Don't graph blanks

[Ed Needshelp]

Oh Gods of Excel please help me.

I want to use a line graph to chart the production of a given machine
but on the days it doesn't run, I don't want the zero productio
included as one of the data points.

I pull the summary data for the chart by using an "IF" statement tha
returns either the production for that day or a "" (blank) when it'
zero. I was hoping that it would treat the blank like an empty cell
but it treats it like a zero.

Is there anyway to get around this

 

[Frank Kabel]

Hi
instead of
""
return the value
NA()