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()].
--
David Biddulph

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


"Barb Reinhardt" wrote:

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(A11,A1,NA())

This was an OLLLD message.

" wrote:

How do you return the formula NA()

"Barb R." wrote:

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

"Stephan" wrote:

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