Does this mean you know how to archive the data already, just not chart it?
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
wrote in message
ups.com...
On 10 Jun, 01:16, "Jon Peltier"
wrote:
I've worked with clients to provide this functionality, essentially a
routine that detects an update (using worksheet_calculate) and copies the
new data to a table of previous results on another sheet; this table is
used
as the chart's source data range.
- Jon
Thanks Jon. I have decided to ditch the graph and just use figures. I
will be able to watch trends by highlighting high, low and average of
each price.