LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lossofdog
 
Posts: n/a
Default Real Time Charting


I have 3 individual cells that automatically update every second from an
outside program: 1)Time; 2) Implied Price; 3) Actual Price. I track
the changes of the Implied Price against the Actual Price along Time
all throughout the day (2 line graphs plotted on 1 chart). During the
day I copy and paste the 3 cells into a separate worksheet so they're
stationary and in columns -- from that I create a graph. Is there a
possible way/formula to have a predetermined range of cells auto
populated every minute, predertmined range of individual cells set to
populate at a specific time, or a graph that updates every minute
moving along an x-axis of Time?


--
lossofdog
------------------------------------------------------------------------
lossofdog's Profile: http://www.excelforum.com/member.php...o&userid=34987
View this thread: http://www.excelforum.com/showthread...hreadid=547281

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003's autosum does not update data in real time KokWoei Excel Worksheet Functions 2 April 4th 06 05:12 AM
SUNDERA - Real Time Excel Collaboration Aesaes Excel Discussion (Misc queries) 0 March 3rd 06 01:39 PM
Excel Time Manipulation BFiedler Excel Discussion (Misc queries) 0 September 15th 05 01:15 AM
unmet challenge boris Excel Worksheet Functions 2 March 16th 05 02:13 PM
How do I get real time stock quotes to my excel worksheet? walter Excel Discussion (Misc queries) 1 January 8th 05 12:01 AM


All times are GMT +1. The time now is 08:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"