Create a Treemap in Excel using VBA

Hi There, The project is about creating a treemap in Ms Excel 2003. The Treemap should be created with a user defined function. See attachement for the details. Best Regards Maarten ## Deliverables | Hi There, | | | | The project is about creating a Treemap in Ms Excel 2003. The Treemap should be created by a user defined function. The following link describes how Treemaps work. | | <[login to view URL]> | | | | There is a Treemap add in from Microsoft, it works perfectly but the export is not flexible as it comes to Visualization. | | <[login to view URL]> | | | | An example how is should look like is at the following location : | | <[login to view URL]> | | Within this add-in vba is accessible to see how it works. | | | | The Treemap should be generated in Excel using Microsoft Shapes or Positioned Gif images generated within Excel. Input comes from a worksheet in Excel. The Treemap should be static, so zooming functionality is not required. | | | | When the project is completed and stable it will be posted in the Sparklines-excel.blogspot. I don't have problems with naming the programmers name. Furthermore the solution will be used for personal benefits. | | | | The programmer should have at least 3 years of experience in Vba coding. | | Recursive programming techniques are required. Furthermore code should be efficient, structured and commented. | | | | Other ideas / additions for this project are welcome. Should you have any question please feel free to ask. | | | | Best Regards | | | | Maarten |