How do i show a line of best fit in a scatter plot in excel?
 

How do i show a line of best fit in a scatter plot in excel?
 

Chart menu Add Trendline

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



"ShelbySenior07" wrote in message
...

How do i show a line of best fit in a scatter plot in excel?
 

Hello

Does EXCEL automatically generate the equation of the line?

Barry Mayers


--
bmayers
------------------------------------------------------------------------
bmayers's Profile: http://www.excelforum.com/member.php...o&userid=35753
View this thread: http://www.excelforum.com/showthread...hreadid=551905

How do i show a line of best fit in a scatter plot in excel?
 

Yes. You can double click on the fitted line to set options which include
how the equation will be displayed.

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


"bmayers" wrote in
message ...

Hello

Does EXCEL automatically generate the equation of the line?

Barry Mayers


--
bmayers
------------------------------------------------------------------------
bmayers's Profile:
http://www.excelforum.com/member.php...o&userid=35753
View this thread: http://www.excelforum.com/showthread...hreadid=551905