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


--
nsv
------------------------------------------------------------------------
nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500
View this thread: http://www.excelforum.com/showthread...hreadid=477083

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.


--
nsv
------------------------------------------------------------------------
nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500
View this thread: http://www.excelforum.com/showthread...hreadid=477083