Cetin, I looked but did not see an Organizational Chart control in my ActiveX controls list.
>>I just created some output manually using PowerPoint that resembles an organizational chart. The output is six pages long and each page starts with a single top level node then the next level down can have anywhere from 4 to 8 levels across. From each of these sub-levels, I can have anywhere from 0 to 8 levels that all go down vertically. Each box has 3 lines of text so that output kinda looks like this:
>>
>>
>> __________________
>> | Top Level Name |
>> | Top Level Pct |
>> ----------------
>> |
>> ______________________________________________________________
>> | |
>>_______________ _______________
>>|Sub Level 1a | |Sub Level 1b |
>>|Sub Lift % | |Sub Lift % |
>>|Sub Base % | |Sub Base % |
>>--------------- ---------------
>> | |
>>_______________ _______________
>>|Sub Level 2a1| |Sub Level 2b1|
>>|Sub Lift % | |Sub Lift % |
>>|Sub Base % | |Sub Base % |
>>--------------- ---------------
>> | |
>>_______________ _______________
>>|Sub Level 3a2| |Sub level 3b2|
>>|Sub Lift % | |Sub Lift % |
>>|Sub Base % | |Sub Base % |
>>--------------- ---------------
>>
>>
>>
>>
>>I like the style of the ouput but with as many as 70 or so boxes that needed to be individually populated (per page) I need to automate the process. Anyone ever done something similar? I suppose I can try to automate PowerPoint, create SVG type output or try something else (I do not have Visio).
>
>Organizational Chart activex might help.
>Cetin