| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Capturing 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"? -- Lon Sarnoff |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Capturing trendline parameters
For my enhancements to Dave Braden's code:
http://groups.google.com/group/micro.../msg/0eda30f29 434786d?hl=en& To get the results directly in a worksheet: Trendline Coefficients and Regression Analysis http://www.tushar-mehta.com/excel/ti...efficients.htm -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... 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"? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Capturing trendline parameters
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. -- Lon Sarnoff "Tushar Mehta" wrote: For my enhancements to Dave Braden's code: http://groups.google.com/group/micro.../msg/0eda30f29 434786d?hl=en& To get the results directly in a worksheet: Trendline Coefficients and Regression Analysis http://www.tushar-mehta.com/excel/ti...efficients.htm -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... 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"? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Capturing trendline parameters
You are welcome. Glad to be of help.
-- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| capturing all of the data | Excel Worksheet Functions | |||
| Capturing Date | New Users to Excel | |||
| Capturing deletion of a row | Excel Programming | |||
| Capturing an Error | Excel Programming | |||
| Capturing user name | Excel Programming | |||
Linear Mode
