Trend lines in charts

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

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.