Graphing question.

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

Guest

I'm having data values print on my graph, but I don't want the zero's to print. I've created a formula in the spreadshee to return a blank value, but the 0's still print on the graph. Any help is appreciated
Thanks.
 
Instead of an empty string, you can use the NA() function in your formulas:

=IF(B2=0,NA(),B2)
 
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

Graphing 0 values from blank cells 7
Line Graph Excluding 0 Values 6
graphing data only in a certain range 2
How to Remove text values from graphs 8
Can blank cells be omitted from graph? 7
Scale of Graph Axis 2
Print Macro 5
Unwanted Series Values on Line Graph 2

Back
Top