Generating multiple graphs from evenly spaced data sets in a single sheet with a macro

[Excel_intermediate]

I thought I was moderately comfortable with Excel until I started writing this macro - I am tearing my hair out and would be very grateful for any help you could give! I am using both Excel 2007 and 2010 (older at home and newer at work).

I need to generate a large number of graphs from many data sets located in a single sheet, that are spaced at regular intervals up to row 576 distributed as in the example file attached. I've put the graph I want to draw for each data set (A1, A2 etc) on the sheet. The x-axis should be time (row 2) with the remaining data (rows 3+4+5+6) as y values. I would like to loop through a macro generating this graph and instruct Excel to look 6 rows down in the same place for the next set of data until it reaches row 576. I would like each graph to be identical. I already have a macro that will order all the generated graphs nicely, now I just need the actual graphs...Example file.xlsx

I hope this was enough information to give an idea of what I need to do; apologies if not.

Thank you very much in advance!!

[alansidman]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.