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:

8/30/2012</SPAN>	224</SPAN>	25</SPAN>
9/5/2012</SPAN>	224</SPAN>	25</SPAN>
9/6/2012</SPAN>	228</SPAN>	8</SPAN>
9/8/2012</SPAN>	228</SPAN>	8</SPAN>
9/10/2012</SPAN>	228</SPAN>	8</SPAN>
9/12/2012</SPAN>	250</SPAN>	8</SPAN>
9/15/2012</SPAN>	250</SPAN>	8</SPAN>
9/17/2012</SPAN>	250</SPAN>	8</SPAN>
9/18/2012</SPAN>	250</SPAN>	8</SPAN>
9/22/2012</SPAN>	198</SPAN>	11</SPAN>
9/24/2012</SPAN>	198</SPAN>	11</SPAN>
9/29/2012</SPAN>	200</SPAN>	14</SPAN>
10/1/2012</SPAN>	200</SPAN>	14</SPAN>
10/6/2012</SPAN>	200</SPAN>	14</SPAN>
10/13/2012</SPAN>	200</SPAN>	14</SPAN>
10/15/2012</SPAN>	200</SPAN>	14</SPAN>
10/20/2012</SPAN>	192</SPAN>	14</SPAN>

<TBODY>
</TBODY>

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.

<TBODY>
</TBODY><COLGROUP><COL><COL span=2></COLGROUP>

 

[VoG]

Look here Chart the Last 12 Months Dynamically