 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / January 2006Capturing trendline parameters
When a linear trendline is added to a chart, the linear equation which best fits the data can be displayed. It takes the traditional form of y=mx+b. Is there any way to programatically capture the values of "m" and "b"?  SignatureLon Sarnoff For my enhancements to Dave Braden's code: http://groups.google.com/group/microsoft.public.excel.charting/msg/0eda30f29 434786d?hl=en& To get the results directly in a worksheet: Trendline Coefficients and Regression Analysis http://www.tushar-mehta.com/excel/tips/trendline_coefficients.htm SignatureRegards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions > When a linear trendline is added to a chart, the linear equation which best > fits the data can be displayed. It takes the traditional form of y=mx+b. Is > there any way to programatically capture the values of "m" and "b"? Thank you for your instructive article. After I posted my inquiry, I realized that I had failed to find previous threads because of a spelling error. Since then I have also found the SLOPE and INTERCEPT functions which meet my immediate needs. SignatureLon Sarnoff > For my enhancements to Dave Braden's code: > http://groups.google.com/group/microsoft.public.excel.charting/msg/0eda30f29 [quoted text clipped - 7 lines] > > fits the data can be displayed. It takes the traditional form of y=mx+b. Is > > there any way to programatically capture the values of "m" and "b"? You are welcome. Glad to be of help. SignatureRegards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions > Thank you for your instructive article. > > After I posted my inquiry, I realized that I had failed to find previous > threads because of a spelling error. Since then I have also found the SLOPE > and INTERCEPT functions which meet my immediate needs. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.