✦Template Printable Ideas Insights

"Create Excel Org Chart from List"

By

Ever found yourself in need of a concise, visual representation of your organizational hierarchy, swiftly created from a simple list in Excel? Well, you're in the right place. In this guide, we'll demystify how to create an organizational chart in Excel from a list, ensuring you're up and running in no time.

Before we dive in, let's clarify that this isn't about transforming your Excel list into an elaborate, graphically-rich organizational chart. Instead, we'll use simple shapes and lines to create a functional, easy-to-understand org chart that's perfect for internal use or quick client presentations.

Preparing Your Excel List

Before we begin crafting your org chart, ensure your list is clean and well-structured. You'll need columns for at least the following:

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

'Name': For the full name or title of each person.
'Manager': The name or title of each person's direct manager.
'Role': The person's job title or role.

Formatting Your List

For your org chart to look its best, format your list data as table. This makes insertion of the org chart more intuitive and easy to manage. In Excel, select your data, then go to 'Home' > 'Format as Table'.

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

Choose a table style that suits your needs, check 'My table has headers', and click 'OK'.

Creating Your Organizational Chart

Now that your list is ready, it's time to bring your org chart to life. Here's how:

  1. Insert the 'Organization Chart' layout under 'Insert' > 'Smart Art' > 'Relationship' category > 'Organization Chart'.
  2. Click 'Link' in the 'SmartArt' pane, then select your table as the list source.
  3. Hit 'OK' to generate your org chart.

The chart will now display your organization's hierarchy, with each person's manager appearing above them, and those who report directly to them appearing below.

How to Create an Organizational Chart in Word with Free Templates | EdrawMax
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
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
the organizational chart for an organization
the organizational chart for an organization
How to Create Org Chart in Excel (From Multiple Lists)
How to Create Org Chart in Excel (From Multiple Lists)
Create Organization Chart in Excel
Create Organization Chart in Excel
Organizational Charts in Excel | MyExcelOnline
Organizational Charts in Excel | MyExcelOnline

Customizing Your Organizational Chart

Once you've created your org chart, you might want to style it to match your company's branding or make it more engaging. Here's how:

Adjusting the Layout

You can modify the layout of your org chart by switching between the 'Organization Chart' and other layout options from the 'Design' tab of the 'SmartArt' pane.

Adding Color and Style

To change the color scheme, click on the 'Change Colors' icon in the 'Design' tab. For a more sophisticated look, explore the 'SmartArt Styles' options, including 'Reset,' 'Formation,' 'Basic,' 'Accent 1,' etc.

5+ Organization Chart Template Excel Sample | Template Business PSD, Excel, Word, PDF
5+ Organization Chart Template Excel Sample | Template Business PSD, Excel, Word, PDF
Project Management Organizational Structures | Creately
Project Management Organizational Structures | Creately
Free Organisational Chart Template
Free Organisational Chart Template

Managing Updates to Your Organizational Chart

Keeping your org chart up-to-date is crucial, especially in dynamic work environments. Here's how to handle changes:

Adding a New Employee

Simply insert a new row into your table, and place it in the correct position based on the employee's manager. Re-syncing the chart with the table will automatically add the new employee to the org chart.

Editing or Removing an Employee

To edit or remove an employee, modify the corresponding row in the table, then re-sync the chart as before. Any changes made in the table will reflect in the org chart.

The final step? Save your org chart as a separate page or section of your workbook. This helps prevent accidental modifications to your original data and keeps your org chart ready for instant access whenever you need it. Happy charting!