• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1518
  • Last Modified:

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

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
0
cations
Asked:
cations
  • 2
1 Solution
 
cationsAuthor Commented:
No Solutions??
0
 
cationsAuthor Commented:
  chartObj.SeriesCollection(1).Trendlines.Add Type:=xlLinear
0
 
Computer101Commented:
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now