tag:blogger.com,1999:blog-7603152763857688635.post4998930496525638017..comments2023-07-23T12:42:14.354+02:00Comments on Sparklines for Excel®: Stand-alone template for XL2003Mes Courshttp://www.blogger.com/profile/09265743268811431064noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-7603152763857688635.post-82519372700311264582009-07-31T16:09:44.793+02:002009-07-31T16:09:44.793+02:00Incorporating the stand-alone template and a coupl...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?<br /><br />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...Unknownhttps://www.blogger.com/profile/13181116544852461613noreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-52643739269413442392009-07-24T21:08:59.878+02:002009-07-24T21:08:59.878+02:00In the 2003 XLA, varcharts do not seen to generate...In the 2003 XLA, varcharts do not seen to generate. Bar charts do nto balance on the zero lineUnknownhttps://www.blogger.com/profile/10583331249776227040noreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-27184722198906599562009-07-17T22:43:56.730+02:002009-07-17T22:43:56.730+02:00Great stuff. I've chnaged a line in your BarC...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.PickleFreakhttps://www.blogger.com/profile/09707530751304980371noreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-5065671225873199132009-06-30T19:00:15.042+02:002009-06-30T19:00:15.042+02:00I downloaded the sparklines3.4_2003 template but I...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.<br /><br />I'm working in Excel 2003 SP 3.<br /><br />Has anyone else encountered this problem and know of fix?Mike T.noreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-61341486377857870672009-06-22T16:42:47.467+02:002009-06-22T16:42:47.467+02:00great! thanks very much. saludos, matíasgreat! thanks very much. saludos, matíasAnonymousnoreply@blogger.com