Graphing In Excel

[Dan]

I need to know if there is a way for a graph to ignore a
formula if the formula returns a 0 or the " ". I am
using a formula that looks up a row of values. The
number of values in each row is different so I just
filled across to the max number I would ever need. Then
I graph the values together but for the smaller number of
values (the ones that return 0 or "") the graph treats
them as 0's and skews the traces. I am thinking there
has to be some symbol that can be put in to trick the
graph. Any help is appreciated.

Dan

 

[Andy Pope]

Hi Dan,

Try using the NA() function instead of ""

Cheers
Andy

 

[Dan]

Thanks Andy but that still doesn't work. Any other ideas?

Dan