| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trendline Equations
Does anyone know how to extract the trendline formula from a chart
object so that the formula is viewable in a cell? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trendline Equations
ActiveSheet.ChartObjects("Chart 1").Activate Caption = ActiveChart.SeriesCollection(3).Trendlines(1). _ DataLabel.Caption ThisWorkbook.Activate Range("E122").Value = Caption " wrote: Does anyone know how to extract the trendline formula from a chart object so that the formula is viewable in a cell? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trendline Equations
Without getting into VBA you have to create the formula yourself. It is not
that terribly difficult using the slope and intercept formulas... -- HTH... Jim Thomlinson "Joel" wrote: ActiveSheet.ChartObjects("Chart 1").Activate Caption = ActiveChart.SeriesCollection(3).Trendlines(1). _ DataLabel.Caption ThisWorkbook.Activate Range("E122").Value = Caption " wrote: Does anyone know how to extract the trendline formula from a chart object so that the formula is viewable in a cell? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trendline Equations
On Feb 15, 3:04*pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote: Without getting into VBA you have to create the formula yourself. It is not that terribly difficult using the slope and intercept formulas... -- HTH... Jim Thomlinson "Joel" wrote: * * * * * * *ActiveSheet.ChartObjects("Chart 1").Activate * * * * * * *Caption = ActiveChart.SeriesCollection(3).Trendlines(1). _ * * * * * * *DataLabel.Caption * * * * * * *ThisWorkbook.Activate * * * * * * *Range("E122").Value = Caption " wrote: Does anyone know how to extract the trendline formula from a chart object so that the formula is viewable in a cell?- Hide quoted text - - Show quoted text - Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trendline Equations
You can also use LINEST to get the polynomial coefficients into cells.
Bernard Liengme shows how he http://www.stfx.ca/people/bliengme/ExcelTips David Braden wrote the first procedure I know of to extract trendline coefficients for use in the worksheet. Tushar Mehta made some refinements to the procedure here (see post 10): http://groups.google.com/group/micro...6b43d9dc84ebd/ In fact, Tushar has written a detailed chapter on the use of Excel with regression (including his trendline coefficient procedure): http://tushar-mehta.com/publish_trai...nalysis/16.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ... Does anyone know how to extract the trendline formula from a chart object so that the formula is viewable in a cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop moving trendline equations | Charts and Charting in Excel | |||
| Trendline Equations | Charts and Charting in Excel | |||
| Trendline Equations | Excel Discussion (Misc queries) | |||
| Trendline Equations | Charts and Charting in Excel | |||
| trendline equations | Charts and Charting in Excel | |||
Linear Mode
