Choosing multiple Series for a XY Scatter (simple?)

  • Thread starter Thread starter chadt74
  • Start date Start date
C

chadt74

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
 
Back
Top