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.
 
This worked great, but is it possible to not show the #N/A in the data table?
 
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()].
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I hide 0 values in line charts 2
Pie charts - 0 values 2
how to hide zero values on line chart 2
Line Chart 1
Plot value at top of chart 1
How to End Chart Line If Data Source Has a Blank? 1
Hiding zeros in dynamic charts 3
How do you not include 0 value data on a graph? 1

Back
Top