Need Help with graph automation...
Posted by Steven D. on July 10, 2001 12:33 PM
I have several graphs whose range needs to be updated every month. I need the graphs to graph the newest 12 months of data. Could someone please give me a step by step instructions on how to achieve this.
Thanks a whole bunch.
Posted by Damon Ostrander on July 10, 2001 12:49 PM
Steven,
This could be done automatically with VBA code, but can also be done using filters. Put a filter on the column of data that contains the date (you will need an Advanced filter) that filters the column for dates > Today - 365 (i.e., dates since one year ago). Since filtered rows (and columns) do not appear on graphs, this should do the trick. You just need to make sure the series on the chart includes the entire range of rows that you expect to contain data you want to plot even as you add data. This means that initially you will have to declare a range that goes well beyond the range of data currently on the sheet.
Happy charting.
Damon
