Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

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?

Thanks

Re: chart animation

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

Adam,

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

Worksheets("Animation").Activate

Damon

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.