Access 2007 Chart - Series Titles

[kdbailey]

I'm trying to figure out through VBA how to identify the series title of a series on a chart on my form. If I find the right title, I'm trying to change the chart type. Apparently access defaults to alphabetically organizing the table field in which the chart is referring to as the series.

I cannot find the property in which the title of the seriescollection lies. Obviously there are other ways around this, however I'd like to know if there is an easy way to find it.

srstitle = "thisone"
For Each srs In screen.activeform.graph1.seriescollection
   If srs.name = srstitle Then
       'Other code
   End If
Next srs

Anybody know the correct syntax?

[AccessPower]

Note sure, but maybe this will work:

Dim srsTitle = "thisone"
For i = 1 to screen.activeform.graph1.SeriesCollection.Count
If screen.activeform.graph1.SeriesCollection(i).name = srsTitle Then
'Code
End if
Next

This is untested.

[kdbailey]

Unfortunately, that's basically the same code.

[aytee111]

See here to show all properties: https://msdn.microsoft.com/en-us/lib.../ff192897.aspx

[kdbailey]

The sub provided gives me properties of the chart, however it does not supply properties of the specific series within the chart. I tried applying the same logic to the chart.seriescollection(x).properties and it gave me an error.