Hello,

Completely new to the site with limited experience of Macros.

I have a grid-variable dataset with multiple rows and columns. Column A details dates and Columns B onwards readings taken on those dates for various locations.

I.e.
Column A - Date
Column B - Location A variable A
Column C - Location A variable B
Column D - Location B variable A
Column E - Location B variable B...and so forth (through to column DK or something equally ridiculous)

Traditionally I would create a simple line graph as a ChartSheet for the first two (columns B and C) against date (column A) sort the axes ranges etc then copy it, paste it into a new ChartSheet and amend the datasource to D and E against A.

Unfortunately I have 50+ of these to do and its driving me mad but with no prior experience I cannot figure out how to create a macro to keep on creating the graphs in this stepped fashion.

Any help would greatly save my sanity!