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?


--
gsimmons2005
------------------------------------------------------------------------
gsimmons2005's Profile: http://www.excelforum.com/member.php...o&userid=26385
View this thread: http://www.excelforum.com/showthread...hreadid=482068

Hi,

Have a look at Jon's example of control the contents of a chart. If you
plot both before and after series in a chart on can then via a control
choose which one to display. No vba required.
http://peltiertech.com/Excel/Charts/ChartByControl.html

Cheers
Andy

gsimmons2005 wrote:
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?



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info