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

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

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

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

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

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