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?

Scatterplot with a best-fit line
 

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" wrote in message
...
How do i create one scatterplot with three separate data sets and a
best-fit
line to go with each set?