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?
Bookmarks