✦Template Printable Ideas Insights

How to Add an Organizational Chart in Excel

By

In today's businesses, clear organizational structure is crucial for effective communication and decision-making. Microsoft Excel, a versatile tool, can help display this structure visually with an organizational chart. Here's a step-by-step guide on how to insert an organizational chart in Excel.

Before we begin, ensure you're using a version of Excel that supports this feature, such as Excel 2010 or later. Now, let's dive into the process.

Preparing Your Data

Before creating the chart, you'll need to organize your data. Your data should include department names, sub-departments, and employee names. A simple way to structure this is: cells A1 to A3 should have department names, B1 to B3 should have sub-departments, and C1 to C3 should have employee names.

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

For example, your data might look like this:

Department Sub-department Employee
HR Recruitment John Doe
Finance Accounts Jane Smith

Creating the Organizational Chart

Once your data is ready, you can create the chart. Here's how:

an excel spreadsheet showing the number and type of items that are in each column
an excel spreadsheet showing the number and type of items that are in each column
Organizational Charts in Excel | MyExcelOnline
Organizational Charts in Excel | MyExcelOnline
the organizational chart for an organization
the organizational chart for an organization

1. Highlight your data, including the headers.

2. In the 'Insert' tab, under 'Illustrations,' click on 'Organization Chart.'

Formatting Your Chart

After inserting the chart, you'll see two boxes: 'Chart Layout' and 'Chart Elements.' Using these, you can add, remove, or rearrange elements to customize your chart.

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

1. To add a shape, select it in the 'Chart Elements' box, then click in the chart where you want to place it.

2. To move a shape, click and drag it to a new location.

Adding More Levels to Your Chart

For larger organizations, you might need to add more levels to your chart. Here's how to do that:

Your Excel Dictionary (@exceldictionary) on Threads
Your Excel Dictionary (@exceldictionary) on Threads
#exceltips #excelfunctions #xlookup #excelautomation #dataanalysis #corporateexcel #worksmart #excelproductivity #excelebook #impressyourboss | Excel Baba
#exceltips #excelfunctions #xlookup #excelautomation #dataanalysis #corporateexcel #worksmart #excelproductivity #excelebook #impressyourboss | Excel Baba
Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know
Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know

1. In your data, add a new row for the next level. For example, under 'Recruitment,' add a new row with 'Interviews' as the sub-department.

2. In the chart, move the 'Recruitment' box to its new level.

Printing or Saving Your Chart

Once your chart is perfect, you can print it or save it as an image:

1. To print, click 'File' then 'Print.'

2. To save as an image, right-click the chart and select 'Save as Picture.'

Creating an organizational chart in Excel can help clarify your organization's structure and improve communication. With these steps, you're well on your way to presenting your data effectively. Now, go ahead and give it a try!