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

  • Thread starter Thread starter NoRm
  • Start date Start date
N

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
 
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
 
Back
Top