If you're using Excel 2003, you can define a List using the table. As the
data expands or contracts, the list also changes, and any formulas or charts
based on the defined list will change to accommodate the entire list.

Otherwise you could define dynamic ranges and make a dynamic chart:

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

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


"Ian" wrote in message
...
i have a sheet with dates in column A and various bits of data in columns
B-F. I want to chart it but have the chart also go down to the last row
entered. I could make a little db for it but don't want to (easier to
copy
data within the sheet). how do I describe the last row of the chart so
that
it always goes to the last row that's filled in?