Change the assigned chart number

  • Thread starter Thread starter Al Eaton
  • Start date Start date
A

Al Eaton

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?
 
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"
 
Back
Top