Excel doesnt have a built-in chart type for a box plot, but you can create a simple box plot in Excel, using a stacked column chart, and error bars.

The diagram below shows where each measure appears in the box plot.

For example, the upper box height is Quartile 3 minus the Median.

If you need to create something more complex, and need it done quickly, you can invest in the Peltier Tech Charting Utility.

All I had to do was select a cell in my data, and click a couple of chart layout options.

You can see how the utility works in this video that I recorded.

But due to the intermediate step, I am not able to get the original values.

However, I wonder what I should do with the whiskers when using negative values.

The minimums and maximums outside the first and third quartiles are depicted with lines, which are called whiskers.

Whiskers indicate variability outside the upper and lower quartiles, and any point outside the whiskers is considered as an outlier.

And the data can be diverse that is drawn from any field for statistical analysis.

The outliers also help in identifying the reasons for the data to get outcast.

Box And Whisker Plot In Excel For Mac 15.33