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

Saving Chart Names in Excel 2007 1
can you create a dynamic chart in an xlt templet 1
This has to be easy. 2
Can not get Excel macros to save chart format -lost in space! 5
Changing the chart name 1
Chart name 2
Delete multiple chartobjects from one chart sheet 0
How to display the Chart Name as a Chart Title? 1

Top