Regression
 

Question:
I have 2 dataseries in a XY Scatter Chart. I want a one (common) regression
line for both series, not one for each series. Is that possible?

Regression
 

Prba wrote on Fri, 24 Feb 2006 07:37:27 -0800:

P Question:
P I have 2 dataseries in a XY Scatter Chart. I want a one
P (common) regression line for both series, not one for each
P series. Is that possible?

I wonder why you would want that? Why not just combine the two
sets of data when calculating the regression or plotting a trend
line? If you really want the two separate series to be plotted
and not the combined one, you might use a background color for
the combination after adding the trendline.

James Silverton.

Regression
 

In article ,
says...
Question:
I have 2 dataseries in a XY Scatter Chart. I want a one (common) regression
line for both series, not one for each series. Is that possible?

Also check the response to your 2nd post on the subject 2 minutes(!) after
this one.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions