Trend Line Behind Data?

  • Thread starter Thread starter Richard Wood
  • Start date Start date
R

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
 
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,

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