Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Prba
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.charting
B. R.Ramachandran
 
Posts: n/a
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I put a regression line on a scatter chart Charles Hall Charts and Charting in Excel 2 February 14th 06 02:20 AM
Chart confidence intervals around regression (or trend) line LeAnne Charts and Charting in Excel 2 December 1st 05 05:53 PM
Graphing a logarithmic regression line Susiebusie Charts and Charting in Excel 3 November 18th 05 07:26 PM
creating a regression line in a graph sirsoto Charts and Charting in Excel 1 November 10th 05 02:20 AM
Perpendicular distance of a point from linear regression line? Winny Charts and Charting in Excel 4 September 25th 05 12:29 AM


All times are GMT +1. The time now is 10:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"