ExcelBanter - xlPolynomial trendline

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - xlPolynomial trendline (https://www.excelbanter.com/excel-programming/380976-xlpolynomial-trendline.html)

Mitch

xlPolynomial trendline

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?

All times are GMT +1. The time now is 08:15 PM.