Animate Bar Charts - animate transition of charts

[gsimmons2005]

Anyone know how to take a simple bar chart, with say a value of 10 and through the press of a button have it animate and shrink in size down to 5 for example. In other words, I have tons of bars in a "before" case and also an "after" case and I want a macro or code to show the transition between those two.

Any Ideas?

 

[tusharm]

You can do this w/o code using iterative calculations. Of course, that has its own set of issues...

To use iteration, select Tools | Options... | Calculation tab. Check the Iteration checkbox and set the Maximum Iterations to 1.

Now, suppose your 2 data sets are in A and B starting with row 1. Then, in C1 enter the formula =MOD(C1+1,2). Also, create a named formula (Insert | Name > Define...)
YVals =OFFSET(Sheet2!$A$1,0,Sheet2!$C$1,COUNTA(Sheet2!$A:$A),1)

Create a chart using this named formula. For how see
Names in Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/names_in_charts.html

Now, each time you press F9 (or otherwise recalculate the worksheet), the chart will toggle the range it shows between A and B.