Tip of the day - Animations

• Enter data in the worksheet cells A3 to A6 as shown
• Now select the cells and clisk on insert chart. Select bar charts, then stack chart.
• Convert the view of the charts from 'column' to 'row' series. 
• Replace each of the rectangles with images of your choice
• Delete all the lines and matter surrounding the pictures
• Replace all the 1's with 0's and you'll notice that all pictures disaapear
• Insert a scroll-bar and assign it the maximum value of 4 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 function 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 the cell 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 picture and reduce the gap-width to 0%.
• Next make the changes as shown in the movie to give the whole animation a natural look.