✦Template Printable Ideas Insights

"Create 조직관계도 in Excel from List: Step-by-Step"

By

Creating an organizational chart in Excel from a simple list might seem daunting at first, but with the right steps and a bit of creativity, you can transform your list into an intricate hierarchy in no time. Excel's built-in tools and a little know-how are all you need to make this happen. So, let's dive right in and master your Excel organizational chart creation process.

Before we start, ensure your list is in a convent format - each individual or position on a new row, with columns for their names, roles, and any other relevant information. This will make our task easier and more efficient.

Importing Your List into Excel

Start by opening a new Excel spreadsheet and from the 'Get & Transform Data' tab, select 'From Text/CSV'. Navigate to your list file and click 'Open'. Excel will display a preview of your data. Click 'Load' to import your list.

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

If your list has a header row, Excel will load it correctly. If not, or if the data types are incorrect, you can preview and clean your data before loading it in the 'Power Query Editor'.

Formatting Your Data for the Organizational Chart

Once your data is loaded, you'll see it in a tab called 'Table1'. To format it, select the whole table and go to the 'Design' tab. From here, you can add a header, format the table style, or add a total row. For an organizational chart, you'll mostly be working with names and roles, so format these columns as needed.

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?

Now that your data is clean and formatted, let's start building our organizational chart.

Creating the Chart

Select your data (excluding the header), go to the 'Insert' tab and click on 'PivotChart'. Choose the chart type - for organizational charts, a 'Hierarchy' or 'Organization Chart' layout works best. Click 'OK'.

Excel will create a draft chart with your data. However, by default, it displays all employees as equals. To create a hierarchy, we'll have to adjust the layout.

Organizational Charts in Excel | MyExcelOnline
Organizational Charts in Excel | MyExcelOnline
Create Organization Chart in Excel
Create Organization Chart in Excel
Automatic Org Chart Maker: Excel Template with Photos (Ready to Print)
Automatic Org Chart Maker: Excel Template with Photos (Ready to Print)
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.
the organizational chart for an organization
the organizational chart for an organization
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

Building Your Hierarchy

In the 'Field' list, drag the 'Role' field to the 'Axis' section. This tells Excel to arrange your employees hierarchically based on their roles. If your roles have clear hierarchies (like 'CEO' above 'Directors' or 'Managers'), this will work perfectly.

To view your chart, click on it. You can adjust the layout, add or remove fields (like names), or format the chart to match your organization's branding. Once you're happy with your chart, you can print it, export it as an image, or even update it automatically whenever your list changes.

Updating Your Chart with New Information

Now that your organizational chart is created, updating it with new information is a breeze. When you add new employees or roles to your list, simply refresh the 'PivotChart' (right-click on it and select 'Refresh'), and Excel will update the chart to reflect the changes.

Free Organisational Chart Template
Free Organisational Chart Template
How to Create a Scrollable Calendar in Excel Gantt Chart 📅🔄 (Dynamic Date Control)
How to Create a Scrollable Calendar in Excel Gantt Chart 📅🔄 (Dynamic Date Control)
Excel to Do List Template: Daily Weekly Monthly Task Tracker (digital Download) - Etsy
Excel to Do List Template: Daily Weekly Monthly Task Tracker (digital Download) - Etsy

Similarly, if you reorganize your staff or roles, just update the relevant cells in your list, and refresh the chart. Excel will automatically adjust the hierarchy to reflect the changes.

And there you have it - creating an organizational chart in Excel from a simple list is easier than you thought! So, the next time you need to visualize your organization's hierarchy, you know just what to do. Happy charting!