Macro - Chart name

[bv182]

Please someone help me with this.

I have moved around 10 charts from 10 different sheets to a new sheet using move charts function available in 2007.

Now all these charts have the same name. Most of them have a name called "Chart 1". I tried to change the name of the chart by entering a different name in a name box at the top. But it's not working - it's not changing the name.

I want to create one list box per chart which will make specific changes through macro in the specific chart as soon as the list box is edited. But without sorting out the name issue I am unable to use this macro.

Thanks very much.

 

[ADAMC]

I think you may be changing the chart title which isnt the same as the chart name........

what version of excel are you using?

 

[bv182]

I am using excel 2007.

I tried to change the name by entering a different name at the top ( just left of function tab) after selecting a chart.

I also tried changing it through macro by writing selectchart.name="newname" after selecting the chart. but it returned an error (Run time error '7': Out of memory)

Thanks.

 

[ADAMC]

Not sure what you mean by left of the function tab but heres what I would do in excel 2007 if it doesnt help please post back.

Select the chart
Choose Layout group under chart tools ribbon,
Click in the Chart Name box (far right under properties)
and
3. Type new name and press Enter

 

[bv182]

Great. It worked.
Yes I was doing something else.
Thanks very much for your help.

Not sure what you mean by left of the function tab but heres what I would do in excel 2007 if it doesnt help please post back.

Select the chart
Choose Layout group under chart tools ribbon,
Click in the Chart Name box (far right under properties)
and
3. Type new name and press Enter

 

[ADAMC]

Your welcome.

P.S you were close withj your VBA attempt to rename the chart however if the chart is embedded (I assume it must be) you need to rename the object rather than the chart itself like this:

ActiveChart.Parent.Name = "blahblahblah"

or it can be done like this:

ActiveSheet.Shapes(1).name = "blahblahblah"

 

[bv182]

Thanks ADAMC. Quite useful.

Your welcome.

P.S you were close withj your VBA attempt to rename the chart however if the chart is embedded (I assume it must be) you need to rename the object rather than the chart itself like this:

ActiveChart.Parent.Name = "blahblahblah"

or it can be done like this:

ActiveSheet.Shapes(1).name = "blahblahblah"