• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member
  • Login

Visio for Excel Free Add-in

You are here: Home / Excel / Visio for Excel Free Add-in
Visio for Excel Free Add-in
April 30, 2020 by Mynda Treacy

Office 365 users now have access to the Visio for Excel free add-in enabling you to create Excel flow charts linked to cells like this:

flowcharts using Visio for Excel Free Add-in

And org charts like this:

org charts using Visio for Excel Free Add-in

And because they’re linked to cells, you simply refresh the connection and the diagrams update!

Watch the Visio for Excel Free Add-in Video

Subscribe YouTube

Download Workbook

Enter your email address below to download the sample workbook.

By submitting your email address you agree that we can email you our Excel newsletter.
Please enter a valid email address.

Download the Excel Workbook and follow along. Note: This is a .xlsx file please ensure your browser doesn't change the file extension on download.

Installing the Visio for Excel Free Add-in

Download the Visio Data Visualizer add-in* from the Insert tab > Get Add-ins:

create flowcharts with Visio for Excel Free Add-in

*Requires Office 365 Work or School account.

Note: the Visio Data Visualizer is currently in Preview, which means it will continue to be developed over the coming months, but you can do a lot with it already.

Using the Visio Data Visualizer

To insert a flow or org chart first, select an empty cell in your worksheet. This is where some sample data will be placed. The sample data allows you to see the layout required for your linked data.

Then go to the Insert tab > My Add-ins > Microsoft Data Visualiser:

Using the Visio Data Visualizer

Note: The add-in will ask you to login to your Office 365 account…yes even if you’re already logged in inside of Excel! Signing in unlocks capabilities in Visio for the web such as printing, sharing, and viewing in the browser. You don't need a Visio subscription to use this add-in, but if you have one, you'll also be able to make edits to your diagram.

The dialog box opens and here you choose the type of diagram you want:

choose type of diagram

Note: If you're signed in, the diagram is saved as a Visio file in your OneDrive or SharePoint location. If you're not signed in, then the diagram is part of your Excel workbook. You can always choose to create a Visio file by signing in.

When you select the diagram you want, it inserts a sample diagram and its data-linked table:

select the diagram

All you need to do now is replace the data in the table with your own, then click the ‘Refresh’ button in the header of the diagram

You can add as many rows as required or remove any rows from the sample data that you don’t need.

Notes:

  1. If there is an issue with the source data table, the Data Checker will appear with instructions on how to fix the issue. After you modify the table, select Retry in the Data Checker to confirm the issue is resolved. Then you'll see the updated diagram.
  2. Clicking the Edit button in the top of the diagram will ask you to open it in Visio. This requires an Office subscription with a Visio licence.

Visio Flowchart Linked Table

The structure of the table inserted by Visio must be retained. The flowcharts have the following fields:

  • Process Step ID: compulsory unique identifier for each step in the process.
  • Process Step Description: this text appears on the shape
  • Next Step ID: Optional next step. Determines the next shape in the flow
  • Connector Label: Optional where there are multiple next steps
  • Shape Type: There’s a range of shapes to choose from, including 4 custom shapes (see image below)
  • Function: The flowchart row labels
  • Phase: The flowchart column labels available in cross-function flowcharts

Visio Flowchart Linked Table

Note: There’s currently no way to edit the flowchart title inside of Excel. Let’s hope this will be rectified in an update.

Formatting Visio Flowcharts in Excel

The Visio flowcharts in Excel are like any other object. Clicking the outside will enable the pull handles allowing you to resize it, delete it or cut and paste it to a new sheet:

Format Visio Flowcharts

Sharing Visio Flowcharts in Excel

Save your Excel file on OneDrive or SharePoint and from there you can easily share your diagrams via the Visio for Web interface. Click on the ellipses in the top of the diagram > Open in Web:

Sharing Flowcharts Linked to Cells

Note: If you're not signed in yet, you'll be prompted to sign in with your Microsoft 365 or Office 365 work or school account.* Select Sign in and then Allow or Accept on any permission prompts.

* It isn't available for personal Office 365 accounts (hotmail.com, outlook.com, live.com, msn.com).

This opens the diagram in Visio for the web in your default browser. Select the Share button (see image below) to create a link or to enter the email addresses of those you want to share with. All Office 365 users will be able to view the diagram in their browser.

Select the Share button

Alternatively, if you want to share both the data and the diagram, share the Excel workbook that contains the diagram with others. To share it, attach the workbook to an email message, or save it in OneDrive and then use the Share button to send a link.

Lastly, you can print the diagram or create a PDF from the ellipses in Visio for the Web:

print the diagram or create a PDF

More on the Visio Data Visualizer.

Tell Microsoft What You Think!

The Visio team are keen to hear your thoughts on the Data Visualizer add-in. Get in touch with them via email: tellvisio @ Microsoft.com (spaces added to avoid spam).

Visio for Excel Free Add-in
Mynda Treacy

Microsoft MVP logo

AUTHOR Mynda Treacy Co-Founder / Owner at My Online Training Hub

CIMA qualified Accountant with over 25 years experience in roles such as Global IT Financial Controller for investment banking firms Barclays Capital and NatWest Markets.

Mynda has been awarded Microsoft MVP status every year since 2014 for her expertise and contributions to educating people about Microsoft Excel.

Mynda teaches several courses here at MOTH including Excel Expert, Excel Dashboards, Power BI, Power Query and Power Pivot.

More Excel Posts

8 Excel in-built AI Tools

Built-in Excel AI Tools

Clean, analyze and visualize data with these Official Excel AI tools by Microsoft. Including formula writing, PivotTables, Charts and more.
excel date and time

Excel Date and Time

Everything you need to know about Excel date and time. Includes comprehensive workbook with every date and time function, plus PDF version.
10 mistakes to avoid when using excel formatting

10 Mistakes to Avoid With Excel Formatting

These are the Excel formatting habits that drive me crazy and what you should do instead to ensure you use formatting effectively.
linear regression

Excel Linear Regression

Excel linear regression is easy with the built-in tools. Use charts to plot linear regression or use the Data Analysis Toolpak.
speed up slow excel files

How to Improve Excel Performance

How to improve Excel performance and the various causes of slow Excel files so you can speed up Excel and avoid problems in future.
Securely Share Excel Files

Securely Share Excel Files

Securely share Excel files stored locally, on OneDrive or SharePoint. Prevent editing or downloading, specify who can open and edit the file.
excel check boxes

Interactive Excel Check Boxes

Excel check boxes are interactive elements you can link to formulas, charts, conditional formatting and more.
tips for working in multiple excel files

Hacks for Working in Multiple Excel Files

Awesome tips for navigating, arranging and working in multiple Excel files. Guaranteed to streamline your workflow and increase productivity.
chatgpt for excel

ChatGPT for Excel

Using ChatGPT for Excel can be hit and miss. Learn the best uses for ChatGPT to make your Excel life easier and what to avoid using it for.
excel templates

Where to Find Free Excel Templates

Where to find free Excel templates and how to create your own Excel templates. Using templates saves time and effort.


Category: Excel
Previous Post:select multiple items from drop down data validation listSelect Multiple Items from Drop Down (Data Validation) List
Next Post:Charting Real Time Data in Excelcharting real time data in excel

Reader Interactions

Comments

  1. Sergi

    November 19, 2020 at 4:49 pm

    Hi,

    Thank you for your tutorial! 🙂

    One little question, for flowcharts where do you change the title!!! hahahaha
    I have tried in all ways you could imagine! But it seems that is something not modifiable?

    Reply
    • Mynda Treacy

      November 19, 2020 at 8:41 pm

      Thanks, Sergi! You can’t change the title yet. Hopefully they’ll add this feature soon.

      Reply
  2. Rick Ralston

    May 1, 2020 at 7:26 am

    Love your youtube videos. Can’t get enough. Please, keep up the good work!

    Reply
    • Mynda Treacy

      May 1, 2020 at 11:37 am

      Thanks so much, Rick! Please share them with your co-workers too.

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Current ye@r *

Leave this field empty

Sidebar

More results...

office scripts course

Popular Content

  • 10 Common Excel Mistakes to Avoid
  • Top Excel Functions for Data Analysts
  • Secrets to Building Excel Dashboards in Less Than 15 Minutes
  • Pro Excel Formula Writing Tips
  • Hidden Excel Double-Click Shortcuts
  • Top 10 Intermediate Excel Functions
  • 5 Pro Excel Dashboard Design Tips
  • 5 Excel SUM Function Tricks
  • 239 Excel Keyboard Shortcuts

100 Excel Tips and Tricks eBook

Download Free Tips & Tricks

239 Excel Keyboard Shortcuts

Download Free PDF

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel Office Scripts
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook

Sign up to our newsletter and join over 400,000
others who learn Excel and Power BI with us.

 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate
  • Sponsor Our Newsletter

Support

  • Contact
  • Forum
  • Helpdesk – For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.

Download A Free Copy of 100 Excel Tips & Tricks

excel tips and tricks ebook

We respect your privacy. We won’t spam you.

x