|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 24th, 2006, 03:37 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
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? 
|
|
#2
February 24th, 2006, 04:11 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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.
|
|
#3
February 24th, 2006, 11:13 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I perform multiple regression in Excel using two independe | Freda | Worksheet Functions | 2 | November 29th, 2005 04:59 PM |
| regression | swissforestry | Worksheet Functions | 1 | November 10th, 2005 11:59 PM |
| Regression analysis excel 2002 | TRS | Charts and Charting | 4 | October 1st, 2004 11:38 PM |
| Difference between regression in VBA and a worksheet function | Nick M | Worksheet Functions | 1 | April 6th, 2004 06:08 PM |
| Pooled regression and dummy variables | Kev Summersgill | Worksheet Functions | 1 | September 17th, 2003 09:16 PM |
Linear Mode
