You need a dynamic chart, which is based on a dynamic range which expands as
data is added to it. I have examples and links to more examples on my web
site:

http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Matthew" wrote in message
...