3D plot animation?

T

THX_1138

Is it possible in Excel to take a set of 3D data vs. time and have a
animated 3D plot, all in real time? I know it sounds like I'm pushin
its capabilities, but it would be really helpful. Thanks in advance
 
W

wfsteele

Animations are a lot easier in excel than one might think
I've done a moving plot many times with a VLOOKUP and an iterative cell

Tools-->Options-->Calculatio
Switch to manual, meaning one must hit F9 to calc sheet

Put a circular reference in some cel
For example, in cell A1, put formula =A1+1

Each time you hit F9, you now have a counter. To reset the counter, select the cell, hit F2, and Enter. Text editing the formula sets to initial value

Use this counter cell to refer to different blocks of data with the VLOOKUP function
 
Top