Thread: best fit line
View Single Post
  #2   Report Post  
Nuraq
 
Posts: n/a
Default

You cannot fit a trendline for more than one series... each series can have
its own. Your best bet is to put all your data into one series and then
draw an XY scatter plot to which you add the trendline.

"jeremy via OfficeKB.com" wrote in message
...
I have a line graph with 6 series plotted (I.e. 6 different lines--sales on
y,

months of x). How do i add a best fit line to the chart? When i select
Add
Treanline, it only lets you select one series (and I'm assuming the result
you get is a linear y=mx+b line....i 'm looking for the best fit line for
serveral series...
Thanks.
jeremy

--
Message posted via http://www.officekb.com