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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you put a line of best fit on a graph? 1
adding data labels to an XY scatterplot 1
Scatterplots with different colors based on Type of Data 1
Scatterplot with 4 quadrants 2
Data Lables, series and Scatterplots 2
scatter plot with two colors 1
How do I add a curve of best fit? 1
Macro to create multiple charts? 2

Back
Top