Excel Visio Add in – the new Visio Data Visualizer add-in that has appeared in a recent Microsoft Office update

This hint is for those people who are Office 365 subscribers and want to know what’s around the corner.

Nowadays most people have the 365 version of Microsoft Office and what comes alongside this version is regular updates to the software. This regularly includes fixing any issues/bugs that may have come up but it also includes any new ‘add-ins’ that might have been developed/created since the last update. There is a whole list of add-ins that are available for you to use within your Excel workbooks, you just need to add them into your workbook by searching for them in the Microsoft Store by clicking on the ‘Get Add-ins’ or ‘Add-ins’ button which is found on the Insert Tab.

If you want to do flowcharts in Microsoft you previously had to buy and use Visio or use the standard sheets and Smart Art diagrams in Excel.

Now there is an add in called Visio Data Visualiser/ Here’s a simple screen print of one we’ve done.

You’ll need to see if you are licensed and able to use it but its pretty simple.

Open Excel and create a new Blank workbook.

Select Insert > Get Add-ins or Add-ins. In the Office Add-ins Store, search for “Data Visualizer”, and then select Add.

It’s pretty straightforward to use and the refresh button is great.

If you want to do more fancy flowcharts you will need a Visio license.

Open the attached Excel workbook here and have a go!

When you click for the Excel workbook, it will allow you to download a copy to your computer to try out. You can click on the sign in later option when the workbook comes up if the diagram doesn’t appear to begin with to have a look at the flowchart straight away.

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We have placed cookies on your device to help make this website better.

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy