Hi there,
Does anyone know how to change a chart name in Excel?
When you create a new chart, Excel assigns a name: Chart xx (where xx is a number - seems like random numbering to me)
When you copy the worksheet containing charts, sometimes the charts are re-numbered in the new worksheet.
I would like to manually change the chart name from "Chart 1" to "My Chart" so I can reference the chart in VB.
(You can right click on a chart and select Chart Window ->on the top it shows the chart number)
Your help would be greatly appreciated
Thanks, Shan
Does anyone know how to change a chart name in Excel?
When you create a new chart, Excel assigns a name: Chart xx (where xx is a number - seems like random numbering to me)
When you copy the worksheet containing charts, sometimes the charts are re-numbered in the new worksheet.
I would like to manually change the chart name from "Chart 1" to "My Chart" so I can reference the chart in VB.
(You can right click on a chart and select Chart Window ->on the top it shows the chart number)
Your help would be greatly appreciated
Thanks, Shan