Macro to advance Graph Ranges To Accommodate new month

Hi,

Can anyone please advise me of the macro code required to create a new month on my graphs i.e. have a macro button in cell ‘A1’ to advance the ranges of the four graphs to accommodate the new month’s data and delete the first set of data in my range in column ‘B’ only leaving the last 12 months data i.e. columns ‘B’ to ‘M’.

Ideally to stop the month being advanced in error is it possible to have a simple password in order to run the macro?

P;lease see attached sample file.

Any assistance would be greatly appreciated

Many thanks in advance

Rob

N.B. Excel version 2010

So instead of complicating matters with VBA, I think it is easier to restructure your data to have a data tab, a processing tab and a reporting tab.

The data tab can look identical to the columns A:M. The processing tab can pull over JUST the prior 12 months, so it would use the offset feature and indirect or count. Basically it would only grab the most recent data so you can have it all and NOT need VBA.
Then the reporting tab would just be a tab with your charts.

Would that not work for you?

I mean, obviously VBA will work, but the above method will automatically update AS you add more data.

Something along the lines of this:
http://chandoo.org/wp/2009/10/15/dyn...t-data-series/

mikeTron,

many thanks for your suggestion, I will check the link out and see if it meets my requirements

Thanks again

Rob