I have an excel spreadsheet which is linked to a data source (via DDE)
and is constantly feeding a single cell different values.
Is it possible to plot a line graph of the value in the cell everytime
it changes?
For example,
The current cell value is 10.00 and the time is 9:00am. Now the time
is 9:15am and the value just changed to 10.25. I want to plot a line
graph that displays the time on the x-axis and the value on the
y-axis.
Please let me know if you can help out. I have been pulling my hair
out trying to figure this out.
Best,
Steve
--
sslack
------------------------------------------------------------------------
sslack's Profile:
http://www.excelforum.com/member.php...o&userid=16442
View this thread:
http://www.excelforum.com/showthread...hreadid=376600