a) when you click on the data in the chart do you get range finders
(coloured borders) around the data in the cells?
b) does chart update when you press F9; have you checked Tools | Options |
Calculate to see if the ws has Automatic calculations pressed?
c) tell us what version of Excel you are using
best wishes
