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


I have 3 individual cells that automatically update every second:
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=547278

 
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 05:19 PM.

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"