We now show how to manually produce the box plot when one or more data elements are negative. This is true of the manual approach described above as well as for the box plot produced by the data analysis tool in the Real Statistics Resource Pack. Thus if R1 ranges from -10 to 20, the range in the chart will range from 0 to 30. When a data set has a negative value, the y-axis will be shifted upward by –MIN(R1) where R1 is the data range containing the data. The approach described above works perfectly for non-negative data. Remove the legend by selecting Layout > Labels|Legend > None.įigure 3 – Box Plot Approach with Negative Data.the last row of the table you created above, in the dialog box that appears (in the Positive Error Values field). On the resulting dialog box (Vertical Error Bars menu), click on the Plus and Custom radio buttons and then click on the Specify Value button. Click on the Q3-Med data series (the uppermost one) and choose Layout > Analysis|Error Bars > More Error Bar Options.On the resulting dialog box (Vertical Error Bars menu), click on the Minus and Percentage radio buttons and insert a percentage error of 100%.

With the Q1-Min data series still selected, choose Layout > Analysis|Error Bars > More Error Bar Options.

Alternatively right-click on the Q1-Min data series and press Ctl-Y. right-click on the Q1-Min data series and select Format Data Series… > Fill|No fill.

Repeat the previous steps for the lowest visible data series (i.e.

This is done by right-clicking on any of the three Min data series boxes in the chart and selecting Format Data Series… On the resulting dialog box, choose Fill|No fill. Min) and set fill to No fill (and if necessary set border color to No Line) to remove the lowest boxes.

Select the lowest data series in the chart (i.e.

Select Design > Data|Switch Row/Column if necessary so that the x-axis represents the brands.

Select Insert > Charts|Column > Stacked Column.Notice that the headings are included on the range, but not the last row. Once you have constructed the table, you can create the corresponding box plot as follows: Figure 2 – Box Plot table formulas Procedure

Incert boxplot in excel 2016