12 Replies Latest reply on Feb 26, 2016 5:58 AM by Jonathan Drummey

    Educational Brain Teaser: Coloring the Boxes on Box and Whisker Plots

    Jonathan Drummey

      The answer for this brain teaser has been posted in the comments below: Re: Educational Brain Teaser: Coloring the Boxes on Box and Whisker Plots

       

      Here's a new brain teaser for you, like my previous one Educational Brain Teaser: Headers Down Below on Grouped Bar Chart it's drawn from a forum thread: color coding the box plots.

       

      The problem is that there's only one color scheme for all the boxes in a given box plot:

       

      Screen Shot 2015-04-18 at 7.59.28 AM.PNG

       

      The goal is to end up with a view like this, where the boxes are colored like the underlying marks:

       

      Screen Shot 2015-04-18 at 8.00.08 AM.PNG

       

      Can you build a single-worksheet view that duplicates the above?

       

      A starter workbook is attached. I'll add the solution I came up with on or after Monday, 27 April, though if you want to peek you can see what I came up with in the link above. Please add a comment below (without spoilers, please) with how difficult you found this, ranking from 1 (easy) to 5 (extremely difficult or impossible).