Excel 2007 : Changing Chart Name

[michelle439731]

Afternoon,

I've got some charts on my worksheet that I am updating using vb code. I refer to each chart by their name: Chart 1, Chart 2 ect.
On one of my worksheets I've got 3 charts labeled Chart 5. Is there a way for me to rename the other two charts? I've tried renaming them in the range name field but that was no use at all.

Thank you very much for your help,

Michelle

[Andy Pope]

Have you tried via the selection pane.

Home > Editing > Find & Select > Selection Pane.
Select item to change, F2, type in new name.

Or selecting the chart and using
Chart Tools > Layout > Properties > Name.