Trendline Equations
 

Does anyone know how to extract the trendline formula from a chart
object so that the formula is viewable in a cell?

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?

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?

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

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?