xlPolynomial trendline

M

Mitch

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.Add Type:=xlPolynomial". I
haven't been able to find how to create the cubic trendline. Does anyone
know the trick?
 

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
Trendline Showing Problem ? 3
8th Order Polynomial Trend - Is there an easy way? 0
Sr. Citizen Question On Adding A Trendline, Please ? 1
Trendline Question 0
Help with area under trendline 0
Help on adding the second trendline in a "lines on 2 axes" Chart via VBA 1
Regression through select points on a scatter plot. 3

Top