✦Template Printable Ideas Insights

Create Organization Charts in Excel

By

Creating an organizational chart, or org chart, is a breeze in Microsoft Excel. It's a visual representation of your organization's structure and roles, ideal for keeping everyone on the same page. But can you make org charts in Excel? Absolutely, and here's a step-by-step guide to help you create one.

Before diving in, ensure you have Excel 2016 or later versions, as they offer the best org chart features. Let's explore how to create an org chart in Excel, along with some tips to make it look professional.

Preparing Your Data

First, list your organization's hierarchy in a new spreadsheet. Start with the main departments, followed by sub-departments and employees. Here's an example:

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

...
NamePositionDepartmentSub-Department
John DoePresidentExecutive
Jane Smith VP, MarketingMarketingManagement

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
Automatic Org Chart Maker: Excel Template with Photos (Ready to Print)
Automatic Org Chart Maker: Excel Template with Photos (Ready to Print)

Using the Recommended Pivot Table & Pivot Chart

Microsoft suggests using a PivotTable and PivotChart to create an org chart. However, this method has some limitations, like fixed shapes and colors for boxes, which may not reflect your organization's branding perfectly. Still, it's worth exploring if you prefer using PivotTables.

Here's how to do it: First, insert a PivotTable, then pivot the fields to create a hierarchy. Next, insert a PivotChart and format it as an organization chart. You can then customize the colors and shapes to match your organization's design standards.

Using the SmartArt Feature

A more flexible and visually pleasing option is using the SmartArt feature, which offers a wide range of layouts and customization options. To create an org chart with SmartArt:

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)
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
Create Organization Chart in Excel
Create Organization Chart in Excel
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...
Organizational Charts in Excel | MyExcelOnline
Organizational Charts in Excel | MyExcelOnline
Organizational Chart Template. Charity Organization template. Company Organization Template. Employee Structure Excel Template. Org Chart.
Organizational Chart Template. Charity Organization template. Company Organization Template. Employee Structure Excel Template. Org Chart.
  1. Select the data range in your worksheet.
  2. Click on the "Insert" tab, then select "SmartArt."
  3. Choose the "Organization Chart" layout (or any suitable layout).
  4. Excel converts your data into a SmartArt diagram, which you can now customize.

With SmartArt, you can add, remove, and rearrange boxes, change the layout, and customize the design elements to align with your branding. It also allows you to insert images, which comes in handy when you want to include department logos or headshots.

Refining Your Organization Chart

Once you've created your org chart, it's time to refine it. Here are some tips to make it look polished and professional:

Formatting and Customization

Use your organization's color scheme and fonts to ensure consistency. You can also adjust the box sizes, borders, and line thickness to emphasis or deemphasize certain roles.

41 Organizational Chart Templates (Word, Excel, PowerPoint, PSD)
41 Organizational Chart Templates (Word, Excel, PowerPoint, PSD)
31+ Free Organogram Templates & Organizational Charts
31+ Free Organogram Templates & Organizational Charts
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

Additionally, you can add shapes, connectors, and text that goes beyond the standard box-and-arrow format, making your org chart more engaging and informative.

Updating and Maintaining

Maintaining an up-to-date org chart shows you value your organization's structure and growth. Regularly review and update your chart to reflect new hires, promotions, or changes in the organizational hierarchy.

To update, simply modify the data in your spreadsheet, and the changes will reflect in your org chart. With SmartArt, you can also update the chart directly by adding, removing, or rearranging boxes.

By following these steps and employing some creative formatting, you can create a stunning org chart in Excel that showcases your organization's structure and brand. So, can you make org charts in Excel? Now you know you can, and you're well on your way to creating an impressive one!