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

[wharp88]

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]

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"