✦Template Printable Ideas Insights

Easy Guide: Create a Free Organizational Chart in 2022

By

Creating an organizational chart is an essential step in understanding and communicating the structure of your team or company. While professional software can cost money, there are free alternatives available that can help you create effective organizational charts without breaking the bank. In this guide, we'll explore how to make an organizational chart for free using two popular, no-cost tools: Microsoft Excel and Google Sheets.

Organizational charts help improve communication, clarify roles, and streamline decision-making processes. Whether you're a team leader, project manager, or HR professional, understanding how to create an organizational chart can greatly benefit your organization. Let's dive into the process using the aforementioned tools.

Using Microsoft Excel to Create an Organizational Chart

Microsoft Excel is a powerful spreadsheet program that offers a wide range of formatting and visual Automation tools. While it's not primarily designed for creating diagrams, you can still produce a simple and functional organizational 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
Free Organisational Chart Template
Free Organisational Chart Template
How to Create an Organizational Chart in Word
How to Create an Organizational Chart in Word

Before starting, ensure you have the latest version of Microsoft Excel installed on your computer or use the web-based version available with Microsoft 365.

Manually Creating an Organizational Chart in Excel

To create an organizational chart in Excel, you'll need to use the built-in shapes and formatting tools. Here's a step-by-step guide to help you:

FREE 21+ Sample Church Organizational Chart templates in PDF | Google Docs | Pages | MS Word
FREE 21+ Sample Church Organizational Chart templates in PDF | Google Docs | Pages | MS Word
45+ Free Organizational Chart Template In All File Formats | Mous Syusa
45+ Free Organizational Chart Template In All File Formats | Mous Syusa
an info sheet with many different types of boats in it
an info sheet with many different types of boats in it
  • Open a new or existing workbook in Excel.
  • Click on the Insert tab, then select Shapes and choose the Rectangle shape.
  • Draw a rectangle on the sheet, representing the first level of your organization (e.g., the CEO).
  • Repeat the process to add more levels, using different shapes like circles, lines, or arrows to connect boxes.
  • Customize your chart by adding text, changing colors, or adjusting sizes using the Home, fonts, Shape Fill, and Shape Outline tools.

While this method allows you to create an organizational chart, it can be time-consuming for large organizations. The next section introduces a more efficient way to create an org chart in Excel.

Using the OrgChart add-in in Excel

Microsoft's OrgChart add-in for Excel simplifies the process of creating organizational charts. Unfortunately, it's not a default feature, so you'll need to download and install it separately. Here's how to get started:

  1. Download and install the OrgChart for Excel add-in.
  2. In Excel, click on the Developer tab (if it's not visible, go to File > Options > Customize Ribbon and check Developer).
  3. Click on OrgChart and select Create to launch the OrgChart Editor.
  4. Enter the names and hierarchy of your employees, then select Generate Chart.
  5. Customize your chart using the tools provided, then click Close to return to Excel.

By using the OrgChart add-in, you can create more elaborate and well-structured organizational charts in less time.

an organization chart is shown with squares and rectangles on the bottom left side
an organization chart is shown with squares and rectangles on the bottom left side
25+ FREE Editable Organizational Chart Templates - Besty Templates
25+ FREE Editable Organizational Chart Templates - Besty Templates
Church Organizational Chart Template in PDF, Pages, Word, Google Docs - Download | Template.net
Church Organizational Chart Template in PDF, Pages, Word, Google Docs - Download | Template.net
Free Organizational Chart Template
Free Organizational Chart Template
Template Free Printables
Template Free Printables
the construction project organizational chart is shown in this graphic diagram, it shows how to create an organization map
the construction project organizational chart is shown in this graphic diagram, it shows how to create an organization map

Creating an Organizational Chart using Google Sheets

Google Sheets is a free, web-based spreadsheet application that's easy to use and accessible from anywhere. Although it lacks some advanced features found in Excel, it still allows you to create simple organizational charts.

To get started, log in to your Google Account, open a new or existing sheet, and follow the manual or add-on methods below.

Manually Creating an Organizational Chart in Google Sheets

Google Sheets doesn't have a specific org chart feature, so you'll need to use the drawing tools to create one manually. Here's how:

Blank Organizational Charts - 13 Free PDF Printables | Printablee
Blank Organizational Charts - 13 Free PDF Printables | Printablee
Restaurant Staff Organizational Chart Template in Google Docs, Word, PDF, Pages - Download | Template.net
Restaurant Staff Organizational Chart Template in Google Docs, Word, PDF, Pages - Download | Template.net
Hierarchy and Organizational Chart Diagrams For PowerPoint
Hierarchy and Organizational Chart Diagrams For PowerPoint
  • Click on Insert > Drawing to open the drawing panel.
  • Select the Line or Arrow tool to create lines and connectors between boxes.
  • Use the Rectangle or Circle tool to draw boxes, and the Text box tool to add text.
  • Format your chart by changing line colors, arrow styles, and text fonts using the Drawing panel's tools.
  • Position your chart elements using the cursor or by inputting specific coordinates in the Position & Size section of the Drawing panel.

While this method offers limited functionality, it's sufficient for creating simple organizational charts. The next section introduces an add-on that simplifies the process.

Using the orgchart for Google Sheets add-on

The orgchart for Google Sheets add-on helps you create professional-looking organizational charts with ease. Here's how to use it:

  1. Open your Google Sheet and click on Add-ons > Get Add-ons.
  2. Search for orgchart for Google Sheets, click on it, and select + FREE to install the add-on.
  3. Open your data in a list format, with one employee per row and including 'Name', 'Reports to', and other relevant information (e.g., job title, department).
  4. Select the range of your data, then click on Add-ons > orgchart for Google Sheets > Create orgchart.
  5. Customize your chart with colors, styles, and shapes using the add-on's interface, then click Create.

With the orgchart for Google Sheets add-on, you can produce well-structured and visually appealing organizational charts tailored to your needs.

In today's digital age, creating an organizational chart for free has never been more accessible. By leveraging the capabilities of Excel and Google Sheets, along with their respective add-ons, you can design effective org charts that help optimize your workflow, improve communication, and foster a better understanding of your organizational structure. Try these tools and methods today to start reaping the benefits of a well-structured and well-understood organizational hierarchy.