Worf
Well-known Member
- Joined
- Oct 30, 2011
- Messages
- 4,261
Worf submitted a new Excel article:
Organization Chart with VBA – Part 5 - This version can manage a member with multiple parents.
Read more about this Excel article...
Organization Chart with VBA – Part 5 - This version can manage a member with multiple parents.
The Microsoft smart art engine has some limitations, including lack of support for headless charts and several parents for the same person. The following code overcomes these deficiencies. Here is how to use it:
- Type the relationship table at the original sheet. Note that additional data from the final sheet is used to build the chart.
- Run the preparation routine, which will position the elements vertically. A dummy top and additional dummies are inserted, if necessary, because...
Read more about this Excel article...