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

One thought on “How to Make Org Charts in PowerPoint, Word, Teams, Excel & Visio

  1. Watched your Layering tutorial for Power Point. Very well done! I’m struggling to take a simple picture on my slide and make it appear as if it has duplicate pics layered behind it. (cascade top left, like a stack of cards fanned upward) Not sure if this would be a shape effect of sorts? Do you have a tutorial that might share this? Thank you!

    Like

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 )

Facebook photo

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

Connecting to %s