How do you name a chart?

  • Thread starter Thread starter hmmm...
  • Start date Start date
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.
 
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
 
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...
 
Back
Top