✦Template Printable Ideas Insights

How to Build an Org Chart in Excel from a List

By

Want to organize your company's structure in a clear, hierarchical way? An organizational chart, or "org chart" for short, is an excellent tool for this task. And what better place to create it than in the versatile Excel? With this comprehensive guide, you'll learn how to create an org chart in Excel from a simple list in no time.

Before we dive in, ensure you have a list of your team members with their respective ranks or departments. This list will serve as the foundation for your org chart. Now, let's get started!

Setting Up Your Data

The success of your org chart relies heavily on the organization of your input data. Begin by opening a new or existing Excel file and titling it appropriately, such as "Organizational Chart".

How to Create the Organizational Chart You Know Your Business Needs | Process Street | Compliance Operations Platform
How to Create the Organizational Chart You Know Your Business Needs | Process Street | Compliance Operations Platform
How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial
a computer screen with an arrow pointing to the text boss how did you make this org chart?
a computer screen with an arrow pointing to the text boss how did you make this org chart?

In the first column (A), list down your team members' names. In the second column (B), list their corresponding ranks or departments. For instance, you might have: - John Doe, CEO - Jane Smith, HR Director - Jim Brown, IT Specialist -

Formatting Your Data

Next, apply consistent formatting to enhance readability.

Automatic Org Chart Maker: Excel Template with Photos (Ready to Print)
Automatic Org Chart Maker: Excel Template with Photos (Ready to Print)
How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial
How to Create an Organizational Chart Linked to Data in Excel (Easy & Dynamic)
How to Create an Organizational Chart Linked to Data in Excel (Easy & Dynamic)

Highlight the cells containing your data (A2:B5, for example). Go to the "Home" tab, click on "Conditional Formatting", then "High Contrast". Choose "Table/Range" and set the "Minimum" and "Maximum" to 1. This will apply bands to your data, making it easier to scan.

Adding Visual Elements

To make your org chart more engaging, add color or icon sets. In the "Home" tab, click on "Conditional Formatting" again, then "Highlight Cells Rules". Choose "Text That Contains", and apply your desired visual elements based on your company's structure or your personal preference.

Creating the Org Chart

Now that your data is organized and formatted, it's time to create the org chart itself. We'll use Shape and SmartArt features for this.

Create Organization Chart in Excel
Create Organization Chart in Excel
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
Org Chart, Organizational Chart, Business Plan, Business Strategy, Company Org Chart, Company Organization Template, Company Structure
Org Chart, Organizational Chart, Business Plan, Business Strategy, Company Org Chart, Company Organization Template, Company Structure
the advanced excel chart sheet is shown in green and has instructions on how to use it
the advanced excel chart sheet is shown in green and has instructions on how to use it
5+ Organization Chart Template Excel Sample
5+ Organization Chart Template Excel Sample
Create a Stacked Column Chart with Total in Microsoft Excel
Create a Stacked Column Chart with Total in Microsoft Excel

Head over to the "Insert" tab, click on "Shapes". Choose the " organización chart" icon. Click and drag on your spreadsheet to create a sizeable enough canvas for your chart.

Adding Shapes

Now, let's add shapes for each team member. In the "Home" tab, click on "New Item from File". Choose "Picture from File" and select your team members' photos (resized to 100x100 px or similar). Insert each photo into a new shape (right-click > Add Text).

Connect the shapes using lines (from "Shapes" > "Lines" > "Curve"). Size and position them according to the hierarchy in your data. Use "Rotate" and "Flip Vertical" functions to align the top-level and bottom-level employees.

41 Organizational Chart Templates (Word, Excel, PowerPoint, PSD)
41 Organizational Chart Templates (Word, Excel, PowerPoint, PSD)
Organizational Chart Template. Charity Organization template. Company Organization Template. Employee Structure Excel Template. Org Chart.
Organizational Chart Template. Charity Organization template. Company Organization Template. Employee Structure Excel Template. Org Chart.
How to create a progress chart.#excel #microsoft #microsoftexcel #office #word #o #powerpoint.
How to create a progress chart.#excel #microsoft #microsoftexcel #office #word #o #powerpoint.

Adding Text and Finalizing

In each shape, add the team members' names and positions (right-click > Add Text). Format the text by increasing the font size and making it bold (from "Home" > "Font" > "Bold" and "Increase Font Size").

Once you're satisfied with the layout, finalize your org chart by adding a title at the top (e.g., "Our Company's Organizational Structure"), adjusting shape colors, and aligning everything perfectly.

And there you have it! Your org chart is now complete and ready to be shared with your team. This visual representation of your company's structure can enhance communication, boost morale, and foster a clearer understanding of roles and responsibilities. Now, go ahead and demonstrate your excel expertise to your peers!