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

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,

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

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

"Richard Wood" wrote in message
...
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

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

Richard Wood -

John Walkenbach shows worksheet functions for all trendline equations he

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

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



"Richard Wood" wrote in message
...
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

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


"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