I have a data file which looks like this:

set1 56 47
set1 35 33
....
set2 23 56
set2 33 67
...
etc

I want to write some vb code to plot an xy line chart using the different
sets but am having trouble accessing the chart
The outline of what I want to do is

chart.add
nm=acitvechart.name
then set up the chart ofr the first set - all ok with this
then
for i=2 to n (n=number of sets)
ActiveSheet.ChartObjects(nm).Activate
make the chart active
add the data to the chart as a new series
next i

I am having problems selecting the chart and making it active in the for
loop as I get an error with
ActiveSheet.ChartObjects(nm).Activate
Can anyone help please?

Thanks Chris