Line Graph from a single live cell?

Hi,

I have a spreadsheet that receives live data, is it possible to have a line graph that plots the changes in a single cell ? ie, it may say 38.6 then a second later it may change to 38.2, then 38.0 etc .... I would like to see this in the form of a single line graph.

Thanks for any help
Paul

Thanks very much Kaper, the link looks to be very helpful...
Regards
Paul

Hi Kaper

I have found this info very useful thank you .. But, I find that if I type into cell C3 (refering to your example downloaded workbook ) then everything works fine, but if C3 holds a formula, I still have the changing figures, but the vba does not seem to recognise it and nothing happens.

Is there something I can do to solve this? .. i have tried "IF" and "Value" in col F but still no sucsess.

Thanks for any help
Best regards
Paul

thanks Kaper,

do I need to ask my other question in the forum again ?
Best regards
Paul