I came across this provocative infographic on FlowingData
. I made mine into a dynamic Excel chart. Here is an animated GIF of the Excel 2007 chart:
This project demonstrates the quickest formula lookup method that I know, array-entered INDEX feeding off a common MATCH. It's a simple bubble chart. All of the interactivity is accomplished by formulas. There is no VBA here.
The most frustrating data to work with is a data table embedded within an image. Unfortunately this project required doing just that with Gallup's religiosity data
. Notably missing from their data is Australia. I suspect that they would be more like the USA and less like Europe, but I could be wrong. Also it is interesting that UAE, Kuwait, Bahrain, and Singapore were left off the original infographic published in the NY Times
. All of these countries are even more of an outlier than the USA.
Here is the file.
If you haven't heard, I am gearing up to start Excel Hero Academy
, the purpose of which is to teach you how to do Excel projects like I do.
If you liked this article, please share it!