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.