Data Viz Done Right

May 17, 2017

Workout Wednesday: Comparing Regions

7 comments
Today at The Data School we took on Emma's Workout Wednesday challenge as a group, brainstorming along the way until we came up with a solution. We decided to take on Jeffrey's challenge for a bit more complexity.

Here are the requirements from Emma:

  • Dashboard size is 850x650
  • Quantity for the East and West regions should display as side-by-side bars
  • Sales for the East and West regions should be displayed as lines
  • Filtered to 2015 only
  • Match the colours and tooltips
  • Match the axis labels (abbreviated months)

We didn't find this too difficult. A simple calculation put the bars side-by-side. I'm going to ask Emma to be more harsh. :-)

7 comments :

  1. Hi Andy
    I totally understand why you've reproduced this chart, but alongside that I am really interested in your opinion on the value of it?
    Is it really the best way to display this data? What story is easily discernible?
    Many thanks indeed
    Andy

    ReplyDelete
    Replies
    1. That's not the point of the exercise. You'll find many Workout Wednesday vizzes aren't the best way to display the data, but the purpose of to challenge people.

      Delete
    2. Understood. Thank you.

      Delete
  2. This comment has been removed by the author.

    ReplyDelete
  3. Found the issue, I need to switch off Stack Marks , to keep the bar side by side.

    ReplyDelete
  4. hi,
    can't figure out how to put the bar char side by side. what is the magic?

    ReplyDelete
    Replies
    1. Have you downloaded the workbook to see how I did it?

      Delete