Saving graph when using =(RAND)

[deacs]

Hi all,

I have a spreadsheet that uses the =(RAND) function to generate a
graph. Each time I click F9, I see a different graph. Is there a way
for me to save each generated graph on the same chart? I'm not sure
I'm being clear. Please let me know if this is possible of if you need
additional information.

Thanks!

 

[kkknie]

You could copy the data that is generated on each F9 and Paste Special |
Values (to replace the formula with the value) to another part of the
worksheet. Then when you are done, create another graph using the data
you pasted.

K