Hi,

Details of the Named range approach can be found here.
http://peltiertech.com/Excel/Charts/Dynamics.html

You can also use Lists xl2003, Tables in xl2007

Cheers
Andy

ericaamousseau wrote:
I would like to have a bar graph that exdpands when I add lines to the data
worksheet. I know there is a way to do this, i just can not figure it out
with out changing the source data everytime I add data. Help! (Thanks!)

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info