Hi everyone,

I'm new to macros, and I was hoping someone here could give me a hand creating what I imagine is a rather simple macro. I'm trying to set up a macro that would create a scatter plot using 48 cells from column B as the x variable and 48 cells from column M as the y variable. The tricky part is that I want it loop so that it creates a chart with B2:B49 and M2:M49, and then another with B50:B97 and M50:M97, so on and so forth through all of the data. If it could space the charts out that would be ideal but if they all go to one location I could deal with that. If 2 columns is not possible, the x-variable is just repeated, so it could just use B2:B49 for the x variable all the time.

Anyone available to lend me a hand?