Quick Build with the Excel Charting Utility The steps are also shown in the video at the end of this article.
#CREATING A BOXPLOT IN EXCEL 2016 MAC DOWNLOAD#
To get the details on these steps, and to download the sample file, you can visit the Create a Box Plot page on my Contextures website. Once you have the box and whisker measurements, you can build a stacked column chart from the box measurements, and hide the first box, by removing its fill colour.įor the whiskers, create a positive error bar in the upper box, and a negative error bar in the hidden box, using the values that you calculated. For example, the upper box height is Quartile 3 minus the Median. Just subtract the bottom measure from the top one, to get the height/length. The diagram below shows where each measure appears in the box plot. To build a box plot, you’ll need to do a few calculations for each set of data: Min, Quartile 1, Median, Quartile 3, and Max.įrom those calculations, you can figure out the height of each box, and the length of the whiskers.
Follow the steps below, to build this simple box plot.
Here is a link to the page Simple Box Plot in ExcelĪ box plot (box and whisker chart) lets you show how numbers are distributed in a set of data. To see the steps for building a simple box plot, from a stacked column chart and error bars, you can watch this short video tutorial. Excel doesn’t 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. A box plot (box and whisker chart) lets you show how numbers are distributed in a set of data.