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 , 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.