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 :
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEim8ldxOInXFhTG0D_JikaBZMwRHc_0t6zp3wFAPpDqpALGtzNNQUC8kl-gSYsF9uwGAn7VfvM-lE1H693QGbJ6_OxvPvVR2S1mga-cKVGBrsNO5C4c4aB1fI_SGxzAOZvPIN25EFyDWp8N/s200/Stripechart001.png)
SpreadChart :
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjcKpRGkMtLRH_pwOhZkfBZIxgmmDK2hWlBFv9yoDMFpfi5irqafyNpEH4j_FsfF9vuXzPMPPoxU7llO8Dcx9HuaHsqZB927nT0QI_b9bYpd48iserlbFgYvEonqFks3TWNe4anQ9bkjapy/s200/spreadchart001.png)
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 ?
No comments:
Post a Comment