G geooil Nov 16, 2004 #1 Is there anyway I can create a trendline that incorporates thre different sets of data on the same graph? :
Is there anyway I can create a trendline that incorporates thre different sets of data on the same graph? :
A Andy Pope Nov 16, 2004 #2 Hi, You would need to add an extra data series that incorporated all 3 sets of data. You could then add a trendline to this single data series. The additional data series can be formatted, no pattern or border, so it does not appear on the chart. Cheers Andy
Hi, You would need to add an extra data series that incorporated all 3 sets of data. You could then add a trendline to this single data series. The additional data series can be formatted, no pattern or border, so it does not appear on the chart. Cheers Andy
J Jerry W. Lewis Nov 16, 2004 #3 Or calculate the trendline in a worksheet and plot the trendline as a separate series. Jerry
