since it is a line chart, there are several things you could try.
If it is justified, you could generate an average of the data points for
each x point and plot it. Make a trend line of the average then select the
average line and set line and symbol to none.

This is seldom accurate enough,
so you could also make a combined series of the data with the X location
duplicated as necessary. Do a slope and intercept calc on this data, Then
plot the data as your trend line.
"jeremy via OfficeKB.com" wrote:

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