how do I make text fit an organisation chart autoshape box

[Philip Runacres]

I have too much text to fit an organisation chart autoshape box. How do I
make the box larger to fit the text?

 

[Jon Peltier]

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/
_______

 

[Philip Runacres]

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