Visualizing Sex & Love – 10 Infographics You Must See

Share

Facebook
Twitter
LinkedIn

Dont think of me as a perverted spreadsheet user, I like visualizations in any form or shape. There is so much data even about human relationships like love and sex. This article shows 10 of the most visually beautiful and insightful of the infographics on sex and love.

Click on the titles above images to see the detailed site. The links are mostly safe for work, so enjoy the Friday 🙂

1. Charting the Dating Data – Dizzia’s Dates

sex-life-of-dizzia

What happens when you take all your dating data and plot it on a calendar by using icons for what happened during each relationship? Dizzia got curious and did just that. This is an awesome visualization with lot of wit and simplicity. You can quickly tell how long each relationship lasted and what they have done.

2. How does Love look like?

emotion-love-how-it-looks-and-feels

Ever wondered how the emotion Love actually looks? What happens when you try to plot love? Emotionally Vague has conducted surveys on people to find out the color, words, body parts associated with love and plotted this information in the above seen beautiful info-graphic. Very pretty and insightful.

3. Personal sex data goes web2.0 – Bed Posted

bed-post-sex-life-activity-monitor

Have you ever wondered how your sex life is progressing? Not in an emotional way, but in the way like tracking monthly budget? BedPosted promises to give you insights into your sex life. Whenever you log in just feed little data about your intimate activities to this site and leave it to come up visualizations like one seen above. Another fun way to look at your data.

4. What to say during sex – Flow chart of things to say

things-to-say-during-xxx-flowchart

This is a funny flow chart of things to say during xxx. Easy to understand and fun to read.

5. What do we search for – Love or Sex? – Google Search Insights

google-search-insights-love-vs-sex

I like the google search insights because they work like a dashboard by providing all critical info in one place. This one works the same way. Looks like the S word beats L word here. The google search insights shows us that when it comes to love western part of the world is searching more for it where as for sex, it is the eastern part which is searching more. Also, the S searches outnumber L searches thrice.

6. What are people loving right now – Twitter tweets on Love

twistori-love-tweets

Twistori is more like a social experiment, a window through which you see how humanity (the tweeting kind) is feeling. The above shows a snapshot of what people love. It is a simple text visualization that is pretty to watch.

7. What is the right size?

authentic-size-preferences-chart

The above is a very good example of partition chart in which spatial trends are meaningful. It shows preferences of several women plotted to reveal where the pleasure is. Okay, enough detail, I leave it to you to interpret.

8. [NSFW] Who does it most? – Durex sexual well being survey 2007

who-does-it-most-2008-durex-survey

[NSFW] Durex sexual well being survey is an annual affair in which they reveal trends across the globe. I believe it is part of their business continuity plans. The above shown is a map visualization of sexual frequency across globe. You can see who is busy.

9. [NSFW] Fleshmap – Touching Preferences

fleshmap-desire-sorting-nsfw

Fleshmap [NSFW], which is featured here earlier, is an incredibly cool way to plot intimate data. They have gathered data about touching, looking and listening and plotted it in several creative ways. The site is full of insights. But do not browse from work as some of the charts are pretty graphic.

10. [NSFW] Playboy Centerfold Images – How they have looked from 1960 to 1990

playboy-centerfolds-1960-1990

This is clever visualization and art work. Jason Salavon took centerfold images from all the playboy magazines between 1960 and 1990 and scanned these images. Then he normalized the data to create the above images. Even though it doesn’t mean anything on the outset, when you know how the image is generated you would marvel at the thought of it.

Bonus: Viagra sales cartoon

Viagra Sales - funny cartoon archive at funnytimes.com

This is as funny as graphs can get.

Like these visualizations? Why don’t you browse some of the coolest visualizations featured here earlier.

Have a great weekend 🙂

Via: FlowingData, Information Aesthetics, BuzzFeed

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.

26 Responses to “FIFA Worldcup Excel Spreadsheets [Roundup]”

  1. J. J. says:

    Nice roundup! Do you know of any one-page spreadsheets which will be updated by an administrator after each game? Would be nice to be able to print out the latest results whenever I feel like checking them as I probably won't be following closely every day.

    I actually haven't tried any of the above ones yet, but I thought I'd mention this one that I found which makes a nice one-page form you can fill in dynamically. http://exceltemplate.net/sports/world-cup-2010-schedule-and-scoresheet/

  2. Diego Garcia says:

    I would like to recommend you these one: http://www.anotagol.com/
    You can choose your interface language (english, spanish, italian, portuguese, german or french) and your country for the timezone of match. I like it very much.

  3. [...] Passend zu gerade laufenden Fußball-WM gibt es auf Chandoo.org alles wissenswerte über Excel-Anwendungen für den Fußball-Fan. [...]

  4. Rohit1409 says:

    Great!!!

    I strongly recommend this :

    http://www.en.excel-soccer-2010.de/downloads

    Chandoo how you found this ...

  5. Chandoo says:

    @Rohit.. really beautiful file. I missed it during my research. Now, I recommend it. 🙂

  6. Mourad Louha says:

    Hi Chandoo - thanks for the recommandation 🙂 - Regards

  7. [...] Excel, then print it on the other side of your Match Schedule from step 2 above. There are several other Excel spreadsheet templates you can download, but this is probably the only one-page version you can find; plus, it [...]

  8. Robert says:

    Does anybody know how to re-create this(?): http://www.marca.com/deporte/futbol/mundial/sudafrica-2010/calendario-english.html
    ...or do you know where a template can be found? I am DYING to have something like this on my site. When I found it, I had been looking for the longest time for a circular calendar. I found a couple that weren't adequate. Then I stumbled upon this one and my eyes nearly popped out of my head. If anyone can lead me in the right direction, I would be eternally grateful!

    Thanks in advance!
    Robert

  9. Chandoo says:

    @Robert...

    Doing something like that is a lot of work. You can probably get it done with some hired help from a flash developer.

  10. Pedro Wave says:

    @Robert, the World Cup flash in the Spanish Marca newspaper is impresive, but not much as my own animated spreadsheet with the Goals of 2010 World Cup South Africa in Excel that I just published into my blog:
    http://pedrowave.blogspot.com/2010/06/goals-of-2010-world-cup-south-africa-in.html

    Download from here:
    http://cid-6b219f16da7128e3.office.live.com/view.aspx/.Public/Goals%20South%20Africa%20Animated.xlsx

    And start to enter the goals of the rest of matches.

  11. Neil says:

    Has anyone seen, or made, a Spreadsheet where you can record the scorers and see a 'top scorers' chart. Would be a nice enhancement

  12. Chandoo says:

    @Neil... checkout this one http://www.inflexionary.com/sports/world-cup-2010-excel

    it uses macros to fetch scores from web (and provides very comprehensive analysis too)

    @All.. Thanks for the comments. I have updated the post with few more links now.

  13. Sergio Mathias says:

    Hi,
    Check this dashboards too:
    http://dashboards.org/world-cup-dashboards-and-visualizations/
    😉

  14. [...] Here is a collection of FIFA World Cup Spreadsheets if you are more in to that sort of thing. | [...]

  15. [...] Cup fever is here!In FIFA Worldcup Excel Spreadsheets Roundup, Chandoo has some links to useful World Cup tracking workbooks. Only one of them (the first one) [...]

  16. [...] World Cup fever is here!In FIFA Worldcup Excel Spreadsheets Roundup, Chandoo has some links to useful World Cup tracking workbooks. Only one of them (the first one) [...]

  17. Hey, you missed ours! It has everything you need and more, but not a whole pile of silly extras (National Anthems, etc).  I'll be making another one for the 2014 world cup.  We had over 4000 hits on it!

  18. Neil says:

    @Michael Harwood.

    Where is it then? You should have posted a link  

  19. phillip says:

    Sie sollten an einem Wettbewerb teil zu nehmen für einen der besten Blogs im Web. Ich werde empfehlen Sie diese Seite!
    Google translation: You should take part in a contest for one of the best blogs on the web. I will recommend this site!

  20. [...] and welcome to the forum, Maybe these similar spreadsheets might give you a few initial ideas: FIFA Worldcup Excel Spreadsheets [Roundup] | Chandoo.org - Learn Microsoft Excel Online If you have specific areas / formulae / layout choices for parts of your spreadsheet that you are [...]

  21. Petros says:

    Calling all football fans around the globe! The biggest football festival will kick off on the 12th June 2014 and everyone is placing their bets of who will have the honour of lifting the golden trophy.

    Use our free interactive Excel templatel to predict the World cup finalists ! No macros !

    http://www.spreadsheet1.com/world-cup-2014-free-excel-prediction-template.html

  22. marten says:

    I also made a Worldcup-tracker, with MS Access, which can also generate reports in Excel
    e.g. a match-schedule with locations on y-axis and dates on x-axis, see:
    http://worktimesheet2014.blogspot.com.es/2014/05/excel-with-match-schedule-for-2014-fifa.html
    and:
    http://worktimesheet2014.blogspot.com.es/2014/05/match-access-app-to-track-world-cup.html

  23. Vivek Ranjan says:

    where can i find raw data in excel file format of fifa world cups (1930-2014)

Leave a Reply