Moving Chart?

[usaflilbow]

Hello, just a quick question.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Is there a way to have a chart that automatically updates, only display the most recent data?
<o> </o>
Say I only want the latest 30 points show on a chart that automatically updates, but the data has over 100 points. I would like the chart to drop the first point on the chart when the chart adds a new last point so there is always only 30 points displayed.
<o> </o>
Thanks for any help,

 

[VoG]

This should help http://peltiertech.com/Excel/Charts/DynamicLast12.html

 

[usaflilbow]

Thanks