I'd like to add to Don's fine answer: if you are using Excel 2003 and make
the data a List (Data | List - Create List) then when more data is added to
the list, the chart automatically expands to include the new values.

best wishes

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Bigxcr" wrote in message
...
I was wondering if there is a way for me to auto update a chart that I am
using.