trendline - how to fit a straight average??

[el Benno]

those microsoft muppets have included that trendline function which is
great.. but does anyone know how to customise your own trendling
function??

All I want to do at this stage is what many people I imagine might
want and whack a straight line accross the chart e.g. y = (Average of
all X series values or any other figure I want like a benchmarking or
quality target)

I'm creating it all on the fly from Access so manually adding a dummy
series and fitting a line to it etc. is a royal pain in the arse..

love to hear any ideas / best rgds / Ben

 

[Jerry W. Lewis]

One way is to add a new data series to the chart, where every point in
the new series has the value of the desired averagey.

Jerry