Graph is Charting NA and " "

[jahnosha]

Hi All,

I checked a bunch of archived blogs on this and in 2001 people were set on the idea that excel won't chart NA errors. I have tried those and blanks, but the range I graphed consists of numbers and either of NA and blanks.

Problem is the graph is taking those values into account! other numeric values come and go as data is put in.

What am I doing wrong?

 

[jberwald]

Are you saying that NA() is being picked up by the graph? Is your graph reading from the column you input your data in, or do you have a seperate column, with formulas, to create your error codes?

 

[jahnosha]

Its doing both,

I programmed it to bring up an error code but also copy pasted values jsut to be sure and it still graphs everything in the table, numbers, blanks, NAs

 

[jberwald]

The column you have the formulas in - the formulas look something like this
=IF(H9=0,NA(),H9)

 

[jahnosha]

yes, and my chart has a ton of N/A values posted onto it under the label