M
mikeadams
Hi - using Excel 2002 on Win XP
I am trying to find out if I can copy data from a cell (that is update
from a web query every five minutes, and to plot that data into a ne
cell - so that the updated data increments down the spreadsheet - so
can eventually plot graphs.
For example - I am monitoring a weather station that updates a cell o
my sheet with the atmospheric pressure. Every five minutes the shee
refreshes and the data in that cell may change if the pressure readin
has altered. How would I write a formula to take that cell data and t
create a list of data readings so that I can plot them and create
graph showing the pressure changes over time
I am trying to find out if I can copy data from a cell (that is update
from a web query every five minutes, and to plot that data into a ne
cell - so that the updated data increments down the spreadsheet - so
can eventually plot graphs.
For example - I am monitoring a weather station that updates a cell o
my sheet with the atmospheric pressure. Every five minutes the shee
refreshes and the data in that cell may change if the pressure readin
has altered. How would I write a formula to take that cell data and t
create a list of data readings so that I can plot them and create
graph showing the pressure changes over time