Author Topic: Excel->Visio : Automation of a complex mapping  (Read 3977 times)

0 Members and 1 Guest are viewing this topic.

prasadtsn

  • Newbie
  • *
  • Posts: 1
Excel->Visio : Automation of a complex mapping
« on: July 09, 2013, 07:05:34 AM »
Hi Xperts,

I have an excel workbook with the following:
1) Sheet-1 : List of all unique items
2) Sheet-2 : List of all mappings (many to many) between the items (from sheet-1)
[The mapping between two items is unique however]

Example:

Sheet-1:
Table
Chair
Purse
Phone
Pen

Sheet-2:
Table Chair
Table Purse
Chair Purse
Chair Phone
Chair Pen
Purse Table
...

The value on the left in sheet-2 is a child of the value in the right of sheet-2

Any way to automatically create a chart using macro/wizard etc... ?

I tried the org chart wizard but stuck with the prob that it does not allow two parents - one child relationship.

Please help urgently.

Prasad