Box and whisker plot in excel

For detailed method:
https://www.dummies.com/education/math/statistics/box-and-whisker-charts-for-excel/


Some bullet points:

Calculate

• min
• q1
• median
• q3
• max

of each data column for which a box plot is desired

Then calculate

1. q1-min 
2. q1
3. median-q1
4. q3-median
5. max-q3

Select calculated values 2, 3 and 4 for each data column and insert stacked column chart

To add whiskers, select lower half of each stacked column, select error bars, select minus, cap, choose custom, for -ve error value select all q1-minimum values
Then select the upper bars, select error bars, plus, cap, custom, for +ve value specify max-q3 values
Hide the lower bars using formatting options and you are done.