Advanced Microsoft® Office Documents 2007 Edition Inside Out

Creating a Visio Organization Chart from Worksheet Data

This feature is not new, but it is pretty impressive. Just type a list of names, titles, and managers in an Excel worksheet and Visio will create even the most extensive organization chart for you in a couple of clicks.

Note

Depending on your needs for an organization chart, you might want to use this feature or the new SmartArt diagrams discussed in Chapter 18. For large, intricate organization charts, Visio is the more flexible choice. But, when you create SmartArt diagrams in PowerPoint, you can convert a bulleted list to a diagram in two clicks and then add or revise diagram entries just by typing text.

Visio is also a better choice when you want to store data in diagrams or create diagrams ...