superb! thanks for everybody's help here! its amazing i can have used
Excel for so long without ever realising something as apparently basic as
that!

"Andy Pope" wrote in message
...
Hi Tim,

Hold the shift key and then select the chart object. You should get
white handles at the corners instead of the usual black. You can now use
the Name box, next to the formula bar, to change the chart name.

With code,

Activechart.parent.name = "MyChart"

Cheers
Andy

Tim wrote:
Hi,

Could someone tell me if its possible to give a chart a name (with or
without VBA) so that it can be referenced in VBA (I've searched but
found no
reference to this topic)... if naming is not possible how would i go
about
referring to specific charts in vba (there are several charts on one
worksheet, so i cannot just refer to the worksheet).

Thanks people,

Tim



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info