Trend Line Behind Data?

[Richard Wood]

Is there any way I can get the trend line to appear BEHIND the data line it
is trending? I have a chart which is very clear to see when there is a great
deal of varience in the data line (which unfortunatly is a bad condition) but
when the data is is a very stable state (good condition) the data line tends
to get lost behind the trend line and is not very visible.

I am using Excel 2002, just in case it is relevant

 

[Andy Pope]

Hi,

Looks like the trend line is drawn on the top layer of charting elements.

You could calculate the trend line using formula and plot it as a normal
series. Then you can change the plot order.

Cheers
Andy

 

[Richard Wood]

Andy,

Thanks for the reply. I had thought of that, but its a bit beyond my
understanding of Excel and chartsd to achieve it. I have seen in a number of
posts reference to the LINEST() function, however having played with it for a
little while I have to say I am none the wiser as how to use the result from
this function to plot a line, let alone one that matches the automatic trend
line.

Any help would be greatly appreciated

 

[David Biddulph]

Have you looked at the Excel Help info for the LINEST function ?

 

[Andy Pope]

Not sure which ones you have seen or not.

http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm
http://tushar-mehta.com/publish_train/data_analysis/16.htm

Cheers
Andy

 

[Mike Middleton]

Richard Wood -

John Walkenbach shows worksheet functions for all trendline equations here:

http://j-walk.com/ss///excel/tips/tip101.htm

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[Peter T]

A different approach. By default a Trendline is perhaps thicker than it need
be. Try formatting its weight to the thinnest available, or even try a
non-continuous line-style. Also try a less distinct colour or one that
obviously contrasts with the series line (which you could make thicker if
you want).

Regards,
Peter T