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.Excel Visio Add in: Excel icon

Nowadays most people have the 365 version of Microsoft Office. This version comes with regular updates to the software. This regularly includes fixing any issues/bugs that may have come up. As well as this 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 it’s pretty simple.

Steps to use it

Firstly, 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. To have a look at the flowchart straight away click on the ‘sign in later option’.

Like this hint and tip? Why not take a look at our previous one on Track Changes in Word?

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