Box and Whisker Plot Creator

The Box and Whisker Plot Creator add-in for Microsoft Excel makes it easy to create box and whisker plots.

The following illustrates such charts created by the Box and Whisker Plot Creator. The charts may be horizontal or vertical:

The first box and whisker plot above is a quartile plot. The gray area is where one expects 50% of the points to be. The points outside the gray to the left represent the first quartile, or 25% of the points. The points outside and to the right represent the remaining 25%. The center blue bar is the median. The average is plotted as a white diamond. The smaller blue bars are the 1.5 sigma points.

The second box and whisker plot is a statistical plot. The gray area in this case is the 3 sigma range. One can set the range to be 1, 2, or 3 sigma. The center blue bar in the second box and whisker plot is the average (as it is a statistical plot). The three smaller sets of blue bars represent the 1, 2, and 3 sigma points.

On both plots one can:

One can also create a percentile box and whisker plot. This is like the quartile box and whisker plot, except one can set the percentile for the gray area from 0% to 100%. So, if one wanted to show where 90% of the points appear, one would use this versus the quartile style box and whisker plot.

With the Box and Whisker Plot Creator, one can: