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.
6 Responses to “Using Lookup Formulas with Excel Tables [Video]”
H1 !
this is my very first comment.
Can you use same technique with Excel 2003 lists ?
thanks 😀
Thanks, Chandoo! I like seeing the sneak peak of what's to come on Friday too 🙂
@Damian.. Welcome to chandoo.org. Thanks for the comments.
Yes, you can use the same with Excel 2003 lists too.
@Tom.. You have seen future and its awesome.. isnt it?
[…] Using Tables – Video 1, Video 2 […]
[…] Using Tables – Video 1, Video 2 […]
Hi, is there a vlookup formula for the second example (IDlist)? I used a similar formula to look up the ID for the person, but the reverse way (look up the person with the ID) comes up N/A.