Excel Dynamic Plots

%3CLINGO-SUB%20id%3D%22lingo-sub-1349988%22%20slang%3D%22en-US%22%3EExcel%20Dynamic%20Plots%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1349988%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20been%20through%20a%20lot%20of%20You%20Tube%20videos%20and%20done%20a%20lot%20of%20web%20search%20without%20success%20and%20would%20appreciate%20a%20bit%20of%20guidance%20from%20an%20expert.%3C%2FP%3E%3CP%3EI%20have%20created%20an%20Excel%20sheet%20(in%20Excel%204)%20many%20years%20ago%2C%20On%20this%20sheet%20I%20added%20a%20simple%20counter%20in%20VB%20and%20using%20this%20counter%20I%20calculate%20a%20change%20as%20the%20counter%20moves%20one%20increment%2C%20other%20cells%20calculate%20various%20formulae.%20As%20the%20change%20in%20formulae%20cells%20happened%20I%20plotted%20them%20and%20it%20became%20a%20simple%20animation%20of%20events.%20Since%20Excel%202016%20I%20have%20not%20been%20able%20to%20do%20this%20and%20been%20trying%20various%20functions%20without%20success.%20Unfortunately%20Microsoft%E2%80%99s%20community%20library%20is%20so%20massive%20that%20my%20search%20has%20lasted%2012%20months%20so%20far%20without%20success!%3C%2FP%3E%3CP%3EIn%20short%3A%26nbsp%3BA%20series%20of%20cells%20that%20have%20a%20changing%20values%20(within%2010%20to%2020%20seconds%20maximum%20time%20)%20which%20changes%20with%20the%20incremental%20counter%20to%20plot%20against%20each%20other%20(like%20a%20scatter%20plot%20with%20straight%20lines).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1349988%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1843649%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Dynamic%20Plots%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1843649%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F642969%22%20target%3D%22_blank%22%3E%40PeaceWorrior%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20had%20a%20similar%20problem%20I%20think.%26nbsp%3B%20I%20have%20created%20an%20XY%20scatter%20chart%20using%20data%20and%20a%20dynamic%20link.%26nbsp%3B%20If%20I%20overtype%20a%20number%20in%20the%20table%20then%20the%20chart%20updates.%26nbsp%3B%20Then%20I%20created%20a%20Macro%20to%20change%20individual%20cells%20in%20the%20data%20columns%20with%20a%20time%20delay%20but%20the%20chart%20no%20longer%20updates%20until%20all%20the%20changes%20are%20complete.%26nbsp%3B%20I%20empty%20all%20the%20cells%20used%20by%20the%20chart%20and%20then%20repopulate%20then%20one%20by%20one%20via%20the%20macro.%26nbsp%3B%20What%20I%20hoped%20to%20achieve%20was%20a%20chart%20that%20was%20animated.%26nbsp%3B%20As%20each%20data%20point%20is%20added%20the%20chart%20should%20change%20so%20a%20line%20progresses%20across%20the%20chart.%26nbsp%3B%20I%20have%20tried%20all%20sorts%20of%20ways%20of%20getting%20the%20values%20into%20the%20table.%26nbsp%3B%20I%20I%20go%20back%20to%20typing%20them%20in%20it%20works%20but%20with%20thousands%20of%20values%20it%20cannot%20be%20done.%26nbsp%3B%20I%20guess%20that%20the%20chart%20does%20not%20change%20whilst%20the%20Macro%20is%20running.%26nbsp%3B%20Any%20ideas%20would%20be%20welcome.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have been through a lot of You Tube videos and done a lot of web search without success and would appreciate a bit of guidance from an expert.

I have created an Excel sheet (in Excel 4) many years ago, On this sheet I added a simple counter in VB and using this counter I calculate a change as the counter moves one increment, other cells calculate various formulae. As the change in formulae cells happened I plotted them and it became a simple animation of events. Since Excel 2016 I have not been able to do this and been trying various functions without success. Unfortunately Microsoft’s community library is so massive that my search has lasted 12 months so far without success!

In short: A series of cells that have a changing values (within 10 to 20 seconds maximum time ) which changes with the incremental counter to plot against each other (like a scatter plot with straight lines).

 

1 Reply

@PeaceWorrior 

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.