How To Create Side By Side Boxplots In Excel

Select your data—either a single data series, or multiple data series.

(The data shown in the following illustration is a portion of the data used to create the sample chart shown above.)
In Excel, click Insert > Insert Statistic Chart >Box and Whisker as shown in the following illustration.
Important:In Word, Outlook, and PowerPoint, this step works a little differently:
1. On the Insert tab, in the Illustrations group, click Chart.
2. In the Insert Chart dialog box, on the All Charts tab, click Box & Whisker.

Tips:

Use the Design and Format tabs to customize the look of your chart.
If you don't see these tabs, click anywhere in the box and whisker chart to add the Chart Tools to the ribbon.

Right-click one of the boxes on the chart to select that box and then, on the shortcut menu, click Format Data Series.

In the Format Data Series pane, with Series Options selected, make the changes that you want.

(The information in the chart following the illustration can help you make your choices.)

Format Data Series task pane showing Box and Whisker chart options in Office 2016 for Windows

Series option	Description
Gap width	Controls the gap between the categories.
Show inner points	Displays the data points that lie between the lower whisker line and the upper whisker line.
Show outlier points	Displays the outlier points that lie either below the lower whisker line or above the upper whisker line.
Show mean markers	Displays the mean marker of the selected series.
Show mean line	Displays the line connecting the means of the boxes in the selected series.
Quartile Calculation	Choose a method for median calculation: Inclusive median The median is included in the calculation if N (the number of values in the data) is odd. Exclusive median The median is excluded from the calculation if N (the number of values in the data) is odd.

Select your data—either a single data series, or multiple data series.

(The data shown in the following illustration is a portion of the data used to create the sample chart shown above.)
On the ribbon, click the Insert tab, and then click (the Statistical chart icon), and select Box and Whisker.

Tips:

Use the Chart Design and Format tabs to customize the look of your chart.
If you don't see the Chart Design and Format tabs, click anywhere in the box and whisker chart to add them to the ribbon.

Click one of the boxes on the chart to select that box and then in the ribbon click Format.
Use the tools in the Format ribbon tab to make the changes that you want.