The Visio Data Visualizer is now built directly into Excel. As of a recent Office update (September 2020), what was once an add-in is now a native feature found on the Insert ribbon in Excel.
If you are running an older build number of Excel, you can still manually add the Visio Data Visualizer per the below instructions.
For this feature to function properly, we need to download and install a free Microsoft add-in called the Microsoft Visio Data Visualizer.
This add-in allows us to use more sophisticated Visio diagrams inside of Excel. One of the great things about this add-in is that you are not required to own a Visio subscription in order to use the add-in. All you need is a subscription for Excel in Office 365.
To acquire this add-in, in Excel select Insert (tab) -> Add-ins (group) -> Get Add-ins.
In the Office Add-ins dialog box, search for “visio”. This will return a link to the Microsoft Visio Data Visualizer. Click the green ADD button to the right of the add-in to install this into Excel.
NOTE: This add-in is currently in preview (February 2020), so we can expect it will receive improvements pending its official release.
Once you have installed the free Visio Add-in, you are presented with the following dialog box.
This add-in gives us the ability to create the following types of charts:
- Basic flowcharts
- Cross-functional flowcharts
- Organizational charts
When you attempt to use one of the chart types, you may be presented with a message informing you that you need to login to your Office 365 account prior to use.