✦Template Printable Ideas Insights

Create an Organization Chart in PowerPoint Using Excel Data

By

_streamline your organization's structure? Look no further than PowerPoint and Excel's powerful integration. In this guide, we'll walk you through step-by-step on how to create an organizational chart straight from your Excel data in PowerPoint, streamlining your presentation and organizational management.

Before we dive in, ensure you have both Excel and PowerPoint installed. For this guide, we'll use Microsoft Office 365 versions, but the steps are largely similar in other versions.

Preparing Your Data in Excel

First, let's ensure your Excel data is ready for the transfer. An org chart typically includes columns for employee names, job titles, departments, and possibly manager names for each employee. Create or update your data accordingly.

Create Org Chart
Create Org 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
How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial

For this guide, assume we've structured the data in the following way:

Name Job Title Manager Department
John Doe Software Engineer Jane Smith Engineering
Jane Smith Engineering Manager null Engineering


How to Create an Organizational Chart in Word with Free Templates | EdrawMax
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
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)
How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial

Formatting Your Data

To make the data suitable for PowerPoint's org chart feature, each manager-name cell should start with '=' followed by the employee's last name. For instance, 'Smith, Jane' for 'John Doe'.

In Excel, use the Flash Fill feature (if available) or customFormat feature to populate the manager names accurately. Here's how:

  1. Enter '=Smith, Jane' in the 'Manager' cell for 'John Doe'.
  2. Select that cell, then click on the 'AutoFormat as Table' icon in the 'Home' tab.
  3. Select 'Flash Fill' under the 'ribbon' that appears.

Excel will automatically format the rest of the 'Manager' column accordingly.

See Mahdi Abbasi’s activity on LinkedIn
See Mahdi Abbasi’s activity on LinkedIn
a blue and white organizational chart on a white background with the words financial aid organization chart
a blue and white organizational chart on a white background with the words financial aid organization chart
5+ Organization Chart Template Excel Sample | Template Business PSD, Excel, Word, PDF
5+ Organization Chart Template Excel Sample | Template Business PSD, Excel, Word, PDF
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.
Create Organization Chart in Excel
Create Organization Chart in Excel
31+ Free Organogram Templates & Organizational Charts
31+ Free Organogram Templates & Organizational Charts

Sorting Your Data

Sort your data by the 'Manager' column for your org chart to display correctly.


Creating the Organizational Chart in PowerPoint

Now that your data is prepared, let's move to PowerPoint.

41 Organizational Chart Templates (Word, Excel, PowerPoint, PSD)
41 Organizational Chart Templates (Word, Excel, PowerPoint, PSD)
5+ Organization Chart Template Excel Sample
5+ Organization Chart Template Excel Sample
Simple Organization Chart PowerPoint Tutorial – Presentation Process | Creative Presentation Ideas
Simple Organization Chart PowerPoint Tutorial – Presentation Process | Creative Presentation Ideas


Inserting the SmartArt Diagram

PowerPoint's 'SmartArt' feature is the basis for creating organizational charts. Here's how to insert it:

  1. In PowerPoint, click on 'Insert' in the ribbon.
  2. Hover over 'SmartArt' under the 'Illustrations' group.
  3. Select the 'Organization Chart' layout.


Connecting to Your Excel Data

Next, connect SmartArt to your Excel data:

  1. Click on the first rectangle in the SmartArt layout.
  2. In the 'SmartArt Tools' contextual tab, click on 'Text Panes' in the 'Create Graphic' group.
  3. Select 'Link to Excel Data'.
  4. A dialog box will open. Click on 'Browse'.
  5. Find and select your Excel file, then click 'OK'.
  6. Map the data columns ('Name', 'Job Title', 'Manager', 'Department') to the respective SmartArt fields.
  7. Click 'OK'.

The org chart will populate automatically with your Excel data. Adjust the layout and design as needed using the SmartArt tools.


And there you have it - your organizational chart created directly from your Excel data in PowerPoint. This efficient process ensures consistency and accuracy between your data and presentation, saving you time and effort.