Hi,
Hold the SHIFT key when selecting the chart. This will select it as an
object and you can use the Name box, next to formula bar, to alter the name.
If it's a chart sheet then just edit the tab name by double clicking it.
If you are adding the chart via code then you can name it with code.
For more info see,
http://peltiertech.com/Excel/ChartsH...ameAChart.html
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"rk0909" wrote in message
...
I am using 2003.
thanks
RK
"rk0909" wrote:
All,
Is it possible to change the chart name. E.g. when I add a chart it is
called "chart 1". How can I cahnge it to a more meaningful name to use
in
VBA.
Thanks much,
RK