Animating Charts in PowerPoint

[chirayu]

Hi Guys,

I recently came across a request to animate charts in PowerPoint.
http://chandoo.org/forum/threads/interactive-charts-in-power-point.27101/

Shows you how to use VBA along with Option Button/ Combo Box/ Check Box to animate the charts.

Sample file & Tutorial Attached

 

[harshalcr9]

THANKS A LOT

 

[Luke M]

Thanks for sharing, Chirayu. Although you might want to take a close look at some of your coworkers...the Force is VERY strong with one of them.

File Properties:

 

[chirayu]

@Luke M yeah I changed my name on my system lol. Last month its was "It'sa me Mario!".

 

[chirayu]

Also noticed that I made a mistake in the "Check Box VBA – Show/ Hide" section where it should have said "Sheet3" instead of "Sheet2"

 

[Luke M]

@Hui do you think this is something that we could publish on the main site, assuming chirayu agrees? I know I've had people ask me about animating PowerPoint before, but I didn't think it could be done.

 

[Asheesh]

@chirayu - this is indeed awsome...

 

[chirayu]

Thanks @Asheesh

@Luke M Sure you can paste on the main site if you want. Have fixed the error I detected last time & renamed sheets to slides

 

[Luke M]

@r1c1 , possible article idea?

 

[r1c1]

Good idea Luke.. I will schedule a post on this.

 

[r1c1]

Hi @chirayu

Thanks again for this. I have scheduled the article to go live today here: http://chandoo.org/wp/2016/03/17/animated-charts-in-power-point/

 

[chirayu]

Thanks @r1c1

I read the post. Many thanks for posting to main site Just need 2 tweaks Chandoo in the "VBA code to animate the chart bit:

1) "Since Q1, Q2, Q3, Q4 buttons are in Sheet1. VBA code will be pasted in Sheet1" can we change the Sheet to Slide? makes more sense.

I know in V1 of the PDF I said sheet - my bad as I'm used to saying "Sheet" because of too much Excel VBA lol
Fixed that in V2 of the PDF - attached in prior posts of this thread

2) "To open the VBA screen Click on the Developer tab & &" one of the & needs to be removed