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.