June 22, 2016

The Data School Gym - Conditional Formatting a Slope Graph

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:

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.

The fonts for the countries in black is 11pt while the font for the grey countries is 8pt.

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.

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.

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)?