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