• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

bVisual

  • Home
  • Services
    • How Visio smartness can help your business
    • Visio visual in Power BI
    • Visio Consulting Services
    • Visio Bureau Services
    • Visio Training and Support Services
  • Products
    • Visio Shape Report Converter
    • SS Plus
    • LayerManager
    • visViewer
    • Metro Icons
    • Rules Tools for Visio
    • The Visio 2010 Sessions App
    • Multi-Language Text for Visio
    • Document Imager for Visio
    • multiSelect for Visio
    • pdSelect for Visio
  • Case Studies
    • Case studies overview
    • Visualizing Construction Project Schedules
    • Visio Online Business Process Mapping
    • Nexans Visio Template
    • CNEE Projects, WorldCom
    • Chase Manhattan Bank
  • News
    • Recent news
    • News archive
  • Resources
    • Articles➡
      • ShapeSheet Functions A-Z
      • Comparing Visio for the Web and Desktop
      • Customising Visio Shapes for the Web App
      • Key differences between the Visio desktop and web apps
      • Using the Visio Data Visualizer in Excel
      • Using Visio in Teams
      • Creating Visio Tabs and Apps for Teams with SharePoint Framework (SPFx)
      • Designing Power Automate Flows with Microsoft Visio
      • Innovative uses of Visio Lists
    • Webcasts ➡
      • Visio in Organizations
      • My session and other Visio sessions at MSIgnite 2019
      • Power up your Visio diagrams
      • Vision up your Visio diagrams
      • The Visio 2010 MVP Sessions
    • Visio Web Learning Resources
    • Books➡
      • Mastering Data Visualization with Microsoft Visio
      • Microsoft Visio Business Process Diagramming and Validation
      • Visualizing Information with Microsoft Visio
  • Blog
    • Browse blog articles
    • Visio Power BI articles
    • Visio for Web articles
    • A history of messaging and encryption
  • About us
    • About bVisual
    • Testimonials
    • Bio of David Parker
    • Contact Us
    • Website Privacy Policy
    • Website terms and conditions
    • Ariba Network
You are here: Home / Excel / Data Visualizer / Visio Data Visualizer Tips

Published on October 15, 2020 by David Parker

Visio Data Visualizer Tips

The Microsoft Visio product team have released a great video introduction to the Visio Data Visualizer, but even that does not reveal all of its power. So, here are some tips about using the Microsoft Visio Data Visualizer add-in in Excel. Firstly, the add-in currently offers three different types of diagram, and each have a number of alternative layout arrangements.

  • Basic Flowchart – 4 layouts
  • Cross-Functional Flowchart – 5 layouts
  • Organization Chart – 5 layouts

Although these are the proposed diagram types, there is no reason why other types of data, such as network devices, cannot be used with any of them.

Sample Org Chart with Visio Data Visualizer in Excel

Re-use existing tables

Each of the diagram types utilize specific column headings and are targeted at a particular named table (ListObject). So, knowing this, it is possible to use any table in the workbook, which has the specified name, and includes the mandatory columns. Of course, the sample table will need to be deleted before the alternative table is named, since those names need to be unique.

Similarly, existing columns which contain the desired data can be re-named to match the mandatory ones, or a query can be created from the original table to create a new table with the specified name and mandatory column names. Power Query / Get & Transform Data is absolutely brilliant for this!

Organization Charts

For example, the Organization Chart diagram type requires the following minimum column names:

  • Employee ID – The row unique identifier
  • Name – The top bold label
  • Title – The lower label
  • Manager ID – The reports to value(s) in the Employee ID column
  • Role Type – The colour coding of the shapes

Flowchart diagrams

The Basic Flowchart diagram type has five mandatory column headings, and one optional, although more are allowed.

  • Process Step ID – The unique row identifier
  • Process Step Description – The label text
  • Next Step ID – The comma-separated list of
  • Connector Label – The comma-separated list of labels for the connectors
  • Shape Type – The shape type to use
  • Alt Text – Optional for accessibility narration

The valid Shape Types set in the Data-Validation list :

Process, Decision, Subprocess, Start, End, Document, Data, Database, External Data, On-page reference, Off-page reference, Custom 1, Custom 2, Custom 3, Custom 4

The Subprocess shape will be used if the value is not found in the above list

The Cross-Functional Flowchart diagram type has two extra mandatory columns:

  • Function – The label of the horizontal swimlane
  • Phase – The label for any vertical stages

Org Chart Example

One example is where I crated a new table, using Power Query, from an existing one, and re-named three columns, and added another using a formula.

Name => renamed as Employee ID

Whole Name => re-named as Name

Manager => re-named as Manager ID

Grade => new Role Type column created with a formula

  • Pre-existing Data
  • Sample Table Deleted
  • New Query from Existing Data
  • Named Same as Deleted Table
  • Updated Org Chart

The sample data table can be deleted, but take a note of its name first. Then, either rename an existing table with that name, or, as above, create a new table with that name using Power Query. If the table name matches, and the required column headings are present with suitable data, then the Visio diagram can be refreshed and .. hey presto! the chart is updated with your data.

Moreover, now that the data is in a different worksheet, the Visio diagram can be enlarged and moved to the top left corner. This looks much better for presentations.

One word of warning … if you use an intermediate Power Query table, as I do, then you must refresh that query if you edit the data in the source table.

Matrix reporting in Org Charts

The Organization Chart sample data provided with the add-in only shows only single values in the Manager ID column. However, just like the Next Step ID column in the flowchart diagram types, this is a comma-separated list of valid Employee ID values. The Person shapes will be suitably connected together, although you need to choose a suitable layout arrangement for it to be clearly understandable.

  • Matrix Reporting Chart
  • Multiple Manager IDs

Multiple organization hierarchies

If your data contains more than one row that does not have a Manager ID value, then the diagram is split into groups.

  • Grouped Hierarchies
  • Multiple blank Manager IDs

This may be desirable in certain scenarios…

Diagrams from filtered rows

However, one of the virtues of having an intermediate Power Query is that the data can be filtered. This means that you can create an chart from a subset of the data, such as this example for the Marketing Department.

  • Filtered Org Chart
  • Filtered with Power Query

Use any data source with Power Query

Power Query in Excel (displayed as Get & Transform ) provides the ability to get your data from a myriad of data sources, so using the technique above to transform the data into a suitable form for Visio Data Visualizer really opens up these data driven diagrams for everyone.

That’s enough for today, but I hope you have seen enough to try the Microsoft Visio Data Visualizer … it is free to qualifying Excel license holders!

  • Data Visualizer for Visio Pro for Office 365 – Part 1
  • Binding Visio and Excel with Data Visualizer
  • Pushing Data Visualizer in Visio to the limits!

Filed Under: Data Visualizer, Excel, Visio Tagged With: Data Visualizer, Excel, Visio

About David Parker

David Parker has 25 years' experience of providing data visualization solutions to companies around the globe. He is a Microsoft MVP and Visio expert.

Reader Interactions

Comments

  1. Luc Van Overveldt says

    January 10, 2022 at 9:06 am

    Hello David,
    Nice article. Especially for those who need to look a bit more ‘behind the curtain’
    I have been using the Cross-Functional flowchart . Works as expected .
    However , I cannot get function to show up in the order I want to

    An example can be found in the following shared file
    https://1drv.ms/x/s!Au1LYBMthCUagZNefZQqmUBwcpxwIA?e=ycFtnG

    I would expect a swimlane order of C01,C02,C03,C04 . Tried everything in ordering the records of the table . But things keep on popping out incorrect

    Any idea what is going on ?

    Reply
    • David Parker says

      January 10, 2022 at 1:25 pm

      That is an interesting question. Microsoft have often been asked for a way to order by a selected Shape Data value.
      Can I use your example to discuss with team at Microsoft?

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

  • LinkedIn
  • Twitter

Recent Posts

  • Update to LayerManager add-in for non-English users
  • Pushing Data Visualizer in Visio beyond its limits
  • Pushing Data Visualizer in Visio to the limits!
  • Teams Tuesday Podcast Recording about Visio
  • Linking Data to Visio Shapes in Code

Categories

Tags

Accessibility Add-Ins Connectors Containers Data Export Data Graphics Data Import Data Visualizer Educational Excel GraphDatabase Hyperlinks Icon Sets JavaScript Layers Legend Link Data to Shapes Lists MSIgnite MVP Office365 Org Chart PowerApps PowerBI PowerQuery Processes Shape Data Shape Design ShapeSheet ShapeSheet Functions SharePoint 2013 SQL Teams Themes Validation VBA Video Visio Visio 2007 Visio 2013 Visio for the Web Visio Online Visio Services Visio Viewer Webinar

Footer

bVisual Profile

The UK-based independent Visio consultancy with a worldwide reach. We have over 25 years experience of providing data visualization solutions to companies around the globe.

Learn more about bVisual

  • LinkedIn
  • Twitter

Search this website

Recent posts

  • Update to LayerManager add-in for non-English users
  • Pushing Data Visualizer in Visio beyond its limits
  • Pushing Data Visualizer in Visio to the limits!
  • Teams Tuesday Podcast Recording about Visio
  • Linking Data to Visio Shapes in Code

Copyright © 2023 · Executive Pro on Genesis Framework · WordPress · Log in