Macro to make graphs using dynamic data.

[sal1234]

I am trying to create a macro to a graph which shows a year worth of data, however when another quarter of the year is added (13 Weeks), i want the graph to be updated by moving on every quarter for 12 months from the last piece of data. For instance, i have data between the 7th April - 30th March (1 year) , but when i add new data (another quarter), i want the graph to update from 7th July - 29th June etc. I essentially want a graph that works on dynamic data so every click of the button will show the last 12 months of data on a graph. Anyone have any ideas? I am not very skilled with excel so help would be appreciated.

 

[Andrew Poulsom]

Welcome to MrExcel.

Look here:

Dynamic and Interactive Charts

 

[sal1234]

Thanks for the link, helped a lot. But how do i have that the graph knocks off the previous quarter of data and only shows the latest 4 quarters in the data?

 

[Andrew Poulsom]

Didn't you see this example?

Chart the Last 12 Months Dynamically