If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function.

Add a chart title by clicking Layout tab > Chart Title > Above Chartįinally, we have created a box plot.Delete the legend and the horizontal axisįigure 20.Output: Customize boxes and whiskers for boxplot Do the same for the lower box: change fill color to Blue, Accent 1, Lighter 60% and Border Color to Blackįigure 19.Customize upper box border color for boxplot Click Border Color > Solid Line > Blackįigure 18.Customize upper box fill color for boxplot Click the upper box and change Fill Color to Blue, Accent 1, Lighter 60%įigure 17.In Format Data Series, click Fill and select No Fillįigure 16.Right-click the Hidden box (blue) and select Format Data Seriesįigure 15.Next, we customize and clean up our graph by doing the following: Output: Bottom whisker added Customize boxplot

Our box and whisker plot is now coming together.įigure 14.

Error Amount > Custom > Specify value > Negative Error Valueįigure 13.

Select the lower box, click Layout > Error Bars > More Error Bars Options In the Positive Error Value, click then select cell E13. The Custom Error Bars dialog box will appear. The Format Error Bars dialog box will appear.įigure 10. Select the upper box, click Layout > Error Bars > More Error Bars Options Output: Stacked boxes for boxplot Insert the whiskers Switch Row/Column option in Design tabįigure 8. Select cells D10:E12, click Insert tab > Column > Stacked ColumnĪ chart showing three columns will be created.Ĭlick the chart, Design tab > Switch Row/Columnįigure 6. Plot the three boxes stacked on top of each other With all the relevant values prepared, we can now create a box and whisker plot in Excel version 2016, 2013, or lower. However, it is still better to learn how to create a boxplot using only the Column Chart. In newer Excel versions 20, the box and whisker plot chart type is already available. Chart values for boxplot How to create a boxplot?

Hidden box, whose value or height is equal to Q1įigure 3.

We then compute our required data using the functions MEDIAN, QUARTILE, MIN and MAX, as shown in Column F.įrom the above data, we are able to prepare the charts that we are going to plot. Suppose we have below table of values in cells B3:B13. Maximum – the largest value in our data set.Minimum – the lowest value in our data set.Median – the middle value in our data set.These are the required data points for a box and whiskers plot : Final result: Box plot Preparing data to create a boxplot It quickly shows how our data is spread out, if it is symmetric or skewed.įigure 1. A box and whisker plot (box plot) shows data distribution in terms of median, minimum and maximum values, and the two quartiles: first and third.

How to do box plot in excel for mac