Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
5th-odr poly coefficients automatically displayed in excel cells?
Would like to create 5th- order polynomial trendline from data set and have
coefficients automatically displayed in excel cells (one in each cell) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
5th-odr poly coefficients automatically displayed in excel cells?
Hi,
The following code adds a trendline (5th-order poly) to the first series on the active chart: '-------------------------------------------- Sub test() Dim c As Chart, t As Trendline Set c = ActiveChart 'check chart If c Is Nothing Then MsgBox "No chart selected" Exit Sub End If 'add trendline to series 1 Set t = c.SeriesCollection(1).Trendlines.Add(Type:=xlPolyn omial, _ Order:=5, Forward:=0, Backward:=0, DisplayEquation:=True, _ DisplayRSquared:=False) End Sub '------------------------------------------ -- Regards, Sébastien <http://www.ondemandanalysis.com "jason1" wrote: Would like to create 5th- order polynomial trendline from data set and have coefficients automatically displayed in excel cells (one in each cell) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
5th-odr poly coefficients automatically displayed in excel cells?
jason1 -
Would like to create 5th- order polynomial trendline from data set and have coefficients automatically displayed in excel cells (one in each cell) < (1) Do you actually think there is some real-world data where the underlying process should be represented with a 5th-order polynomial? Be aware of possible overfitting the data in which case predictions are of dubious value. (2) But if you really want to do it, you could use the LINEST array-entered worksheet function. Tushar Mehta has some examples and tutorials at www.tushar-mehta.com. - Mike www.mikemiddleton.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting Terms and Exponents of a Text Poly Formula ?? | Excel Worksheet Functions | |||
Excel: How automatically read coefficients from polynomial fit? | Charts and Charting in Excel | |||
How do I automatically change displayed sheet in excel? | Excel Discussion (Misc queries) | |||
I cannot display all the poly equation constants on the chart. | Charts and Charting in Excel | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel |