Note : includes correction of missing values display in Linechart (cf Mike T comment )
A set of free User Defined Functions for Microsoft Excel® to create Sparklines :
the simple, intense, word-sized graphics invented by Edward Tufte & implemented by Fabrice Rimlinger.
Stand-alone template for XL2003
For those who do not want to install the add-in, and share easily file using Sparklines formulas,
Draft version of updated manual
It includes a short visual explanation of the different parameters used in the Sparklines formulas.
It does not include descriptions for Pareto(), Cascade() and Heatmap(), but these functions have not changed since previous versions.
For extra help, you can refer to the initial manual, still available here.
XL2007 and XL2003 v 3.4 add-in update online
V3.4 of the add-in for XL 2007 is available here.
V3.4 of the add-in for XL 2003 is available here. (zip)
Main enhancements :
- Icon for Horizon Chart
- Option to extrapolate gaps in linechart
- Syntax of Spreadchart has been modified (all parameters are numbers. Not text)
- For XL 2007, ribbon aspect has changed for more direct access to the "Refresh" icon
- Better handling of volatile functions (no more infinite loop while redrawing... but still one too much!)
New UserForm with possibility to :
- Activate / deactivate sparklines formulas
- Update the path of sparklines.xla (or xlam) for those who decided to install the add-in in special directory (by default : c:\program files\Sparklines)
- Delete Sparklines formulas ( but leave the charts in place)
- Delete ALL shapes on the worksheet (including controls and Excel charts)
- Delete ONLY Sparklines (without deleting controls and Excel charts)
- Refresh Sparklines
Bugs correction :
- to many to be listed here, but according to my tests, the add-in is much more stable now, and faster at refreshing the shapes.... you'll let me know
Subscribe to:
Posts (Atom)