Makeover Monday Week 10 – International Women’s Day

This week’s data set came from the Equal Measures 2030 and was themed in honour of international women’s day.  It showed policymakers from different countries estimating statistics concerning women and girls in their own country.

What works well

  • The reference line and actual value makes it easy to see how many data points are close to the correct answer

What could be improved

  • It’s not immediately obvious that each mark represents a policymaker
  • Correct answer for Maternal mortality rate is quoted as a percentage (over 100%), it’s normally given as number of moralities per 100,000 births
  • If the correct answer is given as a percentage then I think the axis should be in percentages too.
  • It seems like the reference line isn’t centred within the reference band.

What I did (1st Attempt)

  • I focused on showing one graph at a time and using parameters to switch country and statistic.
  • I elaborated a bit in the title to make it clear what the graph was showing
  • I used colour to show the difference between policymakers who claimed they knew the statistic and those who had guessed.
  • I used a jitter plot instead of sorting the policymakers in any way because x-axis conveys no information (and I wanted to learn how to do a jitter plot)
  • Excluded maternal mortality rates for the time being, as I need to think of a way to include it while the other statistics are all given as percentages.

What I did (Second Attempt)

Wasn’t entirely happy with my first attempt, so I spent an hour or so making improvements.

  • Played around the formatting so it doesn’t look so weird now
  • Scrapped one of the filters and displayed country data side by side, to allow for some comparison
  • Tried to re-add maternal mortality rate.  In the end I had to add a second parameter that would filter out the main sheet and swap in a sheet specific to maternal mortality rate.  It’s not an ideal solution but it’s the best I could come up with in an hour.