Treemapping in excel ?

[mrzoogle]

Hi All,


Is it possible to do Treemap in excel ? If yes can you kindly point me where can I learn about this please.


http://en.wikipedia.org/wiki/Treemapping


Also can you help me defining what will be a good example of hierarchical data ?


Thanks for your time.


Regards,


Z.

 

[Luke M]

Chandoo talks about treemapping here, under #7

http://chandoo.org/wp/2009/01/16/excel-pie-chart/

 

[SirJB7]

Hi, mrzoogle!


It now comes to my mind this absolutely smart and useful piece of software, in my opinion, of course.

http://www.uderzo.it/main_products/space_sniffer/


It has two little bugs when operating on a whole unid (lacks of a slash), fixed with this two registry entries:

http://dl.dropbox.com/u/60558749/Space%20Sniffer%201.1.4.0%20register%20additons%20%28by%20SirJB7%29.rar


Give it a try.


Regards!


PS: yes, I know it's not about Excel, but I like it!

 

[dan_l]

Sparklines For Excel will do it.


http://sparklines-excel.blogspot.com/

 

[mrzoogle]

Thanks and Kindest Regards to Luke M,SirJB7 & dan_I.


This have given me some serious waypoint to follow.


Sharing this very good article on treemapping with you all too.


http://www.win.tue.nl/~vanwijk/stm.pdf


More info are also very welcome too


Regards,


Z.

 

[Luke M]

Thanks for the link Z, and thanks for the feedback. =)

 

[SirJB7]

Hi, mrzoogle!

Adding to Luke M's thanks.

Regards!

 

[Montrey]

I hated these things in school. What uses are there for them in business?

 

[SirJB7]

@Montrey

Hi!

Gived a look to my first comment in this post? http://chandoo.org/forums/topic/treemapping-in-excel#post-25565

As far as I could see and evaluate if in field use, that software is amazingly useful.

Surely that's one of the uses. And if you have to deal with large disks with huge amounts of data, it saves you hours of work each time.

Regards!

PS: Despite of that, I love those graphics