View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mitch Mitch is offline
external usenet poster
 
Posts: 88
Default 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?