Extending a Chart range automatically

[Shane Nation]

OK, can you people tell a thick twit how to automatically extend a chart
range by rows as I type in more data each day?

Thanks

 

[Frank Kabel]

Hi
have a look at
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html