Recently I stumbled across a very interesting Flash based Body Mass Index chart
at The Washington Post. I thought it would be an interesting exercise to emulate the chart in Excel. I think it really captures the essence of the original.
This Animated GIF cannot display all the colors properly and shrinking it to fit this blog, destroys the sharpness - but the animation still looks decent.
The Excel workbook demonstrates advanced Excel techniques to dynamically slice through gobs of data. The data sheet has nearly 6,000 records and watching the animation, I find myself wishing there were more years of data so that the animation would last longer!
Not only is the world getting fatter and this includes virtually every country, but women are leading the way. That's not comforting!
With the slider you can choose which country to highlight. You can choose to watch the animation at this normal speed or in slow motion.
All in all, this Excel animated business chart works well, and the Excel implementation is very instructive.
Here is the workbook:
Sophisticated chart animation is just one of literally dozens of advanced methods that my students in the inaugural class of the Excel Hero Academy
I've received dozens of messages from students telling me that the academy is the best Excel training they have ever found at any price and that it is possibly the best investment they've ever made. Wow.
This Spring I will be offering the course again. There's already 200 people on the interest list for the next class. Why not join us? Just fill the form below and I'll send you more information as we get closer!
Here's a list of other animated charts on Excel Hero:
If you liked this article, please share it!