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
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
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
dguillett1@austin.rr.com
"loconel" <loconel.26877a_1144970401.5531@excelforum-nospam.com> wrote in
message news:loconel.26877a_1144970401.5531@excelforum-nospam.com...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks