Scatterplot with a best-fit line

How do i create one scatterplot with three separate data sets and a best-fit 
line to go with each set?
0
neally (2)
4/15/2007 11:32:01 PM
excel.charting 18370 articles. 0 followers. Follow

1 Replies
691 Views

Similar Articles

[PageSpeed] 19

Make an XY chart with the first set of X-Y values. Copy the second set of 
X-Y values, select the chart and use Edit menu > Paste Special, and add the 
data as a new series, categories in first column (row). Repeat for the third 
set of X-Y values. Add the trendline to each series by selecting the series, 
right clicking, and choosing Add Trendline.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"neally" <neally@discussions.microsoft.com> wrote in message 
news:FD474153-9F91-4AF4-9CFE-6F1DEA4D946E@microsoft.com...
> How do i create one scatterplot with three separate data sets and a 
> best-fit
> line to go with each set? 


0
jonxlmvpNO (4558)
4/16/2007 12:50:57 AM
Reply:

Similar Artilces: