Animated bar 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?

[Andy Pope]

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