Hi there,
I have a cell that counts up like a clock, I am looking to extract each value and place them in the cells of a column as they appear. Say if it counts 1, 2, 3 that 1 is in the top of column F and 2 and 3 are placed in the next cells down. The aim of this is graph a sign wave but to only have the wave appear as a point moves along it, so maybe there's a much easier way and I'm just making it over complicated!
Any help is much appreciated thanks!
Here is an animated sine wave:
Animated Sine.xlsm
It takes a minute to fully draw the wave, but the formulas can be modified to speed it up or slow it down.
Bernie Deitrick
Excel MVP 2000-2010
Thanks for that although I don't really understand whats going on in it. The Sine wave seems to grow by clicking into any cell then onto another one? And by different amounts each time? I've attached a sample of what I'm trying to do, I want the wave to appear as the pendulum moves when the Start button is pressed so there are also a few other calculations on the sheet?
Pendulum.xlsm
Sorry if I'm being an idiot.
In my file, clicking on D3 starts a macro that updates the formulas every second, and there are 60 formulas that are time dependent, and are used to create the sine wave graph - each second, one more number is added to the graph, so it looks like it is growing.
Anyway, I changed the formulas in T:U to make your graph do the same, but I left your code alone.
Pendulum.xlsm
Ha yes thanks a million for that, I see now all it took was a simple if statement in the cell. Was looking for ages.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks