Data Visualizer

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

[Read more…]

Published on November 10, 2019 by David Parker

Visio news from MS Ignite 2019

Daniel, Scott, me and Michel at the Veeam party

Microsoft Ignite 2019 at the huge Orange County Conference Conference Center in Orlando is over for another year. 30,000 attendees over 6 days, and I have seen my first sunlight today since I arrived in Florida last Saturday! So, it is time to review just what was announced about Visio, and how much Visio is appreciated.

[Read more…]

Published on May 18, 2017 by David Parker

Data Visualizer for Visio Pro for Office 365 – Part 2

I walked though the steps to create a Cross-Functional flowchart automatically from an Excel table in my last article ( Data Visualizer for #Visio Pro for Office 365 – Part 1 ), but I often prefer to use a relational data source, such as Access or SQL Server, to store and organise my data. Therefore, I describe how Excel‘s Get Data (nee PowerQuery) can be used to merge together the data in a relational data source as a single table suitable for Data Visualizer in Visio Pro for Office 365.

[Read more…]

Published on May 18, 2017 by David Parker

Data Visualizer for Visio Pro for Office 365 – Part 1

Microsoft have just released Data Visualizer for Viso Pro for Office 365! This great new feature provides you with the ability to create diagrams from an Excel table automatically. It currently comes with two new templates for creating Basic or Cross-Functional flowcharts, but the feature can be used for many other different types of diagrams.