Hi,

You can create a named range, see here for more details
http://peltiertech.com/Excel/Charts/Dynamics.html

Or you could make your range a List, Table in xl2007. Charts based on these
auto expand.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"NotGood@All" wrote in message
...
I have many entries of data in an Excel spreadsheet. I add to it every day
and would like to create a chart. Is there a way that my chart can update
every time I add a new entry?

Thank You
--
NotGood@All