Forum Discussion
Excel Dynamic Plots
I have had a similar problem I think. I have created an XY scatter chart using data and a dynamic link. If I overtype a number in the table then the chart updates. Then I created a Macro to change individual cells in the data columns with a time delay but the chart no longer updates until all the changes are complete. I empty all the cells used by the chart and then repopulate then one by one via the macro. What I hoped to achieve was a chart that was animated. As each data point is added the chart should change so a line progresses across the chart. I have tried all sorts of ways of getting the values into the table. I I go back to typing them in it works but with thousands of values it cannot be done. I guess that the chart does not change whilst the Macro is running. Any ideas would be welcome.