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
Highlighted
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).

 

0 Replies