Automatically update charts for only the most current 12 months?

AIEC33 · February 27th, 2006, 04:40 PM posted to microsoft.public.excel.charting

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.

Tushar Mehta · February 28th, 2006, 03:30 AM posted to microsoft.public.excel.charting

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to update these figures?	Yorkie118	Running & Setting Up Queries	11	October 22nd, 2005 05:56 PM
Installing cumulative update for OE 6	Vasilis	Outlook Express	8	May 7th, 2005 02:01 AM
Same workbook links will not update automatically	Henry	Links and Linking	7	June 19th, 2004 01:46 AM
How to Update Charts with Data Automatically	Jon Peltier	Charts and Charting	1	March 30th, 2004 10:33 AM
Creating a large number of charts automatically (repost)	Francine Kubaka	Charts and Charting	0	September 21st, 2003 09:16 PM