I've experimented with the Visio org chart re-layout options but I'm still not completely happy with the default shapes.
Is it possible to replace the shapes in Visio 2003's Org Chart stencil? I'd like to preserve the ability to still relayout the org chart with the new shapes and maintain some special extracting (e.g., hyperlinks, unique IDs, level names) as specified in a separate .xls that generate the org chart. A very, very wonderful EE expert helped me with the smart formulas and with this outstanding automated solution.
Ideally, I'd like to replace all Tier 1 shapes for another shape ("Big Station"), all Tier 2, 3, 4, 5 shapes ("Small Station")for another shape automatically? I need the custom properties, including the hyperlinks, to remain when swapping over.
The actual .xls file has about 1500 lines, going a total of 5 levels deep.
Any assistance is greatly appreciated. Many thanks!!!!! prototype.xls