How do I do a box and whisker plot with excel?
It is a bit like the open-high-low-close option in the stock charts but it plots 5 values (median, maximun, minimum, upper quartile and lower quartile) instead of the 4 in the open high low close graph.
The median value is shown as a line across the box determined by the upper and lower quartiles. The maximum and minimum values form the whiskers.
Any help greatly appreciated.

It is a bit like the open-high-low-close option in the stock charts but it plots 5 values (median, maximun, minimum, upper quartile and lower quartile) instead of the 4 in the open high low close graph.
The median value is shown as a line across the box determined by the upper and lower quartiles. The maximum and minimum values form the whiskers.
Any help greatly appreciated.