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