If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Dynamic Chart
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? |
#2
|
|||
|
|||
Dynamic Chart
Anybody......
No............... Dust! |
#3
|
|||
|
|||
Dynamic Chart
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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "FinnBarr" wrote in message ... 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? |
#4
|
|||
|
|||
Dynamic Chart
Im using xl2002 so I dont have the list function available.
|
Thread Tools | |
Display Modes | |
|
|