fbpx

Cool infographics around the web – [july 31]

Share

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Time for another round of cool charting / info-graphic ideas around the web.

Most Popular Baby Names – all the way from 1880

baby names trend from 1880 - most popular names of all

Nametrends is a cool website totally dedicated to analyzing and showing baby name trends. They have pretty interesting stuff like, how baby names ending with -lie (charlie, willie, ellie etc.) fared from 1880. Go ahead, see the neat stuff at nametrends. [via kottke]

Flare toolkit for visualizing in Flash

Flare toolkit for visualizing data

Flare is a powerful tool for visualizing large amounts of data using Action Script. Check it out. [via FlowingData]

Funny map of online communities

Funny map of online communities - XKCD

This cartoonish visualization from XKCD pokes fun at the sizes and boundaries of various online communities. Really hilarious and neatly done. [via cool infographics]

Visualizing design process

Visualizing design process

This is a non-linear info graphic that talks about how designers approach problems. The site >think>draw>make is a dedicated to visualizations of design processes. See it. [via cool infographics]

What info is hidden in a bar code?

What is in a barcode?

This pretty visualization of bar codes uses information contained in the black stripes to generate Bezier curves (ahem!) that look like a tree, hence the name bar-code plantation 🙂 [via swissmiss]

Also see:

Have any visualizations, graphs or cool charting ideas and want them featured here? Drop a comment.

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Share this tip with your colleagues

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

Chandoo is an awesome teacher
5/5

– Jason

Excel formula list - 100+ examples and howto guide for you

100 Excel Formulas List

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

20 Excel Templates

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

Extract words from sentence using FILTERXML - formula tip

#awesome trick – Extract word by position using FILTERXML()

This is CRAZY!!!. I stumbled on a weird use for FILTERXML() while reading a forum post earlier today. So I couldn’t wait to test it. I am happy to share the results.

Say you have some text (sentence / phrase / keyword etc.) in a cell and you want to extract the nth word. Unfortunately Excel doesn’t have SPLIT() formula. So we end up writing obscenely long array formulas or use gazillion helper columns.

Here is the super sneaky trick. Use FILTERXML() instead.

Leave a Reply