SOLVED; Chart doesn't update fast enough to show incremental change in values

I'm using a 3d bar chart. I want to show the movement of a value from one cell to another for clarity. I currently have something like this:

Please Login or Register  to view this content.

But the chart doesn't update until after the change. Can anyone point me in the right direction here?

try using DoEvents which will cause a refresh.

That still maybe too fast in which case consider using the Sleep API in order to add a delay to the loop.