✦Template Printable Ideas Insights

How to Create an Organizational Chart in Excel with Picture Tutorial

By

Creating an organizational chart in Excel is a straightforward task that can help you visualize and understand the structure of your team or organization. With its extensive features, Excel enables you to create charts swiftly and effectively. Here, we'll guide you through the process of creating an organizational chart in Excel, complete with pictures for better visualization.

Before we dive into the step-by-step guide, ensure you have Microsoft Excel installed on your computer. You'll also need to have or be able to obtain a list of employee names and their respective positions within the organization.

Preparing Your Excel Workbook

Starting with a clean slate makes the process smoother. Open a new workbook in Excel and create a new sheet. Name the sheet 'Organizational Chart' for easy reference. In the first table row (A1 to E1), type the following headers: 'Photo', 'Name', 'Position', 'Department', and 'Subordinates'.

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

Formatting your table is crucial for ease of use and neatness. Select cells A1 to E1, click on the 'Home' tab in the ribbon, then click 'Format as Table'. Choose a table style that suits your preferences and click 'OK'. Your headers will be automatically formatted.

Adding Photos to Your Organizational Chart

visualize your organization effectively, you can add photos of your employees. In cell A2, click the 'Insert' tab in the ribbon, then click 'Pictures'. Browse to and select the photo you want to add. The image will be inserted into the cell. Repeat this process for each employee in your chart.

the organizational chart for an organization
the organizational chart for an organization
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 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?

To enhance the visual appeal of your chart, you can resize the images. Click on an image to select it, then drag the selection handles to resize. To maintain the original aspect ratio, press and hold the 'Shift' key while dragging.

Entering Employee Information

With photos added, you can now enter the relevant employee information. Starting from A2, enter the respective data for each employee: their photo (you've already added this), name, position, department, and subordinates (if any).

For subordinates, you can add them as merge cells in the 'Subordinates' column. For example, if John Doe (in row 2) has Jane Smith and Bob Johnson as subordinates, in cell E3, type 'Jane Smith' and 'Bob Johnson', separated by a line break ('Alt+Enter' is the shortcut for this).

How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial
Paper style organizational chart infographic with photo | Free Vector
Paper style organizational chart infographic with photo | Free Vector
Org Chart Template with Pictures | Creately
Org Chart Template with Pictures | Creately
Create Organization Chart in Excel
Create Organization Chart in Excel
How to Create Organizational Chart in Excel
How to Create Organizational Chart in Excel
41 Organizational Chart Templates (Word, Excel, PowerPoint, PSD)
41 Organizational Chart Templates (Word, Excel, PowerPoint, PSD)

Creating the Visual Hierarchy

With the basic information in place, it's time to create the visual hierarchy that represents your organizational structure. Select the range of cells you've filled (e.g., A1 to E12), then click the 'Home' tab in the ribbon. Click on the 'Format as Table' button again and choose the same style as before. This time, click 'OK' without choosing 'My table has headers' as it's already selected.

Now, your organizational chart has a consistent and professional look. However, we want to emphasized the hierarchy by using different fonts for the management and staff levels. Select the data for the managers (e.g., A2 to E4), then click the 'Home' tab in the ribbon. Click on any font type in the 'Fonts' group to change the font. You can also apply bold or italic styles to emphasize their role.

Sorting and Filtering Your Data

To ensure your organizational chart reflects the proper hierarchy, it's useful to sort and filter your data. Select any cell inside your chart, then click the 'Data' tab in the ribbon. Click 'Sort A to Z' to sort your chart alphabetically by name. If you prefer sorting by position, click 'Sort & Filter' (far-right in the 'Sort & Filter' group), then click 'Position' under the 'Column' heading, and click 'OK'.

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
How to Create Multi-Category Chart in Excel
How to Create Multi-Category Chart in Excel
Photo Organizational Chart Examples
Photo Organizational Chart Examples

You can also add a filter to your chart by clicking the 'Filter' button (far-right in the 'Sort & Filter' group). This will allow you to dynamically filter your chart based on the categories in each column.

Final Touches and Customization

Your organizational chart is looking great, but you can add some final touches to make it stand out. For example, you can add a header or footer with your organization's name or logo. Click the 'Insert' tab in the ribbon, then choose 'Header' or 'Footer', and select a design that suits your needs.

Furthermore, you can add horizontal lines to separate the different levels of management. Select the cells below the manager level (e.g., A5 to E5), then click the 'Home' tab in the ribbon. In the 'Borders' group, click 'All Borders'. This will add a border around the selected cells. Repeat this process for each level in your organization.

Creating an organizational chart in Excel is a rewarding experience. It allows you to visualize your team or organization, enhancing understanding and collaboration. With the final touches added, your chart is ready to be shared with your team or organization. Use it to onboard new members, facilitate discussions, or simply keep everyone on the same page. Regular updates will ensure it remains a valuable and dynamic resource. Happy organizing!