To manually rename a chart object:
Hold the Ctrl key, and click on the chart to select it
Click in the Name box, to the left of the formula bar
Type a new name, or edit the existing name
Press the Enter key
To programmatically rename a chart object:
ActiveSheet.ChartObjects("Chart 1").Name = "NewChartName"
Al Eaton wrote:
If you use the Macro Recorder and select several charts (in the same
worksheet) in secession you can see that Excel has assigned a name to each
chart such as Chart 1, Chart 2, ect.. Is there a way to rename say Chart 15
to Chart 3, assuming Chart 3 does not already exist?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html