Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I want to figure out have excel take an equation for a trendline out of a
chart and paste it into a set of cells to calculate new values. For example I have data at time 100, 200, 300 and 500, but want to automatically have the equation of the trendline fitting my data copy over to a set of cells where the intermadiate data for time 25,50,75 etc will be calculated. I typically fit a polonomial trendline? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Polynomial, non-linear, Trendline Coefficients
and Regression Analysis http://www.tushar-mehta.com/excel/ti...efficients.htm http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Kmartin" wrote in message ... I want to figure out have excel take an equation for a trendline out of a chart and paste it into a set of cells to calculate new values. For example I have data at time 100, 200, 300 and 500, but want to automatically have the equation of the trendline fitting my data copy over to a set of cells where the intermadiate data for time 25,50,75 etc will be calculated. I typically fit a polonomial trendline? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to link trendline equation in graph to cell? | Excel Discussion (Misc queries) | |||
trendline equation | Charts and Charting in Excel | |||
Trendline Equation | Excel Worksheet Functions | |||
Rounding in Trendline Equation | Charts and Charting in Excel | |||
Logarithmic Trendline Equation | Charts and Charting in Excel |