How to Create an Organizational Chart in Excel? (automatic) - FREE ADD-IN!!!

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

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

[HeroMao]

it say update requested, i can't do it

[isharadinuth]

Sometimes, there may have some employees in level 3 but report to level 1..

Like that scenarios, how to put data for this excel?

[edineifacioli]

You saved my job, and gained a subscriber. The only problem is that I cannot change the layout. Do you know what could be?

[discoveringsaskatchewan]

Great! what voice over do you use please? I need same for my school

[ellanguyen]

I downloaded the template and it works really great for me for a couple weeks now! But just now, it asks me to update with new version (mine is version 1.01083). Where could I find this new version? (the one in your website is still the old version (version 1.01083 released on 30/07/2020))

[Santoshpower]

You need to teach how to create the macro file for org chart instead of downloading it

[fatmafadl]

Great Job, But i couldn't find the zip file !!!

[sainjumaurya]

Sir ji create Excel in geographical map in uttar Pradesh with data and color

[MrPeru]

Didn't work, downloaded it and it does not show when I browse even though I see it.

[jinalshah]

From which website to find the zip file??

[MrBadmind]

I need the org chart. It's not FREE!!!