B
Bob Ford
Hello
I have pulled a sample code from the newsgroups on creating the org chart
wizard from an excel data source.
But need additional help. Using VBA:
1) is it possible to programmatically change the org chart shapes?
2) how do i create the dotted connector from the CEO to Admin Assistant?
3) how to change the layout to side-by-side?
4) on my sample dataset, I need to create an org chart by country and
product.
The user will be given the choice to create the org chart by how many
product they selected (up to five, via a listbox)
How can I organize the org chart - say the user selected all 5 products,I
will have one page for each country and under each country, the product1 to
product5 will show up from left to right?
In USA, Product1 = there will be 10 people
Product2 = there will be 40 people
Product3 = there will be 50 people
Product4 = there will be 20 people
Product5 = there will be 35 people
(of course over time, this will change due to new hires and turnaround of
employees)
5) when changing the round corners from the Format - Line option, this seems
to only work for the connectors but the bot the shape themselves. Is this
possible to adjust?
I would appreciate any help.
Many thanks!
Bob
I have pulled a sample code from the newsgroups on creating the org chart
wizard from an excel data source.
But need additional help. Using VBA:
1) is it possible to programmatically change the org chart shapes?
2) how do i create the dotted connector from the CEO to Admin Assistant?
3) how to change the layout to side-by-side?
4) on my sample dataset, I need to create an org chart by country and
product.
The user will be given the choice to create the org chart by how many
product they selected (up to five, via a listbox)
How can I organize the org chart - say the user selected all 5 products,I
will have one page for each country and under each country, the product1 to
product5 will show up from left to right?
In USA, Product1 = there will be 10 people
Product2 = there will be 40 people
Product3 = there will be 50 people
Product4 = there will be 20 people
Product5 = there will be 35 people
(of course over time, this will change due to new hires and turnaround of
employees)
5) when changing the round corners from the Format - Line option, this seems
to only work for the connectors but the bot the shape themselves. Is this
possible to adjust?
I would appreciate any help.
Many thanks!
Bob