✦Template Printable Ideas Insights

Create Org Chart in Excel from Data

By

Creating an organizational chart (org chart) in Excel from data involves transforming your raw data into a user-friendly visual hierarchy of roles and responsibilities. This process helps you understand your organization's structure at a glance, facilitating better communication, improved decision-making, and enhanced productivity. Let's dive into two efficient methods to create an org chart in Excel.

Before we begin, ensure your data is extant in a readable format. You'll need at least two columns: one for the employee names and one for their respective managers. Additional columns for departments, job titles, or other relevant information can further enrich your org chart.

Using the Organization Chart Layout in Excel

Excel offers a built-in Organization Chart Layout that simplifies the process of creating an org chart. Here's how to use it:

Create Org Chart
Create Org Chart
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?
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

Step 1: Click inside your data range and navigate to the Insert tab in the ribbon. Click on Organization Chart, then choose one of the available layouts like Hierarchy, Organization, or Multilevel. For a basic org chart, Organization is typically the best fit.

Mapping Employee & Manager Fields

After inserting the layout, you'll be prompted to map your employee and manager fields. Select the appropriate columns from your data range and click OK.

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)
a blue and white organizational chart on a white background with the words financial aid organization chart
a blue and white organizational chart on a white background with the words financial aid organization chart
an info sheet with many different types of boats in it
an info sheet with many different types of boats in it

Step 2: Once the org chart is created, you can customize it by adding more levels, reordering employees, or changing the layout. Right-click on the chart and select Format Chart to access these options.

Customizing the Organization Chart

To add more levels, drag and drop employees from your data range onto the chart. To remove employees, drag them back to the data range. You can also change the chart layout or styles using the Format Chart pane.

Creating an Org Chart Using Shapes and Text Boxes

If you prefer a more DIY approach, you can also create an org chart using Excel's Shapes and Text Boxes.

How to Create an Organizational Chart in Word with Free Templates | EdrawMax
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
5+ Organization Chart Template Excel Sample | Template Business PSD, Excel, Word, PDF
5+ Organization Chart Template Excel Sample | Template Business PSD, Excel, Word, PDF
How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial
Organogram Template Excel If you manage a team employee or busy household, you can easily man...
Organogram Template Excel If you manage a team employee or busy household, you can easily man...
the ultimate guide to create professional chart in excel with infos, graphs and diagrams
the ultimate guide to create professional chart in excel with infos, graphs and diagrams

Step 1: From the Insert tab, choose Shapes, then select the Rectangle tool. Draw boxes around the highest-level positions in your org chart and insert the respective text (name, job title, etc.) using Insert > Text Box, and then Edit Text.

Adding Subordinates

Step 2: For each position, create corresponding boxes for its subordinates and connect them visually using lines (Insert > Lines). Maintain a consistent orientation and layout for a visually appealing chart.

Step 3: Continue this process for each level of the organization, ensuring accurate connections between employees and their managers.

How To Create Charts and Graphs in Excel
How To Create Charts and Graphs in Excel
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
31+ Free Organogram Templates & Organizational Charts
31+ Free Organogram Templates & Organizational Charts

Adding Additional Information

To incorporate more details, like departments or contact information, add additional text boxes to your org chart. You can also use Excel's SmartArt feature for a more structured approach to creating organizational charts with shapes.

As you finalize your org chart, consider adding a header with your company name and a footer with a contact email or website. Once complete, you can export the chart as a PNG or PDF file for easy sharing, printing, or inclusion in reports. Regularly updating your org chart ensures everyone in your organization stays informed and connected.

Creating an org chart in Excel from data isn't just about fulfilling a formal requirement; it's an opportunity to enhance communication, promote transparency, and foster a sense of belonging within your organization. With practice, you'll find that the process becomes more intuitive, allowing you to create visually appealing and insightful org charts effortlessly.