POLYNOMIAL TRENDLINE

[IANGRAND]

I have the following code to add a trendline to a graph in Microsoft Access.

Dim GraphObj As Object
Set GraphObj = Me![Graph45].Object.Application.Chart
GraphObj.SeriesCollection(1).TrendLines.Add
GraphObj.SeriesCollection(1).TrendLines(1).Type = 1


However i require a polynomial trendline. Does anyone have anycode to create the trendline

Cheers

Ian

 

[dyarwood]

Try
GraphObj.SeriesCollection(1).TrendLines(1).Type = xlPolynomial

xlLinear give linear
xlMovingAvg give moving average

dyarwood

 

[IANGRAND]

No joy im afraid, using the code causes the following error:

Unable to set the type property of the Trendline Class

 

[duncansancho]

Try this with your setting as required, beginning at Trendlines as above

Trendlines.Add(Type:=xlPolynomial, Order:=2 _
, Forward:=0, Backward:=0

Duncan