Thread: Chart Animated Sine Wave

J-walk's excel 2000 vba book comes with an animation file that uses interations to produce a fluccuating sine wave. Why is it that if I copy the exact same sheet to a new workbook and copy the associated macro to that new workbook, the animation does not work properly. If you have not seen this (or the book) and need more details, let me know.

I am trying to understand this better and it thoroughly confused me. I can have both workbooks open (j-walks and the new book) with access to his macro and the one I duplicated from his. Using the new workbook I cannot get either macro to animate the graph. Using his workbook, I can get both macros to animate it.

I have tried turning on iterations, but that did not make a difference. When I run the macros it recalculates all of the chart source data, but the chart does not change.

What am i doing wrong??

I have narrowed the problem down, I think. I created a new chart right next to the chart that animates. I made both charts the same type, but still only the original chart is dynamic with the data. The newly created chart references the same data and changes if the data is changed manually, BUT it does not change when the macro changes data rapidly. I must be missing a chart setting or refresh rate. Any ideas?? Both of these charts are in the same sheet. One works to animate and the other does not.