Date: Tue, 30 Mar 2004 16:41:15 -0800
Reply-To: Bobby Kidd <rakidd@FTB.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Bobby Kidd <rakidd@FTB.COM>
Subject: Graphs without SAS/Graph
Content-Type: text/plain; charset=ISO-8859-1
I need to be able to edit existing graphs. The paper by Howard
Schreier at http://www.nesug.org/Proceedings/nesug01/ps/ps8016.pdf has
given me some ideas as to how to accomplish this. However, I have
gotten stuck. I need to be able to change the cell references every
month. My Excel Sheet contains historical data since 2000 which is
updated on a monthly basis. I add the current month's data to the
bottom of the list. This means that the chart which holds a rolling
12 month period will use the columns 1 - 12 the first month and 2 - 13
the next and 3 - 14 the month after that.
How can I dynamically change the cell references in these charts?