Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Philip Runacres
 
Posts: n/a
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default how do I make text fit an organisation chart autoshape box

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   Report Post  
Posted to microsoft.public.excel.charting
Philip Runacres
 
Posts: n/a
Default how do I make text fit an organisation chart autoshape box

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do we make each row of data into its own chart? MGalbreth Charts and Charting in Excel 3 July 1st 05 05:44 PM
Fan charts Dean Charts and Charting in Excel 7 May 30th 05 11:51 AM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Prevent non-numerical data (e.g. text) from plotting on a chart jaweiss Charts and Charting in Excel 1 March 19th 05 05:54 PM
Dynamic Text in a Chart hlsr2003 Excel Discussion (Misc queries) 1 February 10th 05 12:43 AM


All times are GMT +1. The time now is 09:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"