Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can the displayed equation of a trendline be dynamic?
The equation of a parabola has been graphed and the equation displayed using
concatenate. The rate of change has been determined and graphed. To this graph a trendline is added. The trendline equation is displayed. Then the parabola is modified and the graph representing the rate of change adjusts. Unfortunately, the equation of the trendline doesn't change. How can the display equation of the trendline be displayed dynamicly? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can the displayed equation of a trendline be dynamic?
Not sure what you mean by "equation displayed using concatenate"
The coefficients for fitting a polynomial (including parabola) can be placed in cell with LINEST See equation displayed using LINEST See http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "CJ" wrote in message ... The equation of a parabola has been graphed and the equation displayed using concatenate. The rate of change has been determined and graphed. To this graph a trendline is added. The trendline equation is displayed. Then the parabola is modified and the graph representing the rate of change adjusts. Unfortunately, the equation of the trendline doesn't change. How can the display equation of the trendline be displayed dynamicly? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trendline equation calculation | Charts and Charting in Excel | |||
trendline equation | Charts and Charting in Excel | |||
Trendline Equation | Excel Worksheet Functions | |||
extracting the trendline equation | Charts and Charting in Excel | |||
Logarithmic Trendline Equation | Charts and Charting in Excel |