Recently I received an email from a student who wanted to know whether
we can do animations using
MS-Excel. At first I was a little surprised but then I saw the
attachment. I found this a great way to learn many topics in Excel.
You can truly combine
your knowledge of the charts, scroll-bar and if-function in Microsoft
to create fun animations.
In fact, the process of making such movies can help the user to learn
this spreadsheet application quickly and easily.
How to implement the complete process:
Enter data in the worksheet cells A3 to A6 as shown
Now select the cells and clisk on insert chart.
charts, then stack chart.
Convert the view of the charts from 'column' to 'row'
Replace each of the rectangles with images of your
Delete all the lines and matter surrounding the
Replace all the 1's with 0's and you'll notice that
Insert a scroll-bar and assign it the maximum value
because we have 4 pictures and change is eaqual to 1. All these changes
are done in the property-window of the scroll bar. Now also link the
scroll bar to a cell, say, cell B3.
Now using the if function replace the 0's with a
like '=IF($B$3=4,1,0)'. 1=TRUE, 0=FALSE. Here we use the absolute reference because we
always wish to
select the cell B3. Do this for each of the data
as shown in the video.
Now when you click on the scroll-bar, the value in
B3 changes and so does the value in the corresonding cells of the data
series and the relevant picture is diplayed.
To make the picture look normal right-click on the
and reduce the gap-width to 0%.
Next make the changes as shown in the movie to give
whole animation a natural look.