Calculating average of a variable array
Posted by brian charles on October 18, 1999 8:36 AM
I would like to have a horizontal line drawn
on a scatter graph that represents the average
of all values.
I figured that I could do it if I create a second
series with all values equal to the average. I am
having trouble because the initial set of values that
is averaged, is variable. Thus, when creating the
formula: Average(RC[-1]:R["?"]C[-1]), I don't know what
to replace my "?" with.