Change the assigned chart number
 

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?

--

Al Eaton

Change the assigned chart number
 

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

Change the assigned chart number
 

see
http://peltiertech.com/Excel/ChartsH...ameAChart.html


"Debra Dalgleish" wrote in message
...
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