Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlPolynomial trendline
Mitch -
The usual "trick" is to turn on the macro recorder and go through the steps of adding the cubic trendline. In Excel 2003, it works for me, yielding Order:=3 in addition to your current code. - Mike http://www.mikemiddleton.com "Mitch" wrote in message ... I am trying to create a cubic trendline (e.g. x^3 +x^2+x+1) in a chart using VBA. I can create a quadratic trendline (e.g. x^2+x+1) using "ActiveChart.SeriesCollection(1).Trendlines.Ad d Type:=xlPolynomial". I haven't been able to find how to create the cubic trendline. Does anyone know the trick? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trendline | Charts and Charting in Excel | |||
Trendline | Excel Worksheet Functions | |||
Add value of a trendline | Charts and Charting in Excel | |||
Trendline | Excel Worksheet Functions | |||
Trendline | Excel Discussion (Misc queries) |