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 '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.

← Excel for Mac. Trend line to cell. Function that references a chart and gives trendline parameters. Vote Vote Vote. Your email address. Invalid email. Hello, I am looking to add a linear trend line in my report. I am trying to replicate the linear trend line from excel. The calculated field option like running total, etc isnt getting what we need.

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 '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.

Pixel xl drivers. 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. How to retrieve deleted pictures from samsung galaxy note 4 for mac. 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 '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.