Via a web query I import the Euro/Dollar exchange rate during e.g. 2.00
pm to 5.00 pm in a cell of an Excel sheet with a refresh rate of 1
minute.
I like to plot this rate versus time over this period.
How can I realize that?
regards, Louis--
loconel
------------------------------------------------------------------------
loconel's Profile: www.excelforum.com/member.php...oamp;userid=33481
View this thread: www.excelforum.com/showthread...hreadid=532821You would have to use a macro to store the info on a sheet with a automatic
defined name for the graph range.
--
Don Guillett
SalesAid Software
quot;loconelquot; gt; wrote in
message ...
gt;
gt; Via a web query I import the Euro/Dollar exchange rate during e.g. 2.00
gt; pm to 5.00 pm in a cell of an Excel sheet with a refresh rate of 1
gt; minute.
gt; I like to plot this rate versus time over this period.
gt; How can I realize that?
gt;
gt; regards, Louis
gt;
gt;
gt; --
gt; loconel
gt; ------------------------------------------------------------------------
gt; loconel's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33481
gt; View this thread: www.excelforum.com/showthread...hreadid=532821
gt;
- Aug 28 Tue 2007 20:39
Web query financial data into chart
close
全站熱搜
留言列表
發表留言