Graphs

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
 
J

John-R W

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....
 

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 to Remove text values from graphs 4
conditional formating to keep the #N/A error from being visible 5
What is wrong with this formula? Please help! 3
Creating a named range gives an error only when the filename is lo 1
Changed data lables in graph from 0% to blank or N/A 0
setting a formula = to no point in a graph 3
Line Graph Excluding 0 Values 6
How do I list all Data in a column that fits between two points? 2

Top