Question: how to do a box plot excel?
Answer: Step 1: Calculate the quartile values. First you need to calculate the minimum, maximum and median values, as well as the first and third quartiles, from the data set. ... 
Step 2: Calculate quartile differences. ... 
Step 3: Create a stacked column chart. ... 
Step 4: Convert the stacked column chart to the box plot style.