Dynamic Graph VBA

[Mitchell Clarke]

Hi All,

I am relatively new to excel and the world of VBA! one of my current roles is to take a years worth of data and turn it into graphs representing the 4 quarters of the year. At the moment this means I have to go in and select the data range from the master sheet for each of the 4 graphs to check that a quarter is visible on each graph. There are 48 time points per each day of the data.

Is there anyway I can use VBA to determine what data needs to go in the four graphs based on 3 months of the year for each graph.

The issue I face is that the start and end dates are not always the same, I have got it to work if the start and end dates are the same but not sure how to use the code to automatically detect which 3 months should go on the graphs.

I.e Graph 1 - months 1-3 of the data
graph 2 - months 4-6 of the data
graph 3 - months 7-9 of the data
Graph 4 - Months 10-12 of the data.

Any help would be much appreciated.

Thanks in advance.

Mitchell Clarke