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