In the 48th session of Chandoo.org podcast, let’s make some animated charts!!!
What is in this session?
In this podcast,
- Announcements
- Why animate your charts?
- Non-VBA methods to animate charts
- Excel 2013’s built-in animation effects
- Iterative formula approach
- VBA based animation
- Cartoon film analogy
- Understanding the VBA part
- Example animated chart – Sales of a new product
- Resources and downloads for you
Listen to this session
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
Click here to download the MP3 file.
Resources for making animated charts
Example animated chart (shown in the title image):
Download example animated chart. Play with it to learn more.
More animated charts using Excel:
- Diwali flower pot cracker using animated charts
- Another Diwali animated chart in Excel
- Journey of Hurricane Sandy – Animated Chart
- 3D Dancing pendulums using Excel Charts & VBA
- Designing a clock using Excel
VBA Basics:
- Podcasts:
- Introduction to VBA – CP022
- Using FOR Loops in VBA – CP039
- Articles:
Non-VBA animation using formulas:
Animation without macros [for fun]
Transcript of this session:
Download this podcast transcript [PDF]
How do you create animated charts in Excel?
Now it’s your turn. Do you make animated charts? Please share your techniques and samples in the comments section. Wow us.
3 Responses to “CP049: Don’t do data dumps!!!”
Your title got me nervous because I'm all about data dumps, but not for attaching graphics to data dumps. My reason for using data dumps is when someone is trying to do analysis and their starting point is a report that's formatted in a way for a human to read. I instruct them to stop with the report and go get a data dump: just rows and columns and rows and columns.
Agreed, nearly all of my reports start with 100+ lines of simple table data.
That way you can build your functionality around pulling information from that tabled information.
Yes yes!