My assistant works with all project in various Excel and other 3rd party apps. She uses Microsoft Visio to create a Organization chart of each project to present it visually for us. The tedious part creating and maintaining the Visio Organization chart according to the changed data in the project excel and other apps (a lot data entry).
Is there a way the Visio can read excel or a text file with this data and create the Organization chart? That is, her modifying her Visio Organization chart accordingly so when the data is passed, it gets filled. As an example, Word: I can merge a document with data and create a bunch of documented - so, can we merge Visio with data?
How can that be done?