Excel plotting graphs

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.
 
J

Jon Peltier

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
 

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

Excel (2007) won't do a particular X-Y (Point) graph for me.. 9
2nd axis plotting incorrectly - is there a chart size limit? 2
Multiple Line Graphs 5
Major and minor gridlines on logarithmic axis excel 2007 7
Charting scientific data - Excel 2003 5
Plotting a current Date Vertical Line 1
Co-ordinates plotting on Graph //sk 1
Plotting against Date (collating months) 1

Top