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.
2 Responses to “Weighted Sorting in Excel ”
Just add a column calculating the "performance" or whatever is your criteria and sort by it? No?
have no patience to waste 13min. Save your time too.
Just thought I would mention, the "weird" custom sort behavior mentioned at 5:45 where "% return" doesn't appear to be sorting is because the "August Purchases" field has the sort preference and since these are such unique values, no additional sorting is possible on the "% return" field. If there were two entries that had the same "Customer Since" year AND the same "August Purchases" amount, THEN you would see a sorting of the "% return" on these two entries.