A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Visio
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how can i get multiple names in one box in org chart visio 2003?



 
 
Thread Tools Display Modes
  #1  
Old March 10th, 2010, 02:48 AM posted to microsoft.public.visio.general
banana peel
external usenet poster
 
Posts: 1
Default how can i get multiple names in one box in org chart visio 2003?

how can i get multiple names in one box in an org chart in Visio 2003 when
using an excel spreadsheet as the data source?
For example, there are 5 doctors and 7 nurses, all reporting to Manager.
Rather than listing all 12 individually which is what the wizard does, how
can they be shown in the same box as their colleagues? eg. one box containg
all the nurses, and another box with the doctors, then these 2 boxes
reporting to the Manager.
Ads
  #2  
Old March 14th, 2010, 12:23 PM posted to microsoft.public.visio.general
gigster99
external usenet poster
 
Posts: 15
Default how can i get multiple names in one box in org chart visio 2003?

If you have completely described what you want, the best way to do this is
use the standard objects (not org chart) and draw what you want. OrgChart
does not easily do what you want.

If you feel you want to use OrgChart, then you will need to put the data in,
say, excel and associate the rows with the specific OrgChart object. First,
build the org chart the way you want it to look. DO NOT use the default Name
and Title fields. INstead, drag the specific rows from the ExternalData
window to the Org object. You can then customize the layout of the data as
displayed in the Org object

"banana peel" wrote:

how can i get multiple names in one box in an org chart in Visio 2003 when
using an excel spreadsheet as the data source?
For example, there are 5 doctors and 7 nurses, all reporting to Manager.
Rather than listing all 12 individually which is what the wizard does, how
can they be shown in the same box as their colleagues? eg. one box containg
all the nurses, and another box with the doctors, then these 2 boxes
reporting to the Manager.

  #3  
Old March 16th, 2010, 04:44 PM posted to microsoft.public.visio.general
WapperDude
external usenet poster
 
Posts: 589
Default how can i get multiple names in one box in org chart visio 200

Actually, having multiple names via Excel and the Wizard is fairly easy.
Assuming you have an importable Excel file, go to the cell that has the name
of your Dr. Put the cursor at the end of the name, press "Alt" + "Enter".
Type the next name. Continue for the remaining names. Excel will enter each
name on a new line is the same cell.

Now, save and import into Visio. You may have to resize the shape to have
the names fit within the box.

HTH
Wapperdude

"gigster99" wrote:

If you have completely described what you want, the best way to do this is
use the standard objects (not org chart) and draw what you want. OrgChart
does not easily do what you want.

If you feel you want to use OrgChart, then you will need to put the data in,
say, excel and associate the rows with the specific OrgChart object. First,
build the org chart the way you want it to look. DO NOT use the default Name
and Title fields. INstead, drag the specific rows from the ExternalData
window to the Org object. You can then customize the layout of the data as
displayed in the Org object

"banana peel" wrote:

how can i get multiple names in one box in an org chart in Visio 2003 when
using an excel spreadsheet as the data source?
For example, there are 5 doctors and 7 nurses, all reporting to Manager.
Rather than listing all 12 individually which is what the wizard does, how
can they be shown in the same box as their colleagues? eg. one box containg
all the nurses, and another box with the doctors, then these 2 boxes
reporting to the Manager.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:40 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.