Multiple trend lines on one data series in excel

[shsajjad]

Hi all members

I am new member of MREXCEL.COM.
I have a data series A and B. A is years, and B is temperaure. A and B are from 1to 55 with no missing value.
I want to plot this time series and want to insert two trend lines on it .... first from 1 to 29 and second from 30 to 55.

I have tried a lot to do so but not succeeded. Can any body help me to tell me how to do it in Excel or R package....

thanks and regards

SAJJAD Hussain SAJJAD
Strasbourg, France
shsajjad@hotmail.com

 

[VoG]

You would need to plot those ranges as two series, then add a trendline to each.

 

[shsajjad]

You would need to plot those ranges as two series, then add a trendline to each.

This is not the answer of my question.
I have only one series (Years on X-axis, and Temperature on Y-axis)...
so I can only plot one series but want to insert two trend lines on it.
If some one help me to do so, I shall be thankful

regards

sajjad

 

[VoG]

Example file uploaded here http://www.box.net/shared/tytilodcuj

 

[Jameo]

Copy the data series. This will give you two plots lying on top of each other, add a trendline to each one.

 

[noni0285]

Check out this YouTube video: https://www.youtube.com/watch?v=dsJnsuoVfA8