Dynamic Chart

  • Thread starter Thread starter FinnBarr
  • Start date Start date
F

FinnBarr

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?
 
Have your tried making the data part of an Excel 2003 "List" or Excel 2007
"Table"
Then the chart is automatically dynamic
But you will quickly exceed the number of allowed data points in a chart
best wishes
 
Back
Top