Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
ShelbySenior07
 
Posts: n/a
Default How do i show a line of best fit in a scatter plot in excel?


  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default 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
...



  #3   Report Post  
Posted to microsoft.public.excel.charting
bmayers
 
Posts: n/a
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
date in scatter chart excel 2003 dboudry Charts and Charting in Excel 1 March 16th 06 04:21 PM
Line chart or scatter chart?? rmellison Excel Discussion (Misc queries) 0 September 9th 05 10:31 AM
Can I copy x-y scatter plot data direct from one plot to another? Chris Charts and Charting in Excel 2 June 3rd 05 01:20 PM
Excel Scatter Plot with connected by smooth lines Rosa Campos Charts and Charting in Excel 1 February 9th 05 02:55 PM
BUG?: Excel scatter chart: will not plot x-values Bob Excel Discussion (Misc queries) 2 December 31st 04 12:19 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"