VizWiz

Launch, grow, and unlock your career in data

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. Trevor JohnsonJune 22, 2016 at 5:44 PM

    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. VizWizJune 22, 2016 at 7:30 PM

      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. Trevor JohnsonJune 23, 2016 at 12:08 AM

      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. VizWizJune 23, 2016 at 7:29 AM

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

      Delete
  2. AnonymousJune 23, 2016 at 11:26 AM

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

    Finally!

    ReplyDelete
  3. UnknownJune 23, 2016 at 11:24 PM

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

    ReplyDelete
    Replies
    1. VizWizJune 23, 2016 at 11:29 PM

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

      Delete
  4. UnknownJune 24, 2016 at 2:11 AM

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

    ReplyDelete
  5. UnknownJune 24, 2016 at 2:12 AM

    By the way which fonts you used now in Tableau 10

    ReplyDelete
  6. UnknownJune 24, 2016 at 3:11 AM

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

    ReplyDelete
  7. ViggyJune 24, 2016 at 9:08 AM

    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. VizWizJune 24, 2016 at 10:18 AM

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

    ReplyDelete

Subscribe to: Post Comments ( Atom )