Graphs

  • Thread starter Thread starter acw
  • Start date Start date
A

acw

John

Either remove the formula where there is no data and only
move across when there is data, or put in an if statement
so that if the number is 0, the NA() function is used. A
graph does not output for the #N/A error message

=IF(test, get value, NA())

Tony
 
Thanks Tony, I'll try that. I did put in a statement to not allow a 0 value,
but I guess it still didn't like that.

=IF('All Puppies'!B23="","",'All Puppies'!B23)

Making a growth/weight chart for our new puppies....
 
Back
Top