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
|
|||
|
|||
One regression line
Hi,
I have two series but I want one (common) regression line for both, not one for each. Is that possible? |
#2
|
|||
|
|||
One regression line
Hi,
In two helper columns, copy the x- and y- data of the first data-set; now copy the second data-set and paste it below the first data-set in those helper columns. Make an xy-scatter plot for the combined data (helper columns) and obtain the trendline. If you prefer to have the two sets plotted as separate series, maybe for other purposes, format Series 1 (the combined series) with "None" for "Line" and "None" for "Marker" (This action would hide the data-points in the combined plot), and add two more series using the original data. Regards, B. R. Ramachandran "Prba" wrote: Hi, I have two series but I want one (common) regression line for both, not one for each. Is that possible? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Line Spacing - Last line in Paragraph | BJSmithCO | Publisher | 13 | December 4th, 2008 04:52 PM |
Line color and style | dbragg | Powerpoint | 2 | June 29th, 2005 09:21 PM |
Line Numbering... (Cannot GoTo)!? | Jeffrey A. Voigt | Page Layout | 0 | July 30th, 2004 07:24 PM |
Outlook 2003: annoying line wrap when quoting | Tony Gravagno | General Discussion | 10 | July 18th, 2004 12:17 AM |
Discontinue part of line in chart | Jon Peltier | Charts and Charting | 0 | April 1st, 2004 10:27 PM |