See Dynamic Charts:

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

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


"ChrisG" wrote in message
...
I have a worksheet full of raw data and other worksheets which are just
charts based on the raw data. I continually add more data to the raw data
worksheet, and I was wondering if there is a way to change the source data
of
the chart so that it will automatically update if the raw data changes.
To
clarify this, I will give an example. If on Monday I have 5 rows of data
and
every day that week I add more rows, so that by friday I have 10 rows of
data
(with the most recent data comprising the top row), can I have the chart
automatically include all of the data? Thanks for your help