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

Hi, sorry to hear about your dog.

Anyway, I'm just speculating here but couldn't you just have your
chart refencing the cells that are changing so that your chart
would be constantly updating and when you want a printout
just highlight the chart and click on your print button which
should effectively take a snapshot of the chart.

Just a thought
Martin