BeanPlots available

A new version of SfE is online for download, on time for Xmas (Excel 2207 and 2010 only so far).
Few changes except that BeanPlot() is available in the Distribution menu.

This function requires only one mandatory parameter : Serie1, which is the range of data you want to visualize.
The 2nd parameter, Bins, represents the number of "slices" you want to divide the data into.

For large datasets, Bins=10 works nice. As you will play with it, you'll find out that the calculation time increases dramatically with a higher number of bins.

The list of parameters is as follow :

    Mandatory Serie1 As Variant
    Optional Bins As Integer
    Optional ScaleStart As Variant
    Optional ScaleEnd As Variant
    Optional Vertical As Boolean
    Optional HighlightValue As Variant
    Optional ShowMedian As Boolean
    Optional ColorScheme1 As Long
    Optional Serie2 As Variant
    Optional ColorScheme2 As Long 

So far the 2 last parameters related to a second serie of data are not used.

Downloads :

• Excel 2007/2010 Add-in (.xlam) 
• Excel 2007/2010 Template (.xlmt)
• Example file (.xlsx)

Happy Xmas !