Saving Historical Data

[DCRAIG3389]

I have a formula that changes everyday but i would like to record the results each day and plot the resulting number. How do i save the past numbers so that i can chart them?

[noboffinme]

Hi DCRAIG3389,

I would suggest a Macro if you want this to happen automatically.

Otherwise, copying & pasting manually into another worksheet to keep these figures for your chart would do it.