Data Viz Done Right

July 23, 2016

The Data School Gym - Slope Graphs with Vertical Lines

9 comments

It’s my birthday, so what else would I be doing other than practicing Tableau and having a cold beer? I’m working on a project (more to come in a couple months) and needed a way to create vertical lines in slope graphs that are based on dimensions.

So here’s your challenge. Given this data set of fruit sales by region, build this slope graph. If you can’t access the data, email me and I’ll send it to you.


Some formatting tips:

  • I used Avenir Next Condensed for the font - 18pt title, 12pt in the chart.
  • The decreasing value is highlighted with color #E15759 and the increasing values are using #A5ACAF.

This was a fun little challenge for me. You’ll likely either get it immediately or get stuck. Upload your answer to Tableau Public and leave a link in the comments. Have fun! I need to get back to my Punk IPA.

9 comments :

  1. Happy Birthday from @CharlieHTableau! I always struggle with these, but got closer than with the Eurovision challenge. I couldn't suss out the vertical dotted lines but will optimistically regard that as minor formatting. I wrestled with the labelling too - I *think* you probably just nest a combination of Fruit and Region in the calcs, but when I did that I lost the Slope and ended up with just dots. Enjoy your beer and I look forward to seeing the solution.

    https://public.tableau.com/profile/publish/DataGymSlope/Dashboard1#!/publish-confirm

    ReplyDelete
  2. Struggling with Vertical lines. I think it is based on a placeholder column (Maybe 0)

    http://imgur.com/a/PZcmu

    ReplyDelete
    Replies
    1. Like Charlie, you are struggling with the part that led me to create the challenge. Here's a hint, think about how you can get Tableau to draw a vertical line. And it's not via annotations.

      Delete
  3. Hmmm, I got the lines, but feel I cheated a little on the highlighting. Also couldn't get the highlighted line to sit above the non highlighted lines despite rearranging on the colour card. Good challenge though!
    https://public.tableau.com/profile/peter8354#!/vizhome/DSChallenge3/DSGymChallenge

    ReplyDelete
    Replies
    1. Great work Petie! You figured out the hard part.

      Delete
  4. This was fun! I got pretty far using the measure values and names cards, but can't figure out how to get the dotted line up the middle, so I'm thinking I might have done it differently? Also - does the highlight have to be LOD or did I overthink that?

    https://public.tableau.com/profile/patiekaige#!/vizhome/DSGRegionalFruitSales/RegionalFruitSales

    ReplyDelete
    Replies
    1. Close Katie! The highlighting is not LOD. Not calcs at all actually. I'll post the solution tomorrow.

      Delete
  5. Just started reading your blog. I very much enjoy your work, keep up the good work.

    https://public.tableau.com/profile/stephen.dziatkiewicz#!/vizhome/FruitSales_2/FruitSales

    ReplyDelete