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 !

Additional chart in SfE : BeanPlot()

Currently working on a new type of chart : Beanplot()

It´s an enhanced version of Boxplot.
Boxplots gives a quick view about the structure of a univariate dataset, but remains a black box when it comes to provide clear information about the detailed distribution of this data.

The BeanPlot shows a mirrored estimated density of the distribution, specially usefull to identify multimodal distribution as shown in the picture above (1st serie of data).

This paper provides a good description of Beanplots principles : http://goo.gl/svK8F

And here is the first screenshot of SfE's Beanplot() UDF in progress.... stay tuned.

64 bits version updated

The Office 2010-64 bits version is now at the same stage as the 32 bits version, including GanttChart.

Here is the change-log :


'24/06/2010 - Corrected FunctionWizard behavior for some functions (wrong counting of letters in formula) in SpraklinesSheetActions
'30/06/2010 - Modified Boxplot so Points can be entered not only as a Range but also as an Array {1;2;3}
'24/07/2010 - Added control for negative values in BulletChart & RevBulletchart
'24/07/2010 - Corrected call for DrawTarget in BulletChart & RevBulletchart
'13/08/2010 - Added in StackedChart : If Points.Cells(i).Value = 0 Then TextLabel = ""
'13/08/2010 - Added Targets to Barchart, possibility to add target value for each bar value
'17/09/2010 - Added VerticalFlip parameter to LineChart
'14/10/2010 - Changed FontSize algorithm in Treemap, to maintain visual hierachy (does not work OK)
'21/10/2010 - Piechart : If Val(Application.Version) >= 12, in order to handle properly piecharts in XL2010 (Version = 14)
'04/01/2011 - Assign Ctrl+Alt+F5 & Ctrl+Alt+F6 to display / hide Sparklines menu
'04/01/2011 - as default in Xl2007 template file, Sparklines menu will be hidden
'05/01/2011 - Modified text size algorithm in Treemap()
'07/01/2011 - Changed scaleXY to scalexy (low caps) as it erased existing formula
'08/05/2011 - Changed Barchart Target behavior (Thicker and smaller tick)
'08/05/2011 - Changed refresh routine --> call procedure DrawCharts
'21/09/2011 - Modified Heatmat so it works w/ merged cells
'26/09/2011 - Added label, tooltip and hyperlink to Heatmap
'27/10/2011 - Created GanttChart

The file is available here : http://www.box.net/shared/3rm3nbkiqn

GanttChart() available

I have uploaded the last version of the add-in that includes the GanttChart() function.
A new icon is included in the "Composition" group

At this time GanttChart() is only available for Excel 2007+2010 in the usual sparklines.xlam file.

I also uploaded a sample file so you can play with and report some bugs ... ;-)

Link to the add-in : http://www.box.net/shared/yqf4u9evib
Link to the sample file : http://www.box.net/shared/sxl6zog5k7zha0dhnhxa

Looking forward for some feedback...

Gantt Chart on its way

Just finished to put together a new UDF : GanttChart.

Pretty straight forward, this function displays tooltips when hovering over a task.

I am finishing some testing before uploading the new version SfE.

Here are the parameters for this function, only the first 4 are mandatory

ProjectStart As Date

ProjectEnd As Date

TaskStart As Date

TaskEnd As Date

TaskColor As String
TaskHyperlink As String
TaskTooltip As String
TaskCompletion As Double
CompletionLabel As Boolean
Today As Date
TodayColor As String
Deadline1 As Date
Deadline1Color As String
Deadline2 As Date
Deadline2Color As String
Deadline3 As Date
Deadline3Color As String
HitDate As Date
HitSymbol As Integer
HitColor As String