✦Template Printable Ideas Insights

How to Create a Simple Organizational Chart in Excel

By

Creating an organizational chart or org chart in Excel can be a straightforward task, especially when you're dealing with a simple structure. An org chart can help you clearly visualize the roles, responsibilities, and hierarchy within your team or organization. This can be particularly useful for onboarding new members, strategic planning, or understanding your team's dynamics.

In this guide, we will walk you through the steps to create a simple org chart in Excel, using the built-in SmartArt feature. This feature allows you to create diagrams and graphics without needing to know complex drawing tools. Let's dive in and get started.

Understanding Excel's SmartArt Feature

The SmartArt feature in Excel enables you to create a variety of diagrams, including org charts, process diagrams, cycle diagrams, and more. It offers many pre-built layouts that can save you time and effort. For our purposes, we will use the Organization Chart layout.

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

Before we begin, ensure that your Excel version supports the SmartArt feature. It is available in Excel 2010 and later versions, both in desktop and online versions.

Accessing the SmartArt Feature

To access the SmartArt feature, go to the 'Home' tab in the Excel ribbon. In the 'Illustrations' or 'SmartArt' group (depending on your Excel version), you will see the 'SmartArt' button. Click on this button to open the SmartArt menu.

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 Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial
an excel chart with two smiley faces and the word excel in green on top of it
an excel chart with two smiley faces and the word excel in green on top of it

Alternatively, you can also right-click on a cell and select 'Insert > SmartArt' from the context menu.

Choosing the Organization Chart Layout

In the SmartArt menu, you will see various categories of diagrams. Click on the 'Organization Chart' category to view the available layouts for org charts. Choose the layout that best fits your organizational structure. For a simple org chart, the 'Hierarchy' layout is typically suitable.

Once you've selected your layout, a text pane will appear on the right side of your screen. This is where you will add your organization's name and the names of the people you want to include in your org chart.

How to Create Organizational Chart in Excel
How to Create Organizational Chart in Excel
a computer screen with a diagram on it and the words org chart hack written below
a computer screen with a diagram on it and the words org chart hack written below
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 Charts and Graphs in Excel
How To Create Charts and Graphs in Excel
Demo Start | Creately
Demo Start | Creately
Org Chart Excel & Google Sheets. Employee Structure Template. Employee Hierarchy. Organizational Chart. Org Chart. Company Org Chart.
Org Chart Excel & Google Sheets. Employee Structure Template. Employee Hierarchy. Organizational Chart. Org Chart. Company Org Chart.

Building Your Simple Org Chart

Now that you've chosen your layout, it's time to start building your org chart. The text pane is organized into a hierarchical structure, mimicking the layout of your chosen SmartArt diagram. The topmost box represents the top-level position in your organization (often the CEO or President).

To add names to your org chart, simply click in the first text box and type the name of the person you want to include. In our example, let's start with 'John Doe' at the top. Press 'Enter' on your keyboard to move to the next text box.

Adding Levels to Your Org Chart

To add levels to your org chart, such as departments or direct reports, use the 'Tab' key on your keyboard. Each press of the 'Tab' key moves you one level down in the hierarchy. For example, pressing 'Tab' once after typing 'John Doe' allows you to add the names of his direct reports, like 'Jane Smith' and 'Bob Johnson'.

How to Create Multi-Category Chart in Excel
How to Create Multi-Category Chart in Excel
Org Chart for New Employees
Org Chart for New Employees
Organizational Chart Maker
Organizational Chart Maker

To move back up one level in the hierarchy, use the 'Shift + Tab' keyboard shortcut. This can help you create a balanced and well-structured org chart.

Adding More People to Your Org Chart

To add more people to a specific level in your org chart, simply click on the text box next to the person's name you want to add more people under. For example, clicking on 'Jane Smith' allows you to add her direct reports or other colleagues from her department.

You can continue this process until your org chart is complete. Remember that you can always go back and edit names or move people around to ensure your org chart is accurate and up-to-date.

Customizing Your Org Chart

Once your org chart is complete, you can customize it to match your organization's branding or to better fit your presentation. Here are a few customization options:

  • Change the Diagram Style: In the SmartArt menu, you can click on 'Change Colors' or 'Change Styles' to change the look and feel of your org chart. This can help it stand out or blend in with your presentation materials.
  • Add or Remove Levels: You can add or remove levels from your org chart by using the 'Promote' or 'Demote' buttons in the SmartArt menu. This can help you create a more complex chart if needed.
  • Rearrange Diagram Nodes: You can also rearrange the nodes in your diagram by dragging and dropping them into new positions. This can help you create a unique layout or better illustrate your organization's structure.

Saving and Exporting Your Org Chart

When you're satisfied with your org chart, it's a good idea to save your work. You can do this by saving your Excel file as usual. However, if you want to use your org chart in another presentation or document, you might want to export it as an image.

To export your org chart as an image, simply right-click on the diagram and select 'Save as Picture' from the context menu. Choose your desired file format (like PNG or JPEG) and save the image to your desired location.

Your simple org chart is now ready to be shared with your team, management, or stakeholders. It can serve as a useful reference for your organization's structure and help promote a clear understanding of roles and responsibilities.

Word of caution: While Excel's SmartArt feature is powerful and easy to use, it may not be suitable for very complex org charts with many levels or intricate structures. If you find that your org chart needs to be more detailed or sophisticated, consider investing in dedicated org chart software or using a more powerful diagramming tool.

Now that you know how to create a simple org chart in Excel, you can harness this new skill to improve communication, collaboration, and understanding within your organization. Happy charting!