Single trendline for multiple series

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a chart with 2 different series of data graphed. I would like to have
1 single trendline for both of the series. Is there a way to do this?
Thanks.

-Mark
 
MAWII said:
I have a chart with 2 different series of data graphed. I would like to have
1 single trendline for both of the series. Is there a way to do this?
Thanks.

-Mark
Click to expand...


Personally, I'd combine the data sets into a single one in a third
helper column. You can then plot that and put a trendline through it.
By judiciously picking colors and such you won't see the third data set
on the plot -- just the first two and the trendline.

Good luck...

Bill
 
Back
Top