automatically update chart plotting current month and previous 6

=?Utf-8?B?SmFuZQ==?=

Guest

Posts: n/a

1st Sep 2005

I need to automatically update a chart every month for a report but I only
want to plot the current month and six months back each time. For example
Feb-Aug for the Aug report then for the Sept report plot Mar-Sept. Any
suggestions?

« OVERLAY TWO CHARTS(GANTT) | I need to convert grid.doc to an Excel Grid. »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
3-Color Scale Vlookup for Current Month/Previous/Pre-Previous	NeoFax	Microsoft Excel Misc	2	8th Jan 2010 07:04 PM
Retrieve data for previous 3, 6, 12 month given current month	=?Utf-8?B?R0I=?=	Microsoft Excel Worksheet Functions	4	19th Jul 2007 11:58 PM
copy worksheet from previous month and rename to current month	=?Utf-8?B?RGFuIEUu?=	Microsoft Excel Programming	4	8th Dec 2005 09:40 PM
want chart to update automatically every month	NYBoy	Microsoft Excel Misc	1	10th May 2004 01:12 AM
Printing Previous & Next Month's Calendar on Current Month	Tom	Microsoft Outlook	1	24th Feb 2004 10:23 PM