Solomon -
One way is to use a set of unused cells to house the data for the chart.
For example, if you want to always chart 6 values, then you can set up a
worksheet with the data in cells AA2 to AF2, and the headings in cells AA1 to
AF1. Then this is what you put in cell AA2 (the first data cell):
=INDIRECT("R1C"&MONTH(NOW()),FALSE)
Explanation: This cell looks at today's date Now() and gets the month
number Month and appends that to a relative address. For January this
would be R1C1, for February this would be R1C2, etc. Then the INDIRECT will
put the value of the cell into the current cell (AA2).
So, you can set up the 5 cells in a similar manner. If you need column
titles to change so you can use them on the chart, then you can do the same
for cells AA1 to AF1.
Now, point your chart to use these cells, and as the months change, so will
these values, and your chart.
--
Daryl S
