Thread: Chart Name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Chart Name

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