Automatic updating charts in excel
The Chart Web Part also offers you the choice between connecting directly to the actual list, or connecting to the list web part that you've put on the page.
I was able to overcome this issue previously by using a virtual machine and running Excel in said virtual machine.
Thus, currently I find myself updating 5 or 6 worksheets each time when I change something in the original chart.
Automatic updating charts in excel comments