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. |
Automatically update charts for only the most current 12 months?
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. |
All times are GMT +1. The time now is 07:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com