Record changing values by date into different cells
I have a Numbers spreadsheet that calculates target values of investments over time on a month by month basis .
How do I automatically copy those periodic values to another cell in order to preserve those calculated values. I have a formula in a certain cell which calculates those values monthly so for example: Jan calculated to 10, Feb 15, Mar 20. I would like to write those periodic values to say a row and preserve the values in order to produce a graph of Calculated vs. Actual.
How the heck do I do this? Can anyone help?
MacBook, Mac OS X (10.6.4)