Trend Line Behind Data?

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" <RichardWood@discussions.microsoft.com> wrote in message
news:97B9F4A4-0C98-4CA0-A9C1-E6FD91EACE21@microsoft.com...
> 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" <RichardWood@discussions.microsoft.com> wrote in message
> news:97B9F4A4-0C98-4CA0-A9C1-E6FD91EACE21@microsoft.com...
> > 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" <RichardWood@discussions.microsoft.com> wrote in message
news:BD6A0D00-9B16-4F21-90D5-DB8AFC5DC935@microsoft.com...
> 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" <RichardWood@discussions.microsoft.com> wrote in message
>> news:97B9F4A4-0C98-4CA0-A9C1-E6FD91EACE21@microsoft.com...
>> > 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_tra...analysis/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" <RichardWood@discussions.microsoft.com> wrote in message
>>news:97B9F4A4-0C98-4CA0-A9C1-E6FD91EACE21@microsoft.com...
>>
>>>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 here:

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

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



"Richard Wood" <RichardWood@discussions.microsoft.com> wrote in message
news:BD6A0D00-9B16-4F21-90D5-DB8AFC5DC935@microsoft.com...
> 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" <RichardWood@discussions.microsoft.com> wrote in message
>> news:97B9F4A4-0C98-4CA0-A9C1-E6FD91EACE21@microsoft.com...
>> > 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" <RichardWood@discussions.microsoft.com> wrote in message
news:97B9F4A4-0C98-4CA0-A9C1-E6FD91EACE21@microsoft.com...
> 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
>