Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have too much text to fit an organisation chart autoshape box. How do I
make the box larger to fit the text? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 wrote in message ... I have too much text to fit an organisation chart autoshape box. How do I make the box larger to fit the text? |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 wrote in message ... I have too much text to fit an organisation chart autoshape box. How do I make the box larger to fit the text? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do we make each row of data into its own chart? | Charts and Charting in Excel | |||
Fan charts | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Prevent non-numerical data (e.g. text) from plotting on a chart | Charts and Charting in Excel | |||
Dynamic Text in a Chart | Excel Discussion (Misc queries) |