Yes the calculate event.

But as I said previously with all those cells changing the update will take ages. as each time a cell changes the whole chart will upate.