Worf
Well-known Member
- Joined
- Oct 30, 2011
- Messages
- 4,257
Worf submitted a new Excel article:
Organization chart with VBA - This post shows how to create an organogram with VBA.
Read more about this Excel article...
Organization chart with VBA - This post shows how to create an organogram with VBA.
- Smart art can create organization charts, but it will have formatting limitations; the code below overcomes that.
- Prepare a source table containing the following information:
- Columns A and B – the relationships between two elements. The shape fill color will come from column A.
- Column C – descriptive text to be displayed.
- Column D – auxiliary data to be placed next to the shape.
- Column E – whether the shape has an outline or not.
- Now...
Read more about this Excel article...