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 2003, Excel 2007, Excel 2010 and Excel 2013.

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

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.

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

• Bubble Chart Creator - Quickly and easily create bubble charts from data tables
• Cascade Chart Creator - Create cascade charts that help you explain your data.
• Sensitivity Chart Creator - Easily create sensitivity or tornado charts.
• Waterfall Chart Creator - Create charts that compare quantity or volume to unit rates such as price/unit or profit per unit.

View Cart US $29.95

Quantity
Discounts

Order online
Immediate
delivery

Money back
guarantee