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
No quote