Live Charting

Originally Posted by Rikuk

Hi,
I currently have a spreadsheet that updates cell A1 with price information every minute. Is there a way of charting this every time the cell changes, to provide a history of the price movement?

Rik

Hi,

you could set your chart to (say) A1:A20 and where you perform your A1 cell update then move A1:A19 to A2:A20 and then put the new figure into A1.

hth
---