How do you name a chart?

H

hmmm...

How do change the name of a chart (Chart1, Chart2, ...). I had some VBA
code that activated a chart. I deleted and rebuilt the chart a few times,
and then had problems deterimining the new chart name. I ended up recording
a macro, selecting the chart, and examining the macro code to determine what
the new chart name was. Is there an easier way to name a chart, or find out
what it's name is? Thanks.
 
J

John Walkenbach

Press Ctrl, and then click the chart (this selects it as an object). Then,
type the new name in the Name box (to the left of the formula bar) and press
Enter.

John Walkenbach
For Excel tips, macros, & downloads...
http://j-walk.com/ss
 
H

hmmm...

Thanks.

John Walkenbach said:
Press Ctrl, and then click the chart (this selects it as an object). Then,
type the new name in the Name box (to the left of the formula bar) and press
Enter.

John Walkenbach
For Excel tips, macros, & downloads...
http://j-walk.com/ss
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Saving Chart Names in Excel 2007 1
Word VBA - Want to test if Full Name is NOT Present in document 0
This has to be easy. 2
Can not get Excel macros to save chart format -lost in space! 5
Can not get Excel macros to format/save charts--help??? :((((( 2
chart name not saved when save as another file 0
Copying Named Ranges in Chart Series 1

Top