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.
great! thanks very much. saludos, matías
I downloaded the sparklines3.4_2003 template but I've encountered a problem. In drawing a line chart with missing values in the series, the chart takes a long time and never really draws. I set the gap style to 0 so the gaps are noted.I'm working in Excel 2003 SP 3.Has anyone else encountered this problem and know of fix?
Great stuff. I've chnaged a line in your BarChart class to be able to handle "mini > 0" values. Normally this would expand the chart into lower cells on the spreadhseet, which is not desirable. I edited the class to set "sngHeight = (sng - sngMin) * sngIntv". This seems to fix the issue.
In the 2003 XLA, varcharts do not seen to generate. Bar charts do nto balance on the zero line
Incorporating the stand-alone template and a couple dozen line graphs into a report of mine causes the file size to balloon from 200KB to over 1.2MB. Is there an easy way to trim out unused routines to help keep things minimal?I need the stand-alone file because my particular report uses Microsoft Query to dynamically pull in information from an external database, and I need to be able to regenerate the line graphs as data changes...
Post a Comment