Entity Organizational Chart

[sjcameron83@yahoo.com]

Good morning everyone!

I am trying to put together an entity organizational chart. I've created and save my shapes, started my Excel spreadsheet to feed into Visio but I'm running into an issue with entities that have multiple owners/parent entities. I'm getting a prompt that I cannot have duplicate entries (one company has multiple owners so that company is listed a number of times in my spreadsheet). Is there a way to use Visio with an Excel spreadsheet feeding the data into it?  I've watched a lot of videos trying to figure out the best way to do this but seem to keep coming up with one reason or another that it won't work.

I'd prefer to not manual prepare a chart and just be able to update the spreadsheet and have that update charts going forward.

Thank you for any help!  I really appreciate it.

Samantha