Mekko charts in Excel 2007
 

On Thursday, January 27, 2011 10:57:24 AM UTC-6, KAY wrote:
This thread is mirrored over at pcreview.co.uk forums.http://www.pcreview..co.uk/forums/me...2769.htmlUnder the username of 67L48, I have uploaded an Excel 2010 file that can generate a 15x15 mekko (such as 15 markets and 15 companies). Hope it works for you. Sometimes, when I first run the macro, it churns for quite a long time (almost like it's broken into an infinite loop). I think it's because I'm a poor programmer and my code is cumbersome. May also have to do with initialization of certain routines into computer RAM, as subsequent mekko generation is quick Submitted via EggHeadCafe SQL Operations on a Text File with ADO.NET http://www.eggheadcafe.com/tutorials...th-adonet.aspx

Hi Kay,
Is there any way to extend the file that you posted (15x15) to (15*100). ie 100 rows. I know that seems like a lot but it would work perfectly for what im trying to do. This would be a huge help!