Web query financial data into chart
 

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: http://www.excelforum.com/member.php...o&userid=33481
View this thread: http://www.excelforum.com/showthread...hreadid=532821

Web query financial data into chart
 

You 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

"loconel" wrote in
message ...

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:
http://www.excelforum.com/member.php...o&userid=33481
View this thread: http://www.excelforum.com/showthread...hreadid=532821