Hi All

Im trying to create a dynamic chart from a worksheet that is refreshed
every 1 second, which is more of an animated chart at that speed, I
guess.

Am I right in thinking that there are limits to the dynamic method?
When you manually type in the data, its fine, but once its automated
it keeps crashing my VBA code and thus stops the data from
refreshing.

As a workaround I had intended to write the data into an array,
transfer it to a newsheet and chart from there. If I refresh the data
at periods from its source to the newsheet will it crash again?

Are there any add ins or software products that tie in to excel to
overcome this?