![]() |
Excel plotting graphs
How can I plot two sets of data on the same axis, and then add a trend line
to each set of data separately. |
Excel plotting graphs
"Qmm" wrote in message ... How can I plot two sets of data on the same axis, and then add a trend line to each set of data separately. |
Excel plotting graphs
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Qmm" wrote in message ... How can I plot two sets of data on the same axis, and then add a trend line to each set of data separately. |
All times are GMT +1. The time now is 04:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com