How to add dotted line to org chart from Ms.Excel?

[hungta]

Hi there,

I created organization chart from information that’s already stored in
Ms.Excel. It works well.
Now I would like to add some dotted lines into org char. For example, Mr. A
reports to Mr. B directly , I am going to illustrate by solid line and Mr. A
also reports to Mr.C , I would like to display by dotted line. Any ideas?

Appreciated your help.

 

[Mike Mueller [MSFT]]

The Visio 2003 Organization Chart solution supports dotted-line reporting
but only in the graphic interface. There is no mechanism in the Wizard for
expressing this relationship.

Sorry.

 

[hungta]

Thanks for your clarification, Mike. Can we create marco to solve this
requirement?
Thanks

 

[David Parker [Visio MVP]]

You can -

You will need to use
1. Master.Drop to create the Dotted-line reports shape
2. iterate thru' the page shapes to find the shapes that have the
..Cells("Prop.Name").ResultStr("") you require
3. get references to the .Cells("PinX") for either end
4. Cell.GlueTo method to connect the line betwen the 2 cells

I have assumed that you want dynamic glue....

 

[hungta]

Thanks David. It would be grateful if you have an sample marco of creating
dotted line.

We have another problem. We tried to have the org. chart that can display 1
box of position with more than 1 holders listed in the box. We have list of
positions with personnel number in excel file. The position ID is in 1st
column. E.g.

Position ID Personnel Number
147 84001
147 84002

But the visio does not allow us to show 1 box of position with 2 persons.
There's a message of duplication.

Do you have any suggestion?

And if we change the format in excel file to be

Personnel Number Position ID
84001 147
84002 147

Will visio show us as we require. Or will it separate this into 2 boxes (2
persons). But this way is not the way we require.


Thank you in advance for your support.

 

[Mike Mueller [MSFT]]

The organization chart solution uses an internal model that enforces one
person/position per shape. If your hierarchy is defined by position numbers
rather than names, then it is possible to display multiple names in a shape
because the shape text is derived from one or more custom properties.

The Organization Chart *Wizard* assumes one Excel row per position. I am not
sure what will happen if you have more than one row associated with the same
position, but I am pretty sure that the result will not be what you want.
Your best bet would be to list all the people associated with a position in
the "Personnel number" field and use that field as the shape text.

Hope this helps