Macro to make charts in separate sheets

[SVanHall]

I have a lot of data to process and it all pastes into excel in different sheets. I would like to be able to set up a macro to run in each sheet to organize and plot the data.

Organizing the data has not been an issue thus far but whenever I record a macro to insert two scatter plots it continues to reference the sheet I recorded it on and not the open sheet.

I'm completely new to all of this.

What I have currently to make the graphs is:

Please Login or Register  to view this content.

I usually have 15 sheets per condition. For this set I have "EN AQ 1-15". I would like to be able to organize the data and create the plots on whatever sheet is open when I run the macro so that I can just go from sheet to sheet quickly.

Thanks.

[NickyC]

looks to me like the problem is that you have specified both sheet and range for your sources, eg:

Please Login or Register  to view this content.

Try taking out the sheet references:

Please Login or Register  to view this content.

[Izandol]

You may try:

Please Login or Register  to view this content.