Trend lines in charts

**Sebastian1942** · 01-17-2010, 07:48 AM

Can a Trend Line be confined to a range of data, rather than ALL the data in a chart ?

**zbor** · 01-17-2010, 07:52 AM

You can define (in your original data) wich data to be ploted (for example all above value =3) and then draw that line and create Trend Line.

**Sebastian1942** · 01-17-2010, 08:31 AM

It is encouraging to hear from you that it is possible. Now the HOW ?
My x-axis is Time. I'd like to see trend lines for values (in the y-axis), for just certain periods (on the x-axis). I have no idea where/how to begin with the defining that you specify.

**zbor** · 01-17-2010, 09:03 AM

Can you upload example?

**shg** · 01-17-2010, 06:52 PM

You would need to break the data into separate series, and add a trendline for each.

You know you can do a moving average trendline?

**Sebastian1942** · 01-18-2010, 02:19 AM

Originally Posted by shg

You would need to break the data into separate series, and add a trendline for each.

Can you tell me how that is done ?

<<You know you can do a moving average trendline?>> I saw such a beastie when I was looking through the HELP

**Sebastian1942** · 01-18-2010, 02:51 AM

Originally Posted by zbor

Can you upload example?

I will try. The last time I tried, I could not see any way to access what I had uploaded.
AS WELL AS THAT
In my attempt to simplify the chart [by deleting rows and columns and formulas], so as to send you only RELEVANT information, I'm confronted by a 'refusal' by the chart to accept the new data range for the old chart format. I'm quite puzzled by the format of the data range before modification, which shows THREE arguments ! namely =Sheet1!$N$6:$P$111,Sheet1!$N$113:$P$170,Sheet1!$N$172:$P$175
when I expected a reference ONLY to the data range in the column for the x-axis and a reference to the data range in the column for the y-axis.
So I will have to owe you an upload until this new problem is sorted out.