Love Chandoo.org? Here is a chance to get our most awesome courses on discount.
Checkout our 2016 Holiday SALE. Hurry up, SALE ends this Friday.

All articles in 'Office Tips' Category

How to create animated charts in Power Point [VBA]

Published on Mar 17, 2016 in Charts and Graphs, Office Tips
How to create animated charts in Power Point [VBA]

This is a guest post by Chirayu, a member of Chandoo.org forum.

Animating Charts in PowerPoint cannot be done without the help of 3rd party software’s that create a flash file of the chart & embed it into the presentation.

However there is a workaround for this. Save your chart as multiple images & insert them (overlapping on top of each other). Use VBA on Developer tab Controls such as Combo Box, Option Button, Check Box etc. to “Bring To Front”” the corresponding image. Thus giving the illusion of an Animated Chart in PowerPoint.

This guide will teach you how to animate the charts, using the three Developer tab Controls that were mentioned before. The code & functionality only works in Slide Show Mode. File must be saved as PowerPoint Macro-Enabled Presentation (*.pptm)

Continue »

How to Change Shapes in Microsoft Office 2007

Published on Feb 25, 2009 in Excel Howtos, Office Tips
How to Change Shapes in Microsoft Office 2007

Ever since we made a switch to Microsoft Office 2007 at work, this has been bothering me.”How to change one shape to another?”

This is very useful feature, especially when you are using PowerPoint.

Continue »