I need for my charts to auto-update each month.

wharp88 · Apr 10th, 2002, 06:19 AM

Hey:
I have many charts that I am continuously updating. As I add the next months data I must then manually update my charts to show the current data. Is there a way either through functions or through a macro that I can have the chart automatically pick the most recent 12 month period?

Dave Hawley · Apr 10th, 2002, 06:22 AM

Hi wharp88

I think you will find some very helpful info on this here:
http://www.ozgrid.com/Excel/ChartTips.htm near the bottom under: "Two Handy Dynamic Ranges For Charts"

Also here: http://www.ozgrid.com/download/default.htm
Under: "ChartByMonth.zip"

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

Apr 10th, 2002, 06:19 AM	#1
wharp88 New Member Join Date: Apr 2002 Posts: 2	Hey: I have many charts that I am continuously updating. As I add the next months data I must then manually update my charts to show the current data. Is there a way either through functions or through a macro that I can have the chart automatically pick the most recent 12 month period?

Apr 10th, 2002, 06:22 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi wharp88 I think you will find some very helpful info on this here: http://www.ozgrid.com/Excel/ChartTips.htm near the bottom under: "Two Handy Dynamic Ranges For Charts" Also here: http://www.ozgrid.com/download/default.htm Under: "ChartByMonth.zip"