Nixnut is using XL-2000. He is very knowledgeable about statistics, and rewrote some (big) parts of the code.
Here is Nixnut last XL-2000 version of Sparklines for Excel.
This release bring some new charts :
StripeChart : It shows a vertical marker line for each value in the range and optionally a taller red line for the average mean. The result is a graph with the distribution of the values in the range.
SpreadChart : A lot like the StripeChart except it shows the frequency distribution of the values in the range in one of three styles: stacked (default), spread or jittered.
It uses dots for the data points.
XBoxPlot (Extended Boxplots). A bit experimental. These boxplots take a range as input and calculate values for whiskers, hatch marks, boxes and outliers as necessary.
There are different classes of boxplots: Tukey (default), 5NS (five number summary), 7NS (seven number summary), and Bowley.
There are also two styles: Classic (default) and Neo. The Neo style shows bars instead of whiskers.
Visible enhancements of existing functions : Invisible enhancements :
- Improved "Redraw" and "Delete" routines.
- Version number not included in file name, for easier upgrade.
A great deal of very useful Sparklines, dense, self explanatory and easy to embed in dashboards.
This new version is not documented yet...
Well, it seems that I will have to catch up with the XL2003 version... any volunteer for XL2007 ?