How do I hide 0 values in line charts

[Stephan]

I have several columns with data. In one column I do not have data for every
row. In the line charts, those "zero" values are plotted and connected with
the previous data point. Instead I would rather have a broken line. The
reason seems that I have a formula entered in this field instead on no entry

 

[lmossolle]

How do you return the formula NA()

Have the formula return NA() instead of "".

 

[Barb Reinhardt]

Let's say you have an if statement and you only want values greater than one
to be plotted on your graph, use this type of equation

=if(A1>1,A1,NA())

This was an OLLLD message.

 

[MCC]

This worked great, but is it possible to not show the #N/A in the data table?

 

[David Biddulph]

Use conditional formatting to turn the #N/A white.
Otherwise you could produce one table (hidden, if you like) to plot from,
and a different table to look at [with "" instead of NA()].