Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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=547279 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Real Time Charting
What I gather from your post is that you simply need a chart/graph which automatically updates according to the new values in you time and the two price cells? You shouldn't really need to do anything here. Just create a graph based on the 3 cells (which get updated on a regular interval) and the graph should update itself everytime the values of the 3 cells change. I hope this helps. Sahil -- schoujar ------------------------------------------------------------------------ schoujar's Profile: http://www.excelforum.com/member.php...o&userid=26574 View this thread: http://www.excelforum.com/showthread...hreadid=547279 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Real Time Charting
Simply making a graph referenced to the 3 cells does create an "updating" chart, but when the data changes it is not recorded in the graph and does not move forward along the x-axis. -- lossofdog ------------------------------------------------------------------------ lossofdog's Profile: http://www.excelforum.com/member.php...o&userid=34987 View this thread: http://www.excelforum.com/showthread...hreadid=547279 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Local Apparent Time (LAT) - real / actual solar time ? | Excel Worksheet Functions | |||
Real-time charting of DDE links | Charts and Charting in Excel | |||
Real Time Charting | Excel Worksheet Functions | |||
Real Time Charting | Charts and Charting in Excel | |||
real time charting.... | Charts and Charting in Excel |