Stand-alone template for XL2003

For those who do not want to install the add-in, and share easily file using Sparklines formulas,
a stand-alone template file is available here.

Note : includes correction of missing values display in Linechart (cf Mike T comment )

5 comments:

Anonymous said...

great! thanks very much. saludos, matías

Mike T. said...

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?

PickleFreak said...

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.

not said...

In the 2003 XLA, varcharts do not seen to generate. Bar charts do nto balance on the zero line

Chris said...

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...