Changing Series in Graphs via Excel VB

[deve8ore]

Hello... I have a number of graphs I receive from a 3rd party vendor, and within the graphs are charts indicating specific membership information.
I.e. - "Red Membership", "Blue Membership", "Green Membership", ect.... and the membership line could be anywhere in the chart (not just on the 2nd or 3rd line).

I'd like to run code to go through each datachart and if it includes the word "membership" to simply replace the series with "Total Membership".... regardless of the word preceeding 'membership' in the series.

The membership used to always be in the series 3 position, however now it can be anywhere.... so I need some sort of loop to go through each series and change it only if it has the word 'membership'. Here's what I had previously for changing the phrase in the 3rd series position:


ActiveChart.SeriesCollection(3).Name = "=""Total_Membership"""
ActiveWindow.Visible = True
If ws.Index <> 1 And ws.Index <> 2 Then ws.Select False
If ws.Index > 1 Then ws.Select True
Next ws

Hope this makes sense. Any help is appreciated!