Andy Kreibel certainly picked an interesting data set for this weeks #MakeoverMonday!

The original was a visualisation by Anna Vital:

Anna Vital

Anna’s viz looked a the results of a US study published in February 2017 by Indiana University, Chapman University and Claremont Graduate University. The study examined how over 30 different traits or behaviours were associated with frequency of orgasm when sexually intimate during the past month. The study also found there was a notable gap between heterosexual men and women in frequency of orgasm during sex.

Things I like about the original:

  • Good use of colour
  • Easy to understand visuals
  • Great use of BAN’s (“Big Ass Numbers”)
  • Good use of people icons

Things I dislike about the original:

  • The ordering of the different sexual orientation groups makes it difficult to compare like-for-like between genders (i.e. heterosexual men vs. heterosexual women).
  • The bed/firework icon on the graph bars is a little too busy (for my liking) and is distracting.
  • There are no details about the number of people who took part in the study or the volume of participants per group, etc.

The data set itself was small containing only three columns of data ( gender, likelihood and type (sexual orientation)). In some ways this makes it more difficult to think of something creative for a viz. I love the large datasets which allow for exploration  and fact finding but I also like the smaller datasets too as they force me to think about more interesting ways of visualising the data (rather than just a bar chart).

I immediately knew I wanted to attempt a waffle or donut chart this week. Since I used a waffle chart for my Valentines Day viz I opted for a donut chart as I haven’t created one of these in a while. Although I started my viz on Sunday night, many regulars in the community got there before me and submitted their vizzes before I had even started. One the the vizzes that caught my eye was by Pablo Sáenz d Tejada of the Information Lab/Data School. Pablo had created donut charts similar to something I had in mind:

Pablo Viz

I like how Pablo added context to his viz (something that was missing from the original), the detail in the centre of the donuts and the overall simplicity of the design.

Rather than become distracted by looking at more submissions on Twitter I got to work on my own visualisation. I decided to stick with donut charts despite Pablo’s submission (I had originally planned to use a picture of the famous Meg Ryan scene from ‘When Harry Met Sally’ but Charlie H Tableau beat me to it – pictures from that movie scene were always going to be popular this week!).

Everything was going well with my viz until I tried to show gender and the likelihood percentage on the colour shelf at the same time. Every time I tried to add a second dimension to colour it would replace the original dimension I had there. I knew it was possible as I downloaded Pablo’s workbook (in desperation) and noticed he indeed had two dimension on colour. I tried a few times (to no avail) so Googled the problem in search of a solution. Thankfully I found this online help article from Tableau which explained how it’s done:

Tableau Help - Colour

So after adding the dimension to text you can change the type of mark by clicking on the icon on the left. I never knew that!

I liked the people icons that Anna used in her original viz so I decided to add something similar to my visualisation also. I thought it was important to include more details about the survey so I included a few sentences as an introduction with further details in the tooltip of the information ‘i’. Since my viz is quite simple this week I also created a mobile-friendly version.

You can interact my final viz on Tableau Public here.

Thanks for reading.

Likelihood of Orgasm MM 2017 Wk11