How about when creating the chart assign to object var
sub CreateChart
dim chMyChart
set chMyChart = Charts.Add
....
....
You can then refer to the chart as a variable.
Other options include looping through all the chart objects in a sheet-
something like
Dim chMyChart
For Each chMyChart In ActiveSheet.ChartObjects
.....
Next
....
Duncan
---
Message posted from
http://www.ExcelForum.com/