5 Replies Latest reply on Jul 16, 2014 2:12 PM by Aaron Clancy

    Box and Whisker calculation

    Johnny Hilgers

      All,

       

      I have been working on a particular problem for quite awhile now and have decided that it's time to look for help. I have replicated a simple example of my workbook and attached it.

       

      Problem: I have a box and whisker plot with hours of the day running along the x-axis and time running along the y-axis. I am trying to add a mark that shows what % of bullet points are below 3 minutes for each hour.

       

      Example: For hour 1, 5 of the 8 points are below 3 minutes so I would like a 62.5% mark showing there.

       

      Hopefully this makes sense. I appreciate anyone that can lend a hand.