<div>
 &nbsp; chartObj.SeriesCollection(<wbr />1).Trendli<wbr />nes.Add Type:=xlLinear
</div>


<div>
<div class="content wysiwyg-content">
Hello Access Gurus<br />
<br />
I want to add a trend line to my graph programatically. &nbsp;This is how Excel does it but this syntax does not work in MS Access.... &nbsp;thank you so much. &nbsp;<br />
<br />
<br />
&nbsp;Set chartobj = ![AnalysisGraph].Object.Ap<wbr />plication.<wbr />Chart<br />
&nbsp;chartobj.SeriesCollection(<wbr />1).Select<br />
&nbsp;chartobj.SeriesCollection(<wbr />1).Trendli<wbr />nes.Add(Ty<wbr />pe:=xlLine<wbr />ar, Forward:=0, _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Backward:=0, DisplayEquation:=False, DisplayRSquared:=False).Se<wbr />lect<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; chartobj.SeriesCollection(<wbr />1).Trendli<wbr />nes(1).Sel<wbr />ect<br />
&nbsp;With Selection.Border<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .ColorIndex = 57<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .Weight = xlThin<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .LineStyle = xlDot<br />
End With
</div>
</div>


Hello Access Gurus

I want to add a trend line to my graph programatically.  This is how Excel does it but this syntax does not work in MS Access....  thank you so much.  


 Set chartobj = ![AnalysisGraph].Object.Application.Chart
 chartobj.SeriesCollection(1).Select
 chartobj.SeriesCollection(1).Trendlines.Add(Type:=xlLinear, Forward:=0, _
         Backward:=0, DisplayEquation:=False, DisplayRSquared:=False).Select
            chartobj.SeriesCollection(1).Trendlines(1).Select
 With Selection.Border
            .ColorIndex = 57
            .Weight = xlThin
            .LineStyle = xlDot
End With

   chartObj.SeriesCollection(1).Trendlines.Add Type:=xlLinear

Adding a Trend line to a Series in a Graph  in MS Access VBA

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.