Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm preparing for an Ignite talk and need to figure out how to animate an Excel chart, which will eventually go inside a PowerPoint. I would like to animate the following into a single chart/slide.

Part 1

Chart 1

Part 2

Chart 2

Part 3

Chart 3

As you can see, the y-axis scale changes so animating the y-axis from one step to another is what I need.

Additionally, if it could be made so that the space for all the categories is already defined but remains invisible until triggered, causing the y-axis to scale to fit the new data point, it would be ideal. Example:

E.g. ideal starting point

I have searched online but haven't found a decent easy to follow tutorial that will allow me to do this. I am using Excel and PowerPoint 2010. Any help anyone can provide will be much appreciated.

share|improve this question
    
Thanks Gareth for changing the urls to images! –  Kamal May 2 '11 at 21:51
add comment

1 Answer 1

up vote 4 down vote accepted

I can think of two possibilities:

  1. Create the Parts as individual charts in excel, copy the images into powerpoint, and use powerpoint animation to advance the images

  2. If you really want to do it in excel, write VBA macros to modify a single chart as required for each Part, and use Application.OnTime to fire the macros at the required interval.

share|improve this answer
    
Hi Chris, thanks for your input. After trying macros for a while, I decided to go with your first suggestion. It isn't quite what I wanted but I think it would be better to spend time on the content of my presentation than the fancy animations inside it. –  Kamal May 4 '11 at 22:32
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.