Labeling graphs using VBA

[JJKNowles]

I have a Excel Template that has 15 graphs on one page and 6 graphs on the next. Every time a technician uses the spread sheet they have to fill out all 21 graphs. To save time I wrote a macro that fills out the graph titles for them. The only problem is that each graph title has something different. So I had to ativate the graph by it's individual name. eg... "chart 1, chart 2..." and so on. Can these names change so that what was labeled chart 2 may be called chart 5 some other day? Or is this a secure method?
Thanks for your time,
JJ

 

[AussieRob]

Try this:

Sub Test()

Sheets(4).Activate

For a = 0 to n

ActiveSheet.ChartObjects(a).Activate
ActiveChart.ChartArea.Select

[add the code to change the name here]

next a

End Sub

This will allow you to select each graph in order.

 

[JJKNowles]

That's what I did. My only question is will chart 5 stay chart 5 every time we open the template. If chart 5 becomes chart 7 another time then the title assigned to it will be wronge.