View Single Post
  #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