HDTutorial
EN

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Create an Organizational Chart in Excel? - (Free Excel Add-in!)

25,742 views June 9, 2020 2:25

Watch on YouTube
ChannelExcel Bootcamp

Description from the creator

How to Create an Organizational Chart in Excel? - (Free Excel Add-in!)
exceldashboardschool.com/free-excel-add-ins-too…

In this video, I will show you how to create an organizational chart in Excel, in under a minute.

Today we will show you:
- how to create an org chart asap,
- how to modify the org chart,
- and how to export the structure to PowerPoint or Word without any trouble using a single click.

Get rid of the manual work stress!
Are you ready for something special?

The first thing we need is data for our org chart.
In this example, I'm going to show the organizational chart for the IT department.
Now create the initial structure. We have the position names.
Each column represents a different level in the structure.
We are ready for the next step.

Now install the free organizational chart generator.
Don't worry, it can take seconds.
Download the zip file from our website and extract the content into your Documents folder.
Switch back to Excel and click on the developer tab.
Locate the Organizational chart generator add-in.
After the successful installation, you'll see the Org Chart tab on the ribbon.
Let us see how the add-in works!

Select the range which contains data.
Click on the org chart icon on the ribbon
Your org chart will be ready in seconds.

If you want to change the default view, use the Chart Layout manager.
With a few clicks, you can rearrange your structure.
You can change the branch layout for the selected shape.

What happens if we want to add more people to this structure?
Let's say we have project managers, and we have our users here.
If you want to add a new position, insert a blank row, and place the new user to the hierarchy.
Clean the chart and refresh the structure.
It is not rocket science.

Just a few words about the compatibility and the export functions.
The add-in is compatible with Excel 2013 and newer versions. It is worth working with SmartArt.
Just click to export icon, and your org chart will be ready for Powerpoint or Word. Thanks for using our dynamic org chart generator.

#OrgChart
#Excel
#OrganizationalChart

About this tutorial

Excel Bootcamp published this 2:25 video tutorial on June 9, 2020. It has been watched 25,742 times on YouTube.

Category
Education
Duration
2:25
Published
June 9, 2020
Views
25,742
Likes
226

Tags

Share

This tutorial in other languages