home page
Questions? E-mail us or call us 302-584-1771, 8AM to 10PM U.S. East Coast Time 7 days a week

View Cart

US $29.95

Add to shopping cart


Money back

Box and Whisker Plot Creator
An add-in product for Microsoft Excel

Download a trial version now!

  • Menu driven for ease of use
  • Create quartile, percentile, or statistical box and whisker plots
  • hide or show data points
  • show 1-3 sigma bars on your plots
  • Plot from multiple different worksheets or workbooks on the same box and whisker plot

Screen shots:

The Box and Whisker Plot Creator add-in for Microsoft Excel makes it easy to create box and whisker plots.  It is compatible with Microsoft Excel 2010-2021 and Office 365.

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

Quartile box and whisker plot
Statistical box and whisker plot
line chart   panel chart

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 of the gray to the left represents the first quartile, or 25% of the points. The points outside and to the right represents 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:

  • hide or show all the data points
  • hide or show the sigma bars
  • Show only outlier data points (those outside a 1.5 sigma range)

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::

  • create quartile, percentile or statistical box and whisker plots
  • select multiple ranges of data from different worksheets and workbooks for the same box and whisker plot
  • hide or show all data points or show outliers only
  • set whiskers for the data range or for a 1.5 sigma range
  • show 1 sigma to 3 sigma bars (or none) on the statistical box and whisker plot.


Order online from our secure service.
Get delivery in minutes!

Add to shopping cart

  US $29.95

Customers who viewed the Box and Whisker Plot Creator also viewed:

Copyright 2024 LLC, all rights reserved.  Spreadsheet Assistant is a registered trademark of LLC.