Hi guys,
I have a very basic excel sheet set up which pulls in a value from a website (Data --> From Web --> Select the table and click OK).
The website it pulls from refreshes its data every 10 seconds. I have set the spreadsheet to refresh the cell data every minute (I think this is the minimum refresh interval you can set).
So as it stands I have a single cell on my spreadsheet with an integer in it, which refreshes every minute (when the excel web query runs) and it populated by the latest value it pulls back.
Is there an "easy" way to use this to plot the value of this cell over time so we can keep track of the value on a "real time" graph ?
Any help would be much appreciated.
Many thanks in advance
Bookmarks