✦Template Printable Ideas Insights

"Create Organizational Chart in Excel from a List"

By

Streamlining organizational structure is a crucial step for businesses to function efficiently, and creating an organizational chart is a key part of this process. Excel, with its versatile functionalities, is an excellent tool for generating such charts. If you have a list of your company's hierarchy, you're ready to create an organizational chart in Excel. Let's dive into this straightforward process.

Before starting, ensure you have a list of your organization's hierarchy ready. The list should include titles, names, and their respective departments and positions. This list will serve as the data source for your organizational chart. Let's assume you have this data in an Excel sheet with columns: 'Name', 'Position', and 'Department'.

Preparing Your Data in Excel

With your data ready, the first step is to ensure it's clean and well-organized. Remove any unnecessary spaces, check for consistency in naming conventions, and ensure all required information is filled correctly.

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
How to Make an Org Chart in Excel (+ video tutorial)
How to Make an Org Chart in Excel (+ video tutorial)

Once your data is clean, sort it by 'Position'. This will order your employees from top (CEO, for instance) to bottom (interns), facilitating the creation of the organizational chart.

Creating the Organizational Chart

Now that your data is sorted, it's time to turn it into a chart. We'll use a table in Excel for this purpose, which will make the chart more user-friendly and easier to update.

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)
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?

Creating the Table

Select your data, go to the 'Home' tab, and click on 'Format as Table'. Choose a template and ensure the data range is correct. Click 'OK'.

Now, your data is in a table, and you can apply styles, sort, and filter it easily.

Adding Rows for Hierarchy

To accommodate your hierarchical data, you'll need to add rows in your table. Go to the 'Layout' tab in the 'Table Tools' section. Click on 'Add Row Below'. Add as many rows as you have levels in your organizational hierarchy.

Organizational Charts in Excel | MyExcelOnline
Organizational Charts in Excel | MyExcelOnline
Create Organization Chart in Excel
Create Organization Chart in Excel
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
5+ Organization Chart Template Excel Sample | Template Business PSD, Excel, Word, PDF
5+ Organization Chart Template Excel Sample | Template Business PSD, Excel, Word, PDF
Automatic Org Chart Maker: Excel Template with Photos (Ready to Print)
Automatic Org Chart Maker: Excel Template with Photos (Ready to Print)
Org chart
Org chart

Now, your table should look like a basic organizational chart, but without the indents and connector lines that make it visually appealing. Let's fix that.

Formatting the Chart

Select all columns in your table. Go to the 'Home' tab, click on 'Borders'. Choose 'All Borders'. This will add borders around your table, clearly outlining the boxes for each role.

Next, let's add some hierarchy. Select the 'Name' column. Click on the small icon in the bottom right corner of the column header. Drag it right until you see a black line. Release it. This has made your 'Manager' columns wider, making the chart more visually appealing. Repeat this for other columns if necessary.

How to Create an Organization Chart in Word 2010 | Daves Computer Tips
How to Create an Organization Chart in Word 2010 | Daves Computer Tips
How to make a male_female ratio chart in Excel
How to make a male_female ratio chart in Excel
Free Organisational Chart Template
Free Organisational Chart Template

Lastly, let's add those connector lines. For this, we'll use Microsoft Office's SmartArt feature. Draw a rectangle around two boxes you want to connect. Press 'Ctrl + W'. This will remove any borders inside the rectangle. Press 'Ctrl + A' to select everything within the rectangle, then click on 'Design' (in the 'SmartArt Tools' section). Choose a diagram that suits you, and click 'OK'. Do this for each level of your hierarchy.

Filling in Your Organizational Chart

Now, fill in your organizational chart. Start from the top, fill in the name and position for each role. Use the 'Merge & Center' command (in the 'Home' tab) to center text if necessary.

Once you're done, you'll have a fantastic, up-to-date organizational chart ready for use. This can serve as a visual reference for your team's structure, simplify communication, and facilitate decision-making.

With your organizational chart in place, you can now move forward with a clear understanding of your company's structure. Regularly update the chart to reflect any changes in your organization, ensuring it remains a useful and relevant tool.