How do I hide 0 values in line charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

This was an OLLLD message.
 
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()].
 
Back
Top