Posted to microsoft.public.excel.charting,microsoft.public.excel.programming
|
|
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
|