Automate Graph Trend Lines

  • Thread starter Charles L. Phillips
  • Start date
C

Charles L. Phillips

Hello,
I am trying to reproduce:

How to Use Automation to Set Graph Trend Lines: http://support.microsoft.com/default.aspx?scid=kb;en-us;154581
I keep getting the following error:

"Identifier under cursor is not recognized"

I have highlighted the error section...

Function AddTrendLine()
Dim GraphObj As Object
Set GraphObj = Me![MyGraph].Object.Application.Chart
GraphObj.SeriesCollection(1).TrendLines.Add
GraphObj.SeriesCollection(1).TrendLines(1).Type = 3
End Function

Can/will someone tell what what I am doing wrong?

Thank You,
 

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

Set Trendline color 4
Error When Trying to Calculate R Squared With Only One Datapoint 4
unable to get the trendlines property of the series class 1
Trend lines on line graphs 5
Dynamic Range for a Chart & Trendline 0
Create Graphs using VBA 4
VBA Code to switch axis on in microsoft graph 0
Using the Excel Trend function in Access 3

Top