How to Make Org Charts in PowerPoint, Word, Teams, Excel & Visio

In this step-by-step tutorial, learn how to make organization charts in Word, Excel, PowerPoint, and Visio. We also look at how you can make your org chart available in Microsoft Teams, Outlook, and even on Office.com using the People Graph.

We’ll start with the basics of making an org chart using Smart Art directly in Word, Excel, and PowerPoint.

Then we’ll look at how you can make an org chart using Visio on the web, which now comes for free with all work and school accounts. You’ll have a little more control compared to the smart art option.

Then we’ll look at how you can make an org chart using the data visualizer, which uses both Visio and Excel.

Lastly, we’ll look at how you can make your org chart available within Microsoft Teams, Outlook, and Office.com and even how you can export this data.

  • Additional resources
    • PowerShell command to connect to Exchange Online: Connect-ExchangeOnline -UserPrincipalName ENTER YOUR USERNAME HERE
    • PowerShell command to get all user information: Get-User -ResultSize unlimited | select id,displayname,title,manager,department | export-csv -path C:\specify where to save you csv\userlist.csv
  • Timestamps
    • 0:00 Introduction
    • 0:55 Org chart using Smart Art in Word, Excel & PowerPoint
    • 5:03 Org chart using Visio on the web
    • 8:20 Org chart using Excel & Visio
    • 10:30 Org chart using Azure Active Directory
    • 12:51 Export user data from AAD to csv
    • 14:10 Wrap up

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s