Auto draw from excel file

[CaseyLee]

I have searched around without finding an answer so hopefully someone here can point me in the right direction.  I'm trying to automatically build a binary diagram from an excel file which shows in column A, a name, column B, another name, and column C, left or right side indicator of column B. Each name has a right side and a left side so the final is likely to look like a pyramid.  Any assistance would be awesome.

[wapperdude]

Not enough info...term binary diagram is too generic.  What's the relationship between the columns and the rows?  Have a simple example???

Wapperdude

[wapperdude]

Is this a school assignment?

Wapperdude

[CaseyLee]

Example here, http://www.geeksforgeeks.org/wp-content/uploads/forkPuzzle.jpg. Not for school, I'm just trying to teach myself as much as I can about visio and this is something I could use in practice.  The name in column A & B will be unique identifiers, and column C will only be Left or Right.

Ex: Cell a2 will be john, b2 & c2 will be blank, but cell a3 will be CaseyLee, b3 will be john, and c3 will be Left, cell a4 will be Kim, b4 CaseyLee, c4 Left.

[aledlund]

You might check out the orgchart wizard format (a standard hierarchy). Their are several discussions on drawing these including one on david parkers site
http://blog.bvisual.net/2009/02/24/creating-an-org-chart-without-the-org-chart-wizard/

hth,
al Edlund

[CaseyLee]

thank you I'll check it out and post back if I can get it to work.  Thank you.