Chart naming

  • Thread starter Thread starter Nath
  • Start date Start date
N

Nath

Hi

Can anybody advise me on how to name a chart in VBA,
rather than let excel do it.

Are there any sites that have good details on dealing with
charts in VBA?

TIA

Nathan.
 
Hi Nath,

If its a chart sheet then try,
Activechart.name = "MyChart"

If the chart is an object on a worksheet then try this,
Activechart.Parent.name = "MyChart"
or
Activesheet.chartobjects(1).Name = "MyChart"

To change the name of a chart on a worksheet without code try holding
the shift key whilst selecting the chart. Then in the Name box enter you
new chart name.

A good source of chart related vba can be found on Jon Peltier's site.
http://peltiertech.com/Excel/Charts/chartvba.html

Cheers
Andy
 
Back
Top