Featured Visualizations – Jan 02

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 🙂

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.

3 Responses

  1. 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

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.