Naming a chart created with VBA

[excelnoob]

Hi!

This might be a simple question, but I don't seem to find the answer.

So, is there any way to name a chart that is created with VBA? I need
the chart to be named so that I can do "things" to it.

Thank you in advance

 

[Don Guillett]

You didn't post your code but try

ActiveChart.Name = "whatever"

 

[Debra Dalgleish]

If the chart is active:

ActiveChart.Parent.Name = "MyChart"

Also, Jon Peltier has code samples that may help you:

http://www.peltiertech.com/Excel/Charts/index.html#hdrVBA