Is there anyway to move a trendline behind the data series?

[NoRm]

Hi,

I'm using XL2002 with Windows 2000. I have a chart that I added a
trendline to, but it obscures part of my data series, is there a way
to move it behind the data series? If so, how? I can't figure it out.

Thanks!

Norm

 

[Jon Peltier]

nOrM -

You can use a thinner line, which would cut down on the obscurity of the
data. Or you could get the parameters of the curve fit, either from
LINEST (see Bernard Liengme's site for assistance if needed), or by
extracting the coefficients from the trendline equation (see Dave
Braden's technique). Use these parameters to determine X-Y data for
your own homemade trendline, and plot this on your scatter chart as a
series with lines and no markers. These lines will fall behind the main
series' markers.

Bernard's page:
http://www.stfx.ca/people/bliengme/ExcelTips/Polynomial.htm

Dave's post:
http://www.google.com/groups?&[email protected]&rnum=1

- Jon