Data Viz Done Right

June 22, 2016

The Data School Gym - Conditional Formatting a Slope Graph

12 comments

I absolutely love this visualisation by FiveThirtyEight. It’s clean, uses minimal color, and is overall nice to look at.


So naturally I wanted to see if I could recreate this in Tableau, but more specifically Tableau 10. Here’s your challenge, reproduce my viz below. Post a link to your image in the comments or Tweet it to me. Download the TDE here or the Excel file here.

Here are some tips:

  1. Use Tableau 10 so that you can use the new Tableau fonts. Or just use the font of your choice if you don’t have Tableau 10.
  2. The fonts for the countries in black is 11pt while the font for the grey countries is 8pt.
  3. If you’re using Tableau 10, using groups in calculation will come in mighty handy!



And if you’re looking to do a bit more, here’s another version that only highlights the countries that would have an increased score. This one doesn’t require groups, but could certainly be done that way if you choose.


Good luck! Go smash it!

12 comments :

  1. Here's my stab at it. I couldn't figure out how to get the ranks to post on either side or change the size of the fonts, but I think I got the rest:

    http://pasteboard.co/1SreUnEj.png

    ReplyDelete
    Replies
    1. Nice work Trevor. The parts you struggled with are exactly why I created the exercise. Keep an eye on the comments for the solution. Keep trying if you have more time. Think about how you could separate the groups of countries.

      Delete
    2. Got it! Your post convinced me to join the Tableau 10 beta.

      That was trickier than I initially thought:

      http://pasteboard.co/1SQkDPyI.png

      Delete
    3. 99% of the way there. Looks like you need to vertically center align the labels.

      Delete
  2. http://i.imgur.com/GoxwbfW.png

    Finally!

    ReplyDelete
  3. Dear Sir Andy, Please look at my maiden effort at ..... http://imgur.com/NkeLwQb

    ReplyDelete
    Replies
    1. Very close but not perfect. Are you labels aligned correctly?

      Delete
  4. I put vertical center but this labeling is bit tricky I think.... please upload your version...

    ReplyDelete
  5. By the way which fonts you used now in Tableau 10

    ReplyDelete
  6. Sir another attempt at : https://public.tableau.com/profile/arshad.malik#!/vizhome/EurovisionRanking/Dashboard1

    ReplyDelete
  7. Hi, I'm new to Tableau and loving to use it. I'm trying to build this, but I couldn't as i'm still on initial stage of learning.
    how did you move Measure names (old system, New system) to Top? And How did you add labels at one line end it shows (country, measure value) and on other line end it shows (Measure value, country)?

    ReplyDelete
  8. Solutions
    How to Video - https://youtu.be/yGDv84wtDGs
    Tableau Workbook - https://1drv.ms/u/s!AhZVJtXF2-tD0WxeJwLUKV8dUGYd

    ReplyDelete