Chart animation

[chriscorpion786]

Dear ALL,

Ive been a fan of Mr. Excel ever since i came to know about him.
I would like to know if there is any tutorial or training or how to do....out there or can anyone help for chart animation using vba.
The example is on one of the sites of Excel hero...the column chart changes to area chart and vice versa through animation.
How in the world is this done? Can Mr. Excel help please.....

From an Excel crazy fan....who is having sleepless nights figuring out how to do this stuff?????

Mustafa.

 

[pgc01]

Hi Mustafa
Welcome to the board

You have to use vba to do it. Check the OnTime() method of the Application object.

The process is very simple. A procedure will run for ex. every 5 seconds and will change the chart type.

You have to know vba if you want to do it.