Hi,

While I'm familiar with how to record and use a macro, i believe this problem needs a more complex solution and I am a complete novice when it comes to writing a macro.

on worksheet 1 titled "Data" I have 100+ rows of data and from each row i want two different scatter-plot graphs to auto generate on worksheet 2 titled "Graphs" in specific specific locations. I don't currently have data populated in each row but when it gets put in there, i need the graphs to update with the new data.AUC calculator with graphs and data min 12.3.12.xlsx

graph 1 will use {N1:O1,AH1:AL1} and {Q1:R1,T1,V1,X1,Z1,AB1} as the x and y-axes, respectively.
graph 2 will use {O1,AH1:AL1} and {AM1:AR1} as the x and y-axes, respectively also.

i want those two graphs to auto-generate for each row using the same columns each time and then show up on "Graphs" adjacent to each other 19 rows below the previous two graphs in a column.



can someone please help!