May 03 2017
03:59 PM
- last edited on
Nov 08 2021
01:39 PM
by
TechCommunityAP
May 03 2017
03:59 PM
- last edited on
Nov 08 2021
01:39 PM
by
TechCommunityAP
Today, we’re excited to announce Data Visualizer, a new Visio feature that automatically converts process map data in Excel into data-driven Visio diagrams. This update, which is available to Visio Pro for Office 365 users, helps reduce manual steps while giving business analysts even more ways to create process diagrams in Visio.
Diagrams don’t always start in Visio. They often begin as hand-drawn sketches or—in today’s data-driven age—in Excel. Using Data Visualizer, business analysts can represent process steps and associated metadata in a structured Excel table and quickly convert that information into a visualized Visio diagram. You can do this by either using a premade Excel template or an existing spreadsheet of your own design. The premade templates—there’s one for basic and one for cross-functional flowcharts—provide a sample mapping table to populate with diagram metadata. The table includes predefined columns for process step number, description, dependencies, owner, function, phase and more. You can also customize the table with your own columns to meet specific business requirements.
Read about it on the Office Blogs.
Jul 19 2017 03:53 PM
Hi. I am able to export the data visualizer Excel workbook. I've populated the Process Map tab. I save file as .Excel xlsx. When I go back into Visio, I click on Import. However, I am unable to change the file type. As a result, I don't see my excel file that I originally exported from Visio.
Any help is greatly appreciated!!
Oct 18 2017 02:53 AM
Hi,
Can you share a screenshot of the exact step where you are stuck? You can write to us at dv-feedback[at-the-rate]Microsoft.com
Jul 30 2019 05:55 PM
I am confused @Eric Starker about the software requirements to make this work. I have O365.
Do I need Visio Professional? Or is Visio Online Plan 2 a requirement?
Thanks for your help.
Jul 31 2019 12:11 AM
@mlwest1 Visio Online Plan 2 is a requirement to use the Data Visualizer feature.
Oct 13 2019 11:52 PM
Oct 14 2019 01:03 AM
@Vky2073 You can just add another column in your Excel table and then use data graphics in Visio to overlay TAT on your flowchart steps. You can find more details in this article:
Oct 16 2019 10:09 PM
Thank you so much
Oct 16 2019 10:12 PM
Oct 21 2019 02:25 AM
Hai @Eric Starker
In visio flow chart creation some shapes have inbuilt shapes (ex in shapes UML Deployment -> package it has Package name and another text box and it is grouped)
How i can use this shapes while creating flow chart using Excel
If i want to give the process description and process ID in same shape means how i can use these grouped shapes
Oct 21 2019 09:25 AM - edited Oct 21 2019 09:26 AM
@Vky2073 Hello! I'm a community manager here and was sharing some news for the Visio team, but I'm not a product expert. Hopefully some other experts here in the community can answer your question!
Oct 21 2019 10:58 AM
@Vky2073 This is currently not possible, you can use any shape to create your flowchart steps from Excel data, however you can only map one field from data to the shape text. That is you can either map the shape text field to process description or to process ID but not both (even with a group shape).
Oct 21 2019 09:04 PM
Thank you