Create Chart - 12 series offset one column from the last

I'm interested in creating a scatter plot of 12 series as a new chart in its own sheet. The Y values are the same for each series, but the X Values may differ and are in consecutive columns in my data sheet (DataAll). The names for each series are in consecutive rows in a setup sheet (SetupAll)

I want to do this several times for different sets of series, so I want a macro that is easily changed. I am getting an Object Required error '424' at line

Please Login or Register  to view this content.

Any idea why I am getting this error? I have included my code with the first 3 data series to be added.

Also - will this chart update automatically if the X Values are updated?

Thanks!
V. Hagberg

Please Login or Register  to view this content.

The main problem is the XValues and Values objects of the seriescollection are not ranges but rather a variant that can accept range or array references.

try this,

Please Login or Register  to view this content.