Excel and Visio: Generating Diagrams Automatically

Learn how to create Visio diagrams automatically from your Excel data. Follow along with Visio MVP Scott Helmers as he shows how to leverage Data Visualizer, a Visio feature that automates the creation of Visio diagrams. You supply the Excel data and Visio does the rest. Scott begins the course by demonstrating how to locate the Excel Data Visualizer templates—whether you're working in Visio or Excel—and use them to create flowcharts and swimlane diagrams. He demonstrates that the resulting diagrams are linked to the data so that changes to one are synchronized to the other. He then shows how to build your own data source, create other types of diagrams, and package data and a diagram into a template package that can be shared with other people.

Topics include
Creating a flowchart from data
Creating a swimlane diagram from data
Working with the built-in Excel Data Visualizer templates
Synchronizing diagram changes with data and vice versa
Enhancing diagrams with graphics and themes
Creating other types of process diagrams
Creating a diagram template package