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

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" 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

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

You are adding a chart sheet?

Alt + F11 to open VBEditor

Select Chart1 and ViewProperties 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

On Mon, 6 Oct 2008 11:31:01 -0700, 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

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