Jon Peltier wrote:
Let's say you have two sheets, the "Data" sheet which keeps refreshing and
the "Archive" sheet where you will store old data.

Thanks for the feedback. There is quite a bit of stuff on the web when
one does a search for 'dynamic graphs'.

However, my proposed graph needs to be constantly updated so that I can
view trends, such as those recording stock market movements throughout
the day. The data must not be overwritten but added to.

I'll post back with my results.

Thanks again.