Not sure which ones you have seen or not.

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

Cheers
Andy

Richard Wood wrote:
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

"Andy Pope" wrote:


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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Richard Wood" wrote in message
...

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, Microsoft MVP - Excel
http://www.andypope.info