I have created an organizational chart in Visio from data in an Excel spreadsheet. I have one problem and one annoyance.
The problem is with updating the org chart when changes are made in the spreadsheet. At present I create a new org chart on a new page by doing the import again every time the data changes and delete the original chart.
The annoyance is that I have items 3 through 10 reporting to item 2. The line goes 10, 3, 4, 5