Still moving...

Here goes a quick copy of SfE log of modifications I have been working on lately.

Just to let you know tht despite of the latest "3 month Home Revolution" (sell the house in Paris, get baby twins, move down to southern France (incl. 2 temporary location) and now desperatly looking for a house... not mentionning tons of diapers), I still find some time, in airplanes to work on SfE.

'11/03/2010 - Reactivated Turnmytrappingon in ThisWorkbook module
'11/03/2010 - LineChart : add Tag =8 and 9 for open or close tag
'29/04/2010 - Boxplot includes new parameter "HighlightValue" + "ShowMedian" by Art Steinmetz
'29/04/2010 - StripeChart includes new parameter "HighlightValue" + "ShowMedian" by Art Steinmetz
'06/05/2010 - Pareto if Label = 1 --> show cumulated % if label=2 --> show individual %
'06/05/2010 - Heatmap, if color code left empty, use background color of "color" cells from colorscale range
'12/05/2010 - Add ColorRange to Barchart ---> each bar can have a specific color - based on code by Ramesh
'12/05/2010 - Add possibility to use background color of cell for Barchart. Cell must be empty or non numeric
'14/05/2010 - Reviewed legend display for CascadeChart
'17/05/2010 - Added BumpChart UDF


BumpChart() is coming

Although I had very little time lately for playing w/ SfE, I managed to create a new little UDF, not to display in-cell charts, but to link cells this time.

Bump Charts have been extensively discussed (here, here and here) and shows very good examples of how they could be used to describe ranking evolutions over time.

This new function has the following parameters :
- InitialPositionsRange - Range of initial positions (Mandatory)
- FinalPositionsRange - Range of final positions (Mandatory)
- NameHighlight- Name you want to highlight (Optional)
- PositionHighlight - Initial position you want to highlight (Optional)
- ColorUp - Color for values which final position is higher than initial (Optional)
- ColorDown - Color for values which final position is lower than initial (Optional)
- ColorHighlight - Color for the highlighted line (Optional)

Here is the final result with default colors and only the 3 first parameters (one UDF for each couple of Start/End data) :

Columns with intermediary position can be hidden for a smoother and more compact view :