Hi,

If you have chart sheets you can change the name by simply changing the
sheet tab name.

What you described is the method used on chartobjects, which are usually on
a worksheet.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"BoRed79" wrote in message
...
Hi.

I have a series of charts (which are all contained on their own sheets).

I need to name each of the charts (as they will be used by someone else in
a
macro).

I have tried clicking on them and also pressing shift before clicking on
them, and I am not able to change the name in the name combo box.

Can anyone advise me of how I can change the names.

Thanks for your help.