Org chart wizard- how do I add more than two lines of info? (phone, fax, cell, pager, email, etc.)

[KR]

The wizard only seems to let me put in my unique ID and one other field
(name, if I use Employee ID as my unique identifier). I'd like to add phone,
fax, maybe cell phone and other data so these charts can be useful reference
tools- what is the best way to do that, either through the wizard, or if
necessary, from my source excel file using VBA after the basic chart is
created?

Thanks,
Keith

 

[KR]

And after searching through all the old posts I could find related to org
charts, I'll add another related question: it sounded like someone figured
out how to add /photos/ to the org chart as well- Wow! Any hints/tips on how
to do that would be greatly appreciated as well!

Thanks!!
Keith
Visio 2003, Win2000

 

[Mike Mueller [MSFT]]

If you go through the wizard there is a page which allows you to specify
what items you want to display. It will list all the columns in your Excel
spreadsheet. Just select the the fields that you want to display from the
list on the left and click "Add". More information can be found by searching
for "Organization Chart Wizard" in Help

Visio 2003 supports adding pictures to an Organization chart shape, but not
via the wizard. To add a picture to an Org chart shape, right-click on the
shape and select "Insert Picture..."

 

[KR]

I've done some VBA in excel, but have no familiarity with the visio object
model; can you point me in the right direction to identify (via code) the
unique field info for each org chart box

for each orgchart.box in page1...
orgchart.box.image.add ("c:\photos\" & orgchart.box.UserID
& ".jpg") 'or BMP, or whatever format
next

Hopefully that will get me where I need to go via code (too many people to
do manually).

Thanks!!
Keith

 

[Mike Mueller [MSFT]]

It is not that simple.

There is a lot of code in the solution to handle adding pictures to the
shapes. The image is added to the group and a number of shapesheet cells are
added/modified. If you are very adventurous, you can probably figure out
what cells need to be changed but I can't give you a simple solution,

Sorry