Overview

A box and whisker plot displays a five-number summary of a set of data. The five-number summary is the minimum, first quartile, median, third quartile, and maximum.

In a box plot, we draw a box from the first quartile to the third quartile. A vertical line goes through the box at the median. The whiskers go from each quartile to the minimum or maximum.

The highest point of the upper whisker is the called the upper extreme. The upper extreme value equals Q3 + 1.5 * (Q3-Q1). Outliers are points that fall outside the limits of the whiskers and will not be displayed or recognized as the max value which will be the upper extreme value..

Example

The following example query generates multiple v

SELECT AMOUNT as SUM, SOLD_ON as MONTH, ITEM
FROM ITEM_SALES

Now you will prepare your result set as shown in Data Preparation so that you have the SOLD_ON (MONTH) column sort as a month of the year and ITEM sorted within year, ascending.

Click the create a chart button to display the Create Chart dialog. Now you will select the appropriate columns to use for the chart. In this example the value will be amount and the category will be month.

After clicking Create Chart, the Box and Whisker chart will be displayed.

To "zoom in" on specific months or items sold:

click the Filter button
Select one or more category and/or legend values
Click the Apply button

The chart will now reflect the applied filters.

To remove the filter, click the Filter button and then click Remove.