Option A: Use an Excel 2007 Table (like an Excel 2003 List on steroids) as
the data source.
Option B: Use dynamic ranges as the source data:
http://peltiertech.com/Excel/Charts/...umnChart1.html
http://peltiertech.com/Excel/Charts/Dynamics.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"dave01" wrote in message
...
I have moved over to excel 2007 and cannot work out how to create a chart
that updates automatically. Can anyone help ?