I have 255 sets of XY data arranged:
set1_x x11 x12 x13 x14 ... x1500
set1_y y11 y12 y13 y14 ... y1500
set2_x x21 x22 x23 x24 ... x2500
set2_y y21 y22 y23 y24 ... y2500
.
.
.
set255_x x2551 x2552 x2553 x2554 ... x255500
set255_y y2551 y2552 y2553 y2554 ... y255500
where each set of x values is unique (as well as y). I know I can manually add each row to a graph and point to the appropriate set of x values, but this gets very tedious after one or two and I have hundreds of sets. Is there a macro or other way to tell excel to construct an XY graph using pairs of rows for each series?
set1_x x11 x12 x13 x14 ... x1500
set1_y y11 y12 y13 y14 ... y1500
set2_x x21 x22 x23 x24 ... x2500
set2_y y21 y22 y23 y24 ... y2500
.
.
.
set255_x x2551 x2552 x2553 x2554 ... x255500
set255_y y2551 y2552 y2553 y2554 ... y255500
where each set of x values is unique (as well as y). I know I can manually add each row to a graph and point to the appropriate set of x values, but this gets very tedious after one or two and I have hundreds of sets. Is there a macro or other way to tell excel to construct an XY graph using pairs of rows for each series?
