Would you like to automatically create a detailed, polished Visio flowchart from an Excel workbook? You can do this by using the Data Visualizer templates. Each template has an associated Excel workbook used to convert process data into a flowchart in Visio. Once you create the flow chart, you can add, edit, or delete rows in Excel, and then refresh the diagram from Visio. You can even add additional columns of data in Excel that are converted to Visio shape data. Data Visualizer is supported in Visio 2016 (16.0.7967.2030 or higher).
The ability to use the Data Visualizer templates is only available with Visio Pro for Office 365. If you're not sure what version of Visio you're using, select File > Account > About Visio. See Visio Pro for Office 365 to learn more about the subscription version of Visio. Currently this feature is only available to Insiders at this time.
Note: In order to use this feature, you must have an Office 365 subscription. If you are an Office 365 subscriber, make sure you have the latest version of Office. If you are an IT professional managing the Office 365 update process, check out the channel releases page to learn which updates are provided in each channel.
In this article
Create a Data Visualizer diagram
Before you begin
Gather your ideas and work them out in a draft form on paper or by inking. This rough draft can help you jump-start your work and make the following steps go smoother.
To create a Data Visualizer diagram, you can work simultaneously in Excel and Visio. You might find it easier to work in two windows on your Windows device or in a multi-monitor environment. Visually comparing your work between Excel and Visio helps confirm you are doing what you intend to do.
Stage 1: Choose a Data Visualizer template
Select File > New, under TEMPLATES , select Flowchart, and then select Basic Flowchart - Data Visualizer or Cross Functional Flowchart - Data Visualizer.
Stage 2: Create an Excel workbook
In the template preview, select Excel data template.
Select File > Save, specify your computer or a network server location, enter a file name, and then select Save.
To add a new worksheet, at the bottom of the workbook, select New sheet .
Create an Excel table. For more information on using Excel tables, see Overview of Excel tables, Create or delete an Excel table, and Resize a table by adding or removing rows and columns.
Add columns and rows to the table which are used to create the Visio diagram. There are specific requirements for the Excel table column headers and values. Use the section, How Excel columns interact with Visio flowchart components as a visual guide.
Stage 3: Add additional shape data to the Excel table (optional)
Examine the Process Map tab in the Excel template. The columns in the Excel table are colored blue and green. The color provides a visual clue about the difference between the columns.
The blue columns are used to create the flowchart in the Visio diagram. All columns are also added as shape data.
To add additional shape data, add one or more columns to your Excel table.
The green columns indicate additional shape data you can add to each shape. You can add any number of additional columns. By default, this data is not visible in the diagram, unless you add data graphics. To see the shape data in the Visio diagram, select Data > Shape Data Window. For more information about shape data and data graphics, see Add data to shapes and Data graphics, an overview.
Stage 4: Create a Visio diagram with the wizard
Switch back to Visio, in the template preview select your unit of measurement, and then select Create.
In the first page of the Create Diagram from Data wizard, do the following:
Under What diagram do you want to create from data, select a template: Basic Flowchart, Cross Functional Flow Chart (horizontal), or Cross Functional Flow Chart (vertical).
Under Select the Excel workbook, select a workbook from a list of most recently used workbooks, or select Browse to locate the workbook you created in Stage 2.
Under Select a table or a custom range in the workbook, select the table containing your Excel process data.
Select Finish. This accepts all default values that Visio fills in for the other pages of the wizard.
As a result, the diagram is automatically created inside a container. Additional Visio pages are added depending on the size of the flow chart.
Stage 5: Save the Visio diagram
Select File > Save, find a location, enter a file name, and then select Save.
It's a good idea to keep the Excel and Visio files in the same location because they work hand-in-hand.
Stage 6: Update and refresh the diagram
After you create a diagram with Data Visualizer, you may want to make changes to it. Because there are two components to Data Visualizer, an Excel workbook and a Visio diagram, you need to keep your diagram synchronized with changes to data in the Excel table by refreshing it from Visio. It’s important to understand that the synchronization process is a one-way operation. First you update the data in Excel and then you refresh the diagram in Visio. If there are differences between the data in Excel and Visio when you refresh, the data in Excel wins out.
Make changes to the data in the Excel table. You can add, update, or delete rows.
Save the Excel workbook.
In Visio, select the diagram container, and then select Data > Refresh.
As a result, the changes you made in the Excel workbook are displayed in the Visio diagram. Refreshing only makes changes to the shapes and connections inside the container. Keep all diagram shapes and connector lines inside the container. If you manually add a shape inside the container, and then refresh the diagram, that shape is removed. Any other objects on the page but outside the container are not affected. Any formatting changes you make to the shapes or connectors inside the container are preserved. For more information about containers, see Clarify the structure of diagrams by using containers and lists.
Stage 7: Customize the interaction between the Excel table and the Visio diagram (optional)
There are times when you may want to customize the creation of your Data Visualizer diagrams. For example, you may want to use different shapes to conform to your organization standards, or map to different column names in the Excel table.
When you select Create to enter the Create Diagram from Data wizard and after you enter values in the first page (See Stage 4), select Next or Back to display each page in the wizard.
Select Help (?) to get more information about how to customize each option on the page. For more information, see Use the Create Diagram from Data wizard.
How Excel columns interact with Visio flowchart components
Use the following image walkthrough to understand how each Excel column is used to create the Visio flowchart.
Process Step ID A number that identifies each shape in the flowchart. This column is required, and each value in the Excel table must be unique and not be blank. This value does not appear on the flowchart.
Process Step Description Text added to each shape in the flowchart.
Next Step ID The Process Step ID of the next shape in the sequence. A branching shape has two next steps and is represented by comma-separated numbers such as 4,5. You can have more than two next steps.
Connector Label For branching shapes, connector labels are represented as text separated by a comma, such as Yes,No. Yes corresponds to 4 and No corresponds to 5 in the example.
Shape Type The type of shape you want to represent in the Visio diagram, such as Process or Decision. Microsoft recommends using the drop-down lists to help validate your choices.
Function and Phase The function (or swimlane) and phase (or timeline) that each shape belongs to. This column only applies to a Cross Functional Flowchart diagram and is ignored by a Basic Flowchart diagram.
Here are a few tasks you might want to do after creating a Data Visualizer diagram.
Themes A theme in Visio is a set of colors and effects that you can apply to a drawing with a single click. Themes are a quick way to give your drawings a professionally designed look. For more information, see Apply a professional look to your drawings with themes.
Layout Visio has manual guides and automatic tools to help ensure the shapes in your diagram are aligned and spaced well. That helps make your drawing as clear as possible and give it a well-ordered look. For more information, see Align and position shapes in a diagram.
Data Graphics You can enhance your diagram by adding data graphics, which can make shape data visible. In effect, you can turn your diagram into a process dashboard in which the data graphics display Key Performance Indicator (KPI) information in custom-designed icons based on your shape data. For more information, see Data graphics, an overview.