Choosing multiple Series for a XY Scatter (simple?)
 

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

Choosing multiple Series for a XY Scatter (simple?)
 

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