I just posted a new release for Excel 2003 here.
This version includes logarithmic horizontal scales (required for the OECD file of my previous post).
It also brings some changes on Nixnut last statistical functions : StripeChart and SpreadChart used to analyze a population distribution.
It solves a clipboard issue (the clipboard was erased whenever the "Sparklines" menu was re-created).
I hope you will find those improvement helpful.
In the future I will post some samples on how to use the function, individually or organized within a dashboard.
5 comments:
Re: the log scale...
Aren't you glad now that I suggested it?
=) Nixnut should be glad.
Your suggestion gives an excellent opportunity to use the sparkline function he wrote some weeks ago.
Although it is very powerfull, I still believe that the non-scientifics reader do not perceive the message as fast as when using a linear scale...
Thanks indeed for your input Jon !
i cant' copy some range to new workbook if this addin is enabled(unless the new workbook is saved first). Still, this is module is very fascinating.
the idea to show examples about dashboard design using Sparklinesforxl is very good!
This add-in is ingenious, I've been looking for something like it for sometime. Keep making it better.
Post a Comment