ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to add a regression line to an XY scatter plot (https://www.excelbanter.com/excel-discussion-misc-queries/145231-how-add-regression-line-xy-scatter-plot.html)

Tim

How to add a regression line to an XY scatter plot
 
I've tried everything I can think of. This is actually quite simple in Sigma
Plot and Cricket Graph but I can't seem to find a way to do this in Excel.
Could someone please direct me in how to add a simple regression line to an
existing XY scatter plot?

Thank you.

David Biddulph[_2_]

How to add a regression line to an XY scatter plot
 
In the chart, use the chart menu/ Add Trendline.
--
David Biddulph

"Tim" wrote in message
...
I've tried everything I can think of. This is actually quite simple in
Sigma
Plot and Cricket Graph but I can't seem to find a way to do this in Excel.
Could someone please direct me in how to add a simple regression line to
an
existing XY scatter plot?

Thank you.




Jon Peltier

How to add a regression line to an XY scatter plot
 
Also right click on the series, and use Add Trendline from the pop up menu.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
In the chart, use the chart menu/ Add Trendline.
--
David Biddulph

"Tim" wrote in message
...
I've tried everything I can think of. This is actually quite simple in
Sigma
Plot and Cricket Graph but I can't seem to find a way to do this in
Excel.
Could someone please direct me in how to add a simple regression line to
an
existing XY scatter plot?

Thank you.







All times are GMT +1. The time now is 10:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com