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.
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.
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...
5 comments:
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