Create a weekly report from a big data set

[atab]

Hi, I would like to know if there is a way I can create a graph of the week from a big sample size that automatically updates itself every day. for examplesay i have this data:
[TABLE="width: 199"]
<TBODY>[TR]
[TD="align: right"]8/30/2012</SPAN>[/TD]
[TD="align: right"]224</SPAN>[/TD]
[TD="align: right"]25</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]9/5/2012</SPAN>[/TD]
[TD="align: right"]224</SPAN>[/TD]
[TD="align: right"]25</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]9/6/2012</SPAN>[/TD]
[TD="align: right"]228</SPAN>[/TD]
[TD="align: right"]8</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]9/8/2012</SPAN>[/TD]
[TD="align: right"]228</SPAN>[/TD]
[TD="align: right"]8</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]9/10/2012</SPAN>[/TD]
[TD="align: right"]228</SPAN>[/TD]
[TD="align: right"]8</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]9/12/2012</SPAN>[/TD]
[TD="align: right"]250</SPAN>[/TD]
[TD="align: right"]8</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]9/15/2012</SPAN>[/TD]
[TD="align: right"]250</SPAN>[/TD]
[TD="align: right"]8</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]9/17/2012</SPAN>[/TD]
[TD="align: right"]250</SPAN>[/TD]
[TD="align: right"]8</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]9/18/2012</SPAN>[/TD]
[TD="align: right"]250</SPAN>[/TD]
[TD="align: right"]8</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]9/22/2012</SPAN>[/TD]
[TD="align: right"]198</SPAN>[/TD]
[TD="align: right"]11</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]9/24/2012</SPAN>[/TD]
[TD="align: right"]198</SPAN>[/TD]
[TD="align: right"]11</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]9/29/2012</SPAN>[/TD]
[TD="align: right"]200</SPAN>[/TD]
[TD="align: right"]14</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]10/1/2012</SPAN>[/TD]
[TD="align: right"]200</SPAN>[/TD]
[TD="align: right"]14</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]10/6/2012</SPAN>[/TD]
[TD="align: right"]200</SPAN>[/TD]
[TD="align: right"]14</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]10/13/2012</SPAN>[/TD]
[TD="align: right"]200</SPAN>[/TD]
[TD="align: right"]14</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]10/15/2012</SPAN>[/TD]
[TD="align: right"]200</SPAN>[/TD]
[TD="align: right"]14</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]10/20/2012</SPAN>[/TD]
[TD="align: right"]192</SPAN>[/TD]
[TD="align: right"]14</SPAN>[/TD]
[/TR]
</TBODY>[/TABLE]
and what I want is a graph that plots only the values of the last 7 days.
Now say I update mylist to include another value for tomorrow for instance, I would like the graph to recognize this and automatically drop add the newest data points and drop the ones no longer within the new week timeframe.
[TABLE="width: 199"]
<TBODY>[TR]
[TD="align: right"]


[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[/TR]
</TBODY><COLGROUP><COL><COL span=2></COLGROUP>[/TABLE]

 

[VoG]

Look here Chart the Last 12 Months Dynamically