how do I make text fit an organisation chart autoshape box

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

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" <Philip [email protected]> wrote in
message news:[email protected]...
>I have too much text to fit an organisation chart autoshape box. How do I
> make the box larger to fit the text?

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

"Jon Peltier" wrote:

> 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" <Philip [email protected]> wrote in
> message news:[email protected]...
> >I have too much text to fit an organisation chart autoshape box. How do I
> > make the box larger to fit the text?
>
>
>