How to change the name of the object Graph 1 in Excel ?

[rir]

I've done some Macros in VBA in the spanish version and some users with the
Engish version can't use them due to the name of the graphs.
I tried to change the name of the graphs (objects) but i cannot.
Any idea to solve the problem?
Thanks

 

[Andy Pope]

Hi,

Use something like this to change the name of the active chart object.

Activechart.parent.name = "MyChart"

For the 1st chart object on the sheet you could use the Index to reference
it.

Activesheet.chartobjects(1).Name = "MyChart"

If you still need help it would be useful if you could post the code you
currently use pointing out where it fails.

Cheers
Andy

 

[rir]

It didn't work. When I see the incrustated the window Graph it still appears
the old name (Gráfico 1). The macro works but it fails when one person using
the English version of excel because in this version the name is Graph 1
Cheers and thanks

 

[Andy Pope]

Both of my example code use other ways of referencing the chart object. The
name should not matter.

I agree that code like this would fail if the object was called "Gráfico 1".

Activesheet.chartobjects("Chart 1").name = "MyChart"

Cheers
Andy

 

[rir]

You're completely right!
It works
Thanks and cheers!
Ramon