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)
 
Back
Top