Scatterplot with a best-fit line

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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