ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Excel plotting graphs (https://www.excelbanter.com/charts-charting-excel/180507-excel-plotting-graphs.html)

Qmm

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.

Jon Peltier

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.




Jon Peltier

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