Lot's of ways. The usual is to use a defined name for the series with an
offset formula to include row/columns
use a defined name such as =offset($a$1,0,0,counta($a:$a),4).
Go to these for more info
http://www.tushar-mehta.com/
http://peltiertech.com/
--
Don Guillett
SalesAid Software
"Bigxcr" wrote in message
...
I was wondering if there is a way for me to auto update a chart that I am
using.