Auto updating chart in excel 10 help.

[pylotttt]

I have an excel 10 spreadsheet that I add data to 5 days a week.
I use the 30 last data points to create a chart.
Currently I have to change all points on the chart every time I add to keep a rolling 30 day chart.
Is there a way to set up a filter or some other means to automatically use the last 30 data points to create the chart without having to manually change it?

 

[VoG]

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

 

[pylotttt]

Hi Peter. I am trying this with some level of success.
I have data on 3 pages of the workbook and need to create 5 charts from data on different pages. So far I can only get one chart to work at a a time as the chtcats only references one series on one page.
Is there a way to make more than 1 chtcat the same way I create multiple chtvals?

Thanks for your help.
Rob