Charts of the Week [Sep 19]

Thankfully power is back in Ohio, almost 2 days ago to my house. There is another personal update: We are moving to Seattle. My consulting work in Columbus was over 2 weeks back and since then I have been waiting for the next assignment. Finally this week it became clear that we have to move to Seattle. Most of my time is spent packing, selling stuff and finalizing the travel formalities. Next week PHD will hello you all from Seattle 🙂

Back to charts of the week.

Democratic or Republic – Which books are Popular?

amazon-books-sold-democrat-republican

Amazon has put together the above graph to show last 60 day sales / favorites of red vs. blue books across various states in US. Provides good insights in to what people are reading. Apparently most states are reading RED books. [via DSA Insights]

Mess on Wall Street – Market Capitalization Erosion from Oct 2007 to Sept 2008

mess-on-wall-street-oct-2007-market-capitalizationmess-on-wall-street-sep-2008-market-capitalization

This is a square pie of 29 financial companies’ market capitalization. The left side is as of October 2007. You can see how much value is eroded in mere 11 months.

Per-capita Spending on Recreation for Each Country

Another awesome graphic by NYT, this one shows how much each country spends on various purchase categories. The one you see above is for recreation. I am not sure if the figures are adjusted based on purchasing power parity. [via Flowing Data]


More on US Elections – Article References by Obama and McCain

us-political-election-references-mccain-obama

Another election visualization. EveryMomentNow is a project to capture number of news article references by presidential candidates – McCain & Obama. This pyramid like chart is updated everyday. [via Information Aesthetics]

Your life in bubbles – All important moments in life

your-life-in-bubbles

What would you get when you create one bubble for every month of your life and then color them based on important events in your life ? The one you are seeing above is cartoon like visualization of 931 months of life and colors mark achievements made in that month by famous people. So in a way it is a visualization of life data of several famous people like Ayn Rand, Einstein etc. [via Information Aesthetics]

That is all. Browse archives for more eye candy.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst
Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

One Response

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.