8th Order Polynomial Trend - Is there an easy way?

  • Thread starter Frank & Pam Hayes
  • Start date
F

Frank & Pam Hayes

Excel can handle polynomial trendlines up to 6th order through the Add
Trendline command. I would like to be able to add a trendline up to the 8th
order. Google searches showed me how to compute this, but I am wondering if
there is an easier way. I tried using VBA :

ActiveChart.SeriesCollection(1).Select
ActiveChart.SeriesCollection(1).Trendlines.Add(Type:=xlPolynomial,
Order:=6 _
, Forward:=0, Backward:=0, DisplayEquation:=False, DisplayRSquared:=
_
False).Select

and then changing the Order:=8 but it would not work.

Any great ideas?

Thanks,

Frank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help on adding the second trendline in a "lines on 2 axes" Chart by using VBA 1
8th Order Polynomial Trendline - Is there an easy way? 19
Help on adding the second trendline in a "lines on 2 axes" Chart via VBA 1
Dynamic Range for a Chart & Trendline 0
how to select current range 4
Deleting SeriesCollections in charts 2
Why 2 legend entries? 2
Excel chart trendline problem with Office.Interop.Excel and C# .Ne 0

Top