Charts using Chart Wizard based Macro
 

I am trying to write a macro based on the chart wizard in Excel. The
macro i want to create will be used in several different workbooks in
order to draw graphs with aprox 100 series (sometimes more) I was
trying to do this inside a FOR loop but can't get VBA or excel to
recognise the column number as a variable in the line:

ActiveChart.SeriesCollection(Series_Collection).XV alues = "='Qmat
Curves1'!R8C1:R967C1"

Any ideas??
Thanks.