Tim

From my basis knowledge of charts in a sheet they are named based on how
they are created. The first chart you create on a sheet will be named Chart1
then Chart2, and so on.

You can determine the name of a chart by right clicking on a whitespace area
of the chart and selecting "Chart Window." Once you know the name of the
chart you can refer to it as follows:

This will select the first chart created on sheet1. For the second Chart
created you would change the 1 to a 2 and so on


Sheet1.ChartObjects(1).select


Mike


"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