Hi,
I have a spreadsheet with a lot of calculations and data. As a consequence
when I recalculate I get 'Calculate' appearing on the bar at the bottom.
I've learnt that this is because I've reached the dependency limit. All the
calculations provide the correct answer whenever it recalculates (I've tried
F9, shift F9 and ctrl shift F9). however the charts don't update. They
still show the values before any calculation. Is there some mysterious
setting that I've missed or way of updating the charts?

Cheers