tag:blogger.com,1999:blog-7603152763857688635.post2785743867767420804..comments2023-07-23T12:42:14.354+02:00Comments on Sparklines for Excel®: Treemap. How does it work ?Mes Courshttp://www.blogger.com/profile/09265743268811431064noreply@blogger.comBlogger16125tag:blogger.com,1999:blog-7603152763857688635.post-11753124893948450812014-07-20T12:43:55.836+02:002014-07-20T12:43:55.836+02:00Hi Fabrice,
A big thumbs up for your excellent add...Hi Fabrice,<br />A big thumbs up for your excellent add-in. It's great!<br />Particularly the Treemaps are such a strong visualisation tools. <br />Your Treemaps would be even closes to perfection if they would offer nesting possibility. Any chance of seeing that functionality in upcoming versions?<br /><br />Thanks again!<br />H<br /> Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-87207572488119130122013-11-07T23:28:16.177+01:002013-11-07T23:28:16.177+01:00you probably have an old version of the add-in.
Th...you probably have an old version of the add-in.<br />This known issue has been solved now.Mes Courshttps://www.blogger.com/profile/09265743268811431064noreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-7129239197387318312013-11-07T23:26:03.954+01:002013-11-07T23:26:03.954+01:00How do I keep the shape colors from having a gradi...How do I keep the shape colors from having a gradient fill? They all have the same starting gradient, which makes it difficult to distinguish the actual color of the shape.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-45216117289204600662011-09-05T23:59:00.121+02:002011-09-05T23:59:00.121+02:00I applied the treemap and can not find the option ...I applied the treemap and can not find the option or tooltiprange labelrange colorscale or not higlightposition. aplicola function when the graph goes all black. How I can make this graph with the add in?<br /><br />thank you very muchHumanidad sosteniblehttps://www.blogger.com/profile/06651165994061777833noreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-3204496194145189522011-04-24T20:27:35.834+02:002011-04-24T20:27:35.834+02:00Hi Fabrice,
I still prefer (by far) your Sparkli...Hi Fabrice, <br /><br />I still prefer (by far) your Sparklines & Family to the ones natively available in Excel 2010, excellent work!<br /><br />Is it possible to use TreeMap to display hierarchical/nested values, as in the Market Treemap at SmartMoney?<br /><br />Cheers,<br /><br />--Marioinventifhttps://www.blogger.com/profile/00002716899995498499noreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-51761942815675451182010-08-17T04:05:06.087+02:002010-08-17T04:05:06.087+02:00Very usefull and incredibly fast...
I was wonderi...Very usefull and incredibly fast...<br /><br />I was wondering if it was possible to improve it with a second level, I mean, another treemap inside each boxes...Slynoreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-82284407844210658372010-08-11T18:25:27.109+02:002010-08-11T18:25:27.109+02:00I have to say this is a great tool and you are ver...I have to say this is a great tool and you are very generous to share this with everyone. <br /><br />Just a suggestion, but an excel file with examples of use would make things easier to pick up.<br /><br />But, great work nevertheless.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-80383019870373115272010-07-01T11:01:24.594+02:002010-07-01T11:01:24.594+02:00Hello,
I'm not abble to générate the treemap w...Hello,<br />I'm not abble to générate the treemap with my own data.<br />Could you tell me how to do ?<br /><br />I try to reduce nb of line with same data and the treemap get down<br />thanksGregnoreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-2799150683201610532010-04-28T16:56:17.778+02:002010-04-28T16:56:17.778+02:00@ MutuelInvestor...
Ir depends... it is immediate ...@ MutuelInvestor...<br />Ir depends... it is immediate with 20 values. Can take 10 seconds with 500 to 1000 values.<br /><br />Rendering time also increases when adding tooltips and Hyperlinks.Mes Courshttps://www.blogger.com/profile/09265743268811431064noreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-39926148270681398922010-04-28T16:41:44.433+02:002010-04-28T16:41:44.433+02:00How long does it usually take to produce the tree ...How long does it usually take to produce the tree maps.Jim - Uber Driverhttps://www.blogger.com/profile/15365375891559209063noreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-51286933015258984862010-03-04T13:58:51.439+01:002010-03-04T13:58:51.439+01:00Hello Frabrice,
It's me again. Is it possible...Hello Frabrice,<br /><br />It's me again. Is it possible to adjust the size of the labels printed in the middle of each square. Maybe a nice addition.<br />I make a treemap on 30x40cm paper and in this case the text is printed smaller and thus harder to read than possible.Patrick Leunissenhttp://nl.linkedin.com/in/patrickleunissennoreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-70520864413582775122010-01-31T13:46:09.032+01:002010-01-31T13:46:09.032+01:00@ Patrick : This can be done with a 2 colors color...@ Patrick : This can be done with a 2 colors color scale, as shown in the following post .Mes Courshttps://www.blogger.com/profile/09265743268811431064noreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-37576074035814345732010-01-31T09:49:16.594+01:002010-01-31T09:49:16.594+01:00Hi Fabrice,
Great tool. What I would find usefull...Hi Fabrice,<br /><br />Great tool. What I would find usefull if you were able to highlight not only one row of data but several; for example the top 10 in CO2 emission in your sample<br /><br />Patrick LeunissenPatrick Leunissenhttp://nl.linkedin.com/in/patrickleunissennoreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-64104647206478923882009-12-29T22:07:15.378+01:002009-12-29T22:07:15.378+01:00@Fabrice Rimlinger : I noticed that as well! They...@Fabrice Rimlinger : I noticed that as well! They have a lot of slick applications on their website in the “Gallery”...iTunes, Digg, World Population, etc. The World Population treemap is my favorite...I never knew Monaco was so dense! <a rel="nofollow">http://www.hivegroup.com/gallery/worldpop/</a>Unknownhttps://www.blogger.com/profile/06318966093512071896noreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-44463954480249609332009-12-29T20:59:01.287+01:002009-12-29T20:59:01.287+01:00@Daniel : Excellent link to a very comprehensive t...@Daniel : Excellent link to a very comprehensive tool... BTW, Ben Shneiderman, who developed the treemap concept in 1991 is member of the board of the Hive Group <br />Maybe I could charge 10% of what they ask ? $199/user/year !Mes Courshttps://www.blogger.com/profile/09265743268811431064noreply@blogger.comtag:blogger.com,1999:blog-7603152763857688635.post-18997629979037783442009-12-29T20:03:43.483+01:002009-12-29T20:03:43.483+01:00This is a very informative article. I have fallen...This is a very informative article. I have fallen in love with treemaps as well, and continue to find more and more uses for them wherever I turn. If you’re not well versed in manipulating technical parameters (like myself) I’ve found an awesome service that automatically creates treemaps for you! It makes creating treemaps super quick. The service is available from www.hiveondemand.com and they offer a free 7 day trial!<br /><br />Happy treemapping!Unknownhttps://www.blogger.com/profile/06318966093512071896noreply@blogger.com