3D plot animation?

  • Thread starter Thread starter THX_1138
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top