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

# Box and Whisker calculation

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.

• ###### 1. Re: Box and Whisker calculation

Where do you want to see 62.5% mark to be? Confused by how you want the output to look.

• ###### 2. Re: Box and Whisker calculation

Ideally, it would be below the x axis.

So:

1     2     3     5     6      7

5%  10% .........

But honestly, just calculating it anywhere would be a huge help. I could always just throw a table with the graph on a dashboard.

• ###### 3. Re: Box and Whisker calculation

I just retained your original sheet and put mine below it in a dashboard.

• ###### 4. Re: Box and Whisker calculation

You're a magician. Many thanks.