chart expands when data does
 

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!)

chart expands when data does
 

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

chart expands when data does
 

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

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


"ericaamousseau" wrote in message
...
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!)