| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using numerical information from trendline equation
I would like to be able to grab the coefficients from an excel graph
trendline equation. Is this possible, the number seems to be available to copy and paste but I would like to be able to use it in a cell in the worksheet. If possible I would like to be able to have cells linked to the equations coefficients, Rsquared value, regression type, and if polynomial equation order. Thanks, Bryan H |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using numerical information from trendline equation
Tushar Mehta has enhanced VBA code by David Braden to extract
coefficients from the chart trendline. http://groups.google.com/group/micro...da30f29434786d You must format the displayed equation to display enough figures for the coefficients to be useable (I recommend scientific notation with 14 decimal places). Alternately, you can use LINEST to fit polynomials http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm Jerry "BryanDamon" wrote: I would like to be able to grab the coefficients from an excel graph trendline equation. Is this possible, the number seems to be available to copy and paste but I would like to be able to use it in a cell in the worksheet. If possible I would like to be able to have cells linked to the equations coefficients, Rsquared value, regression type, and if polynomial equation order. Thanks, Bryan H |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using numerical information from trendline equation
AWESOME!
Exactly what I needed, thanks Jerry! "Jerry W. Lewis" wrote: Tushar Mehta has enhanced VBA code by David Braden to extract coefficients from the chart trendline. http://groups.google.com/group/micro...da30f29434786d You must format the displayed equation to display enough figures for the coefficients to be useable (I recommend scientific notation with 14 decimal places). Alternately, you can use LINEST to fit polynomials http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm Jerry "BryanDamon" wrote: I would like to be able to grab the coefficients from an excel graph trendline equation. Is this possible, the number seems to be available to copy and paste but I would like to be able to use it in a cell in the worksheet. If possible I would like to be able to have cells linked to the equations coefficients, Rsquared value, regression type, and if polynomial equation order. Thanks, Bryan H |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| trendline equation | Charts and Charting in Excel | |||
| Trendline Equation | Excel Worksheet Functions | |||
| extracting the trendline equation | Charts and Charting in Excel | |||
| trendline equation extract | Charts and Charting in Excel | |||
| Logarithmic Trendline Equation | Charts and Charting in Excel | |||
Linear Mode
