MrExcel Publishing
Your One Stop for Excel Tips & Solutions

chart animation

Posted by adam on August 05, 2001 4:20 PM

I have a chart that plots a four bar linkage, and a
macro that moves/rotates the linkage.

The chart doesn't allways update (animate) when the macro
runs. Sometimes part of the chart animates, and
sometimes none of it updates while the macro is running.

Is there a away to force the chart to update/refresh with each
increment of the macro's for/next loop?


Posted by Damon Ostrander on August 05, 2001 6:05 PM


I believe that activating the worksheet forces a refresh, e.g.,