Chart names

I want to manipulate a chart with VBA and need the name of the chart for this.

Presently the only way I can find a chart name is by recording a macro, where I do something to the chart, and then look in the recording what name the generated macro noticed.

It must be possible to do this more elegantly and also it should be possible to change a chart name, but how?


NSV

http://peltiertech.com/Excel/ChartsH...ameAChart.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


nsv wrote:
> I want to manipulate a chart with VBA and need the name of the chart for
> this.
>
> Presently the only way I can find a chart name is by recording a macro,
> where I do something to the chart, and then look in the recording what
> name the generated macro noticed.
>
> It must be possible to do this more elegantly and also it should be
> possible to change a chart name, but how?
>
>
> NSV
>
>

UPS, I suppose I ought to be embarassed , i didn't even look after it, but appearently you have a bit of a treasure garden on that site.

Still, I think within the next few days I might pop up with a difficult one about 3D multi-variable area graphs. But first I will try and find the solution myself.