Chart animation

chriscorpion786

Board Regular
Joined
Apr 3, 2011
Messages
75
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.
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,844
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,197
Messages
5,527,376
Members
409,759
Latest member
KCH

This Week's Hot Topics

Top