The first thing you should do is give the chart a descriptive title. Once you’ve created your box plot, it’s time to pretty it up. Next, you can modify its options to look how you want. That will net you a very basic box plot, with whiskers. On macOS, click the Statistical Chart icon, then select Box and Whisker.On Windows, click Insert > Insert Statistic Chart > Box and Whisker.

On the ribbon bar, click the Insert tab.Select your data in your Excel workbook-either a single or multiple data series.Once you’ve finished entering it, you can create and stylize your box plot. The steps below have been created using a Mac, but we also provide instructions where the steps are different on Windows.įirst, of course, you need your data. The instructions and screenshots below assume Excel for Microsoft 365. Office 365 does include box plots as an option now, but it’s somewhat buried in the Insert tab. While it was still possible to create it, it took a lot of work. In past versions of Excel, there wasn’t a chart template specific to box plots. How to Make a Box Plot in Excel for Microsoft 365 These are called “whiskers,” and the charts themselves are sometimes referred to as box and whisker charts. Sometimes, a box plot chart will have lines extending vertically up or down, showing how the data might vary outside the upper and lower quartiles. Third, or Upper, quartile: the median of the upper half of the data set’s values.First, or Lower, quartile: this is the median of the lower half of the values in the data set.Median: the middle value in the data set.Maximum value: the highest data point in the data set, excluding outliers.Minimum value: the lowest data point in the data set, excluding any outliers.The basis for a box plot is to display data based on a five-number summary. Statistical analysis uses box plot charts for everything from comparing medical trial results to contrasting different teachers’ test scores. It shows the numbers in quartiles, highlighting the mean value as well as the outliers. What Is a Box Plot?įor descriptive statistics, a box plot is one of the best ways to demonstrate how data is distributed. If you want to make a box plot in Excel, here’s what you’ll need to know (and do). The software didn’t provide a template specifically for creating box plots, but it’s much easier now.

How to plot a graph in excel windowes