Could you use other name, such as "Cht 1" etc? Then it will bw easy. Or you
need do it twice: Change it to Cht1, then change it back to Chart 1 again, I
guess.
--
VBA


"navin" wrote:

Hi All,

i have 25 charts in a sheets (Chart Name: Chart 1, chart 2 chart 3
etc.). Now i want to change the name chart 25 to chart 1. but i am
not able to do the same as there is already a chart with the same
name, this is what i think.

the charts in the sheets are not placed in the sorted order by their
names. so i want to rename the charts from the first chart in the
sheet till last and then sort the charts by their name.

please help.

thanks,
navin