So the new data overwrites the old? You could have a routine which copies
data after a recalculation event (which occurs when the data is updated) and
stores it onto another sheet. Then you can chart these blocks of data as
separate series on a common chart.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"Saxman" wrote in message
...
Jon Peltier wrote:
If you make a chart, doesn't it update with the data?
It certainly is dynamic and updates the data, but I would like to view
changes in the data and not to get overwritten on a line graph.
For example, time on the x axis which could be triggered by the data
refresh. On the y axis would be different sets of data (cells F5 - F20).
One could then compare which set of data was increasing/decreasing
relative to one another.