I always make an org chart using individual shapes and connectors. This
makes for slightly more work, but it also provides absolute control over
each individual formatting element of each chart element.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions http://PeltierTech.com/
_______
Thanks - I did find how to resize the boxes to fit the text by selecting the
line in the organisation chart then clicking Autoformat and then holding the
mouse pointer at the edge of the box the boxes could be dragged larger.
However, it was difficult to control the connector lines. So I will follow
your suggestion and start from scratch and not use the template. - Philip