Excel plotting graphs

  • Thread starter Thread starter Qmm
  • Start date Start date
Q

Qmm

How can I plot two sets of data on the same axis, and then add a trend line
to each set of data separately.
 
Make your chart with one set of XY data. Copy the second set of XY data,
select the chart, and use Edit menu > Paste Special to add the data as a new
series with the category (X) values in the first column. Right click the
first series and choose Add Trendline. Right click the second series and
choose 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

Mixing scatter plot with a category plot 2
2nd axis plotting incorrectly - is there a chart size limit? 2
Co-ordinates plotting on Graph //sk 1
adding trendline to plots from multiple series 1
Charting scientific data - Excel 2003 5
Excel 2007: Line where a gap should be, but only when plotting on ahorizontal date axis 2
Plotting Y vs. X data in Excel 3
Excel Graph Problem - Need Help 2

Back
Top