Featured Visualizations – Jan 02

Posted on January 2nd, 2009 in Cool Infographics & Data Visualizations - 3 comments

Every week Pointy Haired Dilbert celebrates visualization and info-graphics by showcasing some of the creative and fun charting work from around the web. Have inspiration and fun. Browse hundreds of fun visualization and graphics projects in archives.

New way to browse news as tree map

New way to browse news as tree map

Newsmap is a creative and fun way to look at news. They organize news items on a tree map based on recency and relevancy of the news items (that are probably pulled from Google news). The background color indicates the news topic (red for world, purple for business, green for tech etc.)

Beautiful Time line of Apple Mac in the last 25 years

Beautiful Time of Apple Mac in the last 25 years

Wired Magazine celebrates 25 years of Mac by making this beautiful timeline piling all the Macs and other gorgeous gadgets Apple made over the last quarter century and loosely arranging them in a time line fashion. You can clearly see how they have migrated from dirtyish beige color to supercool white and blacks over the last few decades. [via Cool Infographics]

Oakland Crime as Heat Maps

Oakland Crime as Heat Maps

Heat maps are a popular way to explore geographical data. Oakland Crime maps article (linked above) provides insights in to creating heatmaps using geographical data.

US Elections – Understanding the Swing Vote

US Elections - Understanding the Swing Vote

Remember Robert Kosera’s charts to understand Swing States and how they voted over the last several elections ? Well, Pedro took the same data and presented it in a different way, pretty innovative I must say. [via Simple Complexity]

Accidental Maps

Accidental Maps

We spend lots of time to create charts and graphs to make sure they don’t look like accidents. But there is whole another class of maps that are created by accident. You can see a map of Australia in the above puddle. Follow the link for more eye candy at Strange Maps

Happy weekend πŸ™‚

Written by Chandoo
Tags: , , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

3 Responses to “Featured Visualizations – Jan 02”

  1. azmat says:

    i guess i posted my query in some older topic of yours......now i am posting again in your latest topic.......hope to get reply this time:

    ok so i have rather lenghty PDF names in one column and want to extract text from right till the last \ appearing. there can be varied length and can be any no. of \ available.

    i am trying with following formulae:

    =LEFT(RIGHT(SUBSTITUTE(TRIM(B2)&"","\",REPT(" ",40)),40),40)

    it workes well for smaller names but when it goes beyond 80 or 100 char it fails...............

    plz help

  2. Chandoo says:

    @Azmat, your query is already answered here: http://chandoo.org/wp/2008/10/29/box-plots-excel-dashboards-tutorial/

    It might help you to subscribe for e-mail alerts for your comments. That way you would know when the query is answered by someone πŸ™‚

  3. azmat says:

    Thanks Chandoo..........now things are much clear to me......................

Leave a Reply