Automatically update charts for only the most current 12 months?

I am trying to update 8 different charts in one workbook. The charts are
based off of one table that is a running total for 1997-2005 and is
continually being updated monthly. The charts only show the most current 12
months. How can I make the charts get updated automatically. The data is
entered in column by column.

See
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html
particularly example 2

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>, AIEC33
@discussions.microsoft.com says...
> I am trying to update 8 different charts in one workbook. The charts are
> based off of one table that is a running total for 1997-2005 and is
> continually being updated monthly. The charts only show the most current 12
> months. How can I make the charts get updated automatically. The data is
> entered in column by column.
>