tag:blogger.com,1999:blog-7603152763857688635.post6576566543356874250..comments2023-07-23T12:42:14.354+02:00Comments on Sparklines for Excel®: Still moving...Mes Courshttp://www.blogger.com/profile/09265743268811431064noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-7603152763857688635.post-35682604592053707922013-07-23T21:09:02.530+02:002013-07-23T21:09:02.530+02:00Is there a way to share a workbook with dynamicall...Is there a way to share a workbook with dynamically changing sparkline graphs with multiple users who do not have the sparkline add-in? Thanks! Unknownhttps://www.blogger.com/profile/07204704466427595161noreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-8115691453956430602010-08-25T00:03:32.610+02:002010-08-25T00:03:32.610+02:00Great work.
One suggestion. I used a the line spar...Great work.<br />One suggestion. I used a the line spark and some values were clear outliers and chart became flat with one spike. If I could specify a upper/lower bound (i.e +/- 100%) the outliners would go away.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-88266263377275751262010-07-27T10:00:28.696+02:002010-07-27T10:00:28.696+02:00Hi Fabrice,
This is really nice stuff!
I often ...Hi Fabrice, <br /><br />This is really nice stuff!<br /><br />I often make times series line charts that contain upper and lower boundaries for each individual point, but I always end up constructing them as combination charts using the excel charting engine. I touched briefly upon the subject with Robert from Clearly and Simply in conjunction with his article: http://www.clearlyandsimply.com/clearly_and_simply/2009/03/you-cant-start-a-fire-without-a-spark-2.html <br /><br />I guess what I am asking is this: For the LineChart, would it be an idea to treat MinZone and MaxZone as Ranges? <br /><br />Thanks for a great application, UlrikUlrik Willemoesnoreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-4338329781901656592010-06-22T20:35:19.982+02:002010-06-22T20:35:19.982+02:00This stuff is great. Thank you.
I prefer to read ...This stuff is great. Thank you.<br /><br />I prefer to read my Left and Right ScaleXY charts with the numbers in standard orientation. This helps them fit in normal Excel cells also.<br /><br />Suggested Code Tweaks for DrawScaleXY()<br /><br />1. Remove This Code, 3 times, under the If Vertical sections.<br /><br />TextShp.TextFrame.Orientation = msoTextOrientationUpward<br /><br />2. Under Case "r" and Case "l" change alignment. Example for TextLeft:<br /><br />Case "l"<br /> .TextFrame.HorizontalAlignment = xlHAlignRight<br /> .TextFrame.VerticalAlignment = xlVAlignBottomMichael Dekkerhttps://www.blogger.com/profile/09432692163050186388noreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-10696546704052627092010-05-20T05:44:00.455+02:002010-05-20T05:44:00.455+02:00Great Work as ever - bump charts look nice, like t...Great Work as ever - bump charts look nice, like the new tags for line..Alex Kerinhttp://www.datadrivenconsulting.comnoreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-45724898788344360312010-05-19T09:12:57.530+02:002010-05-19T09:12:57.530+02:00Hi Oliver,
go to www.hichert.com they have an add...Hi Oliver,<br /><br />go to www.hichert.com they have an add-in for multiple charts, but it was to difficult for me.<br />Other add-in is think-cell.But not for free.<br /><br />ciao<br />ÖzkanUnknownhttps://www.blogger.com/profile/08208019757751868423noreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-67552860057321746042010-05-17T19:38:33.243+02:002010-05-17T19:38:33.243+02:00Excelent Fabrice.
have you thought on including s...Excelent Fabrice.<br /><br />have you thought on including small multiple charts or trellis charts? (something like <br />http://blog.axc.net/wp-content/uploads/2009/03/smallmult.png )<br /><br />I know I can use excel to create each little chart next to the other but if we had an utility to create a the whole set of charts it would be awesome.Oliverhttps://www.blogger.com/profile/08579912256974393606noreply@blogger.com