tag:blogger.com,1999:blog-7603152763857688635.post277953155932691551..comments2023-07-23T12:42:14.354+02:00Comments on Sparklines for Excel®: How LineChart deals with missing values (in template file)Mes Courshttp://www.blogger.com/profile/09265743268811431064noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-7603152763857688635.post-52890118245267223372009-10-27T03:33:37.539+01:002009-10-27T03:33:37.539+01:00CAN YOU POST THE LATEST XL 2007 VERSION TO THE BO...CAN YOU POST THE LATEST XL 2007 VERSION TO THE BOXNET SITE. SOURCE FORGE IS EMPTYJimhttps://www.blogger.com/profile/09562089400637803366noreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-11094285698759858072009-09-13T20:43:40.023+02:002009-09-13T20:43:40.023+02:00Fabrice,
I found that excel stops responding if t...Fabrice,<br /><br />I found that excel stops responding if the gapstyle parameter is not set. I made the demonstration in one file with linechart parametered with gapstyle and without. Deleting one data made the well parametered charts responding well and when it cale to updating one without gapstyle, it went to calculations without ending...<br />However it is set like optional, it seems that in case of missing values, the soft is lost (I haven't checked in the code)Sebastiennoreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-12816022946960114602009-09-08T17:06:16.784+02:002009-09-08T17:06:16.784+02:00Fabrice,
Excellent utility for Excel. I am also h...Fabrice,<br />Excellent utility for Excel. I am also having problems with line charts when the data is arranged horizontally. Missing data causes Excel 2007 to stop responding. It also occurs if I have non-numeric data.mattjhttps://www.blogger.com/profile/05532899509096532143noreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-42374028369922495592009-09-01T19:47:38.675+02:002009-09-01T19:47:38.675+02:00Thanks Fabrice - I just sent you an email detailin...Thanks Fabrice - I just sent you an email detailing the issues I see - let me know if you don't get it. Your example does work for me as well - when the data is arranged vertically. All my problems happen when referencing data arranged horizontally.Unknownhttps://www.blogger.com/profile/12755138691299009153noreply@blogger.com