I have to do a few XY Scatter graphs and the problem is I have 1000+
data points and I would like to have each X&Y to be their own Series.
So spending days with the mouse is not high on my list. What I would
like to do is have a pop upbox asking me how many data points I have
and then run a macro where it picks R1C1 for the X and then R2C1 for
the Y for series 1 and then R1C2 and R2C2 for series 2 etc etc until my
variable hits the end of the loop.

I have taken a few stabs at this (I am very good witih Excel but
beginner with VB) and I have not had much luck. If anyone has any
suggestion it would be helpful.

Thanks in advance and if this is not clear please let me know.

Chad

Chad -

Excel 2003's Help topic for "specifications" says the maximum limit for
"Data series in one chart" is 255.

- Mike
www.mikemiddleton.com

wrote in message
ps.com...
I have to do a few XY Scatter graphs and the problem is I have 1000+
data points and I would like to have each X&Y to be their own Series.
So spending days with the mouse is not high on my list. What I would
like to do is have a pop upbox asking me how many data points I have
and then run a macro where it picks R1C1 for the X and then R2C1 for
the Y for series 1 and then R1C2 and R2C2 for series 2 etc etc until my
variable hits the end of the loop.

I have taken a few stabs at this (I am very good witih Excel but
beginner with VB) and I have not had much luck. If anyone has any
suggestion it would be helpful.

Thanks in advance and if this is not clear please let me know.

Chad