✦Template Printable Ideas Insights

"Add New Employee to Excel Org Chart"

By

Streamlining organizational management is a breeze with Microsoft Excel, especially when it comes to visualizing your company's structure. If you're wondering "How to add to org chart in Excel?", you're in the right place. We'll demystify the process and guide you through creating an org chart, step by step.

Before we dive in, ensure you have Microsoft Excel installed on your computer. We'll be using Excel 2016 for this guide, but the steps are similar in other versions unless otherwise stated.

Preparation: Organizing Your Data

Before you start creating the org chart, organize your team's or department's hierarchical data in a simple table. For instance, create columns for names, job titles, and direct reports' 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

Here's an example of how your data should look:

Name Job Title Direct Reports
John Doe CEO Jane Smith, Bob Johnson
Jane Smith CMO Alice Brown

Using SmartArt

The SmartArt feature in Excel allows you to convert your table data into an org chart. Here's how:

the organizational chart for an organization
the organizational chart for an organization
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 Create an Organizational Chart Linked to Data in Excel (Easy & Dynamic)
How to Create an Organizational Chart Linked to Data in Excel (Easy & Dynamic)

1. Select your table and click on the 'Insert' tab in the ribbon. In the 'Illustrations' group, click 'SmartArt'.

Using Organization Chart Layout

Excel offers a specific organization chart layout. Follow these steps:

1. Under 'Choose a SmartArt graphic' pop-up, select 'Organization Chart'. Then, click 'OK' to convert your data into an org chart.

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
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)
Create Organization Chart in Excel
Create Organization Chart in Excel
How To Create Charts and Graphs in Excel
How To Create Charts and Graphs in Excel
Excel Automatic Org Chart Generator
Excel Automatic Org Chart Generator

Customizing Your Org Chart

After inserting the SmartArt, you can customize it to match your company's branding. Add colors, change fonts, or adjust bullet point styles.

To replace shapes with photos, follow these steps:

1. Right-click on the text box you want to replace. Select 'Add Shape'.

How to Create Multi-Category Chart in Excel
How to Create Multi-Category Chart in Excel
Make a Diagram in Microsoft Office using Lucidchart
Make a Diagram in Microsoft Office using Lucidchart
How to create a progress chart.#excel #microsoft #microsoftexcel #office #word #o #powerpoint.
How to create a progress chart.#excel #microsoft #microsoftexcel #office #word #o #powerpoint.

2. Choose 'Picture' and select the photo from your computer. Resize it to fit the shape and click 'OK'.

Promoting and Demoting Boxes

To reflect hierarchical changes, follow these steps to promote or demote boxes:

1. Right-click on the box you want to promote or demote. Select 'Promote' to move the box up in the hierarchy or 'Demote' to move it down.

Adding or Deleting Levels

Managers can leave or new ones can join, so you'll need to add or delete levels occasionally. Here's how:

1. Right-click on any box, then select 'Add Shape' to add a new level or 'Delete Shape' to remove one.

And there you have it! Your org chart is now ready to serve as a visual guide for your team's hierarchy. Keep it up-to-date to ensure everyone is on the same page. Regularly review and adjust the chart as needed to reflect changes and maintain your team's success.