Chart naming - vba

[shodan]

Dear board members,

I have created a sheet with a chart, and than copied that chart again to use as a base and changed it afterwards.

However, I see now that both charts have the same name and I don't seem to be able to change this name. Anybody knows how I should do this. They are now both called chart 1.

I tried these two thing:

Selecting the chart and change the name in the place where you see its name (there where you see the defined ranges name)

and I also tried to use following code after selecting the chart:
'ActiveChart.Name = "Chart Plant"

Neither of them worked for me so I must be doing something wrong.

thanks for helping

 

[VoG]

Try like this

Sub NameChart()
ActiveSheet.ChartObjects(ActiveSheet.ChartObjects.Count).Name = "Chart Plant"
End Sub

 

[shodan]

hey VOG

that did the trick. Thanks a lot. Now there is just one thing. The name had in there was the name for my first chart but it renamed my second chart. Not that is really a big deal but i can be confusing.

now i was trying to get it changed by this

ActiveWorkbook.Charts("Chart Plant").Name = "Chart_Bevs"

but this also doesnt work. what is wrong here than?

 

[Jon Peltier]

Select the chart you want to rename, and run this:

ActiveChart.Parent.Name = "New Name"