This video explains how to create a flowchart using the Visio linked data wizard, pulling the data from Microsoft Excel into a Visio flowchart diagram. The video also explains how to import data from Microsoft Project in to a Visio timeline diagram. The tutorial covers how to edit data graphics in Microsoft Visio and how to update linked data using the refresh option.

Contact

The course details for the topics covered in this video can be found at http://www.itseasy.co.uk/courses/visio-training/ online courses can be found at http://www.itseasytraining.co.uk

Importing Data

The process to import data from other programs is quite simple in Microsoft Visio, you can use the import wizard or select the link option on the timeline tab for Microsoft Project for example. The video uses the Timeline diagram and selects data from a Microsoft project file. The resulting Timeline is a bit cluttered and extra effort is required to sort out the labelling and positioning of the tasks however, the end product looks great.

Visio Linked Data

If you have used the Visio linked data option, the process as shown in the video, proceed as follows: Select the shape type you require and then select the linked field dragging it into position on the diagram. You can update data in the source files which will be refreshed when selected in the Visio diagram. You can add additional shapes and connections to enhance your diagram that don’t have to be linked to a source file.

Data Graphics

The video explains how to edit linked data in the data graphics feature. The graphics can be moved deleted or added to through the wizard. If you remove the data graphic you will still be able to type in the shape boxes and format them as normal. The linked data will appear in the Shape Data window if it is active.

Advertisements