Chart that automatically updates with new data and new date range

[needhelp13]

I have historical data that I add every day to it. Every week I have to create a line chart that plots the data for the past three month - so this means that every week the chart has to be updated by dropping the oldest week and adding the last week. For example if I have data from 1/1/2013 through today (keep in mind I am adding every day the daily sales figure so its date and sales) and lets say on Monday 8/5/2013 the chart will include data 5/2/2013 - 8/5/2013, but the coming Monday 8/12/13 the chart has to include 5/12/2013-8/12/2013. So how can I set this to be automatic instead of me adjusting the axis every week?

Thanks for your help!

[Steve=True]

Hi Needhelp13,

You can do this with the offset function with your number of rows set to 30 in the offset function.

Here is a step-by-step tutorial and video demonstration.
Case Study - Creating a Dynamic Chart in Excel Using Offset Formula

Let me know if it helps.

Steve=True