Chart Name

[rk0909]

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

 

[Raz]

yeah, ofcourse,
if you are using 2007, just select the chart,(click once at its border)
then go to layout on the top menu.
u will see title. and change it there

 

[rk0909]

I am using 2003.
thanks
RK

 

[Gord Dibben]

You are adding a chart sheet?

Alt + F11 to open VBEditor

Select Chart1 and View>Properties Window.

Change the name at (Name).

Or when using VBA use the codename Charts(1)

As in

sub selcht()
Charts(1).select
end sub


Gord Dibben MS Excel MVP

 

[Andy Pope]

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/ChartsHowTo/NameAChart.html

Cheers
Andy