Animated Excel chart.....

Hi,

I am hoping to produce an excel chart which animates over time - the data is simple x,y coodrinates and there are only 8 columns of data along with 1 column of time data - looks like the example below.

I have no idea where to start with this but I suspect it will involve VBA? - anyone done this before or have some tips to get me going :-)

Cheers,.

Please Login or Register  to view this content.

Hi,

I have attached an example spreadsheet - the current plot is the first row and I would like to plot the next row down after a time delay followed by the next row..... etc So the final result would be the plot line being animated as time moves forward.... I am aiming to show the time value in a window within the animation so you can see how fast time is passing.

Hope that makes sense?

Cheers,

Thanks 6stringjazzer,

Very cool, I must learn what the VBA means so I can customise more :-) where is the best place to learn VBA? (book or videos).

Is it possible to achieve any of the following....?

• Print the time in a window within the graph area (digital or even analog).
  Output each frame as jpg to file so a video can be assembled.
  Have a background image in the graph area (gives context to the data)

where is the best place to learn VBA? (book or videos).

There is no one best place, but I learned it from a book by John Walkenbach. I highly recommend his work. There is also more material online than you will ever be able to read.

Print the time in a window within the graph area (digital or even analog).

Go to Excel Help and search on "Dynamically display the contents of a cell or range in a graphic object"

Output each frame as jpg to file so a video can be assembled.

Sorry, you're on your own on that one

Have a background image in the graph area (gives context to the data)

Click on the background right click, select Format Chart Area. On Fill, select Picture or Texture Fill, and then select the image to use as background.

See attached for examples of the two that I know how to do.

Thanks again, I can see how this could all work now :-)

One last question - how would I change the speed slider so that the time interval was in 1/10th of seconds? so perhaps 0.1 seconds to 2 seconds in 0.1 steps?

Had to change a few things around to do that.

Thanks for your help 6StringJazzer - very much appreciated - it has got me going nicely - cheers.