Excel to PowerPoint Org Chart: Build and Update It

To make an Excel org chart in PowerPoint, organize the people and reporting relationships in Excel, then create a hierarchy SmartArt graphic in PowerPoint and enter the names in reporting order. You can also build the SmartArt in Excel and copy it to PowerPoint; Excel does not automatically turn an ordinary employee-and-manager table into a finished org chart.

What Excel and PowerPoint can do

An org chart is a hierarchy diagram: boxes represent roles or people, and connectors show who reports to whom. Excel can hold the source information and can create SmartArt diagrams, while PowerPoint is often better for presenting the finished chart on a slide. Neither application automatically maintains a live connection between a normal list of employees in cells and a SmartArt org chart.

That distinction matters. If a manager changes in the spreadsheet, the chart will not reliably rearrange itself just because the two files are open. You must update the diagram, rebuild it, or use a specialized data-driven tool. For a small team or a chart that changes occasionally, SmartArt is a straightforward built-in option. For a large organization or frequent changes, a diagramming tool designed to read data may be more suitable.

Prepare the reporting data in Excel

Start with one row per person or position. A useful table has columns such as Employee, Title, Department, and Reports to. Use a consistent name for each manager in the Reports to column, and leave that field blank for the organization’s top role. For example, a table might show Jordan Lee as Managing Director with no manager, Casey Morgan as Sales Manager reporting to Jordan Lee, and Sam Patel as Account Executive reporting to Casey Morgan.

Before drawing, check that the relationships make sense. Every person other than the top role should have a manager, each manager should appear in the employee list, and there should be no circular reporting chain. A cycle occurs if A reports to B while B, directly or indirectly, reports back to A. Also decide whether the diagram represents people, positions, or both. A position-based chart can be more durable when someone leaves, but it needs clear labels so viewers do not mistake a vacant role for a named employee.

Remove accidental duplicate records and inconsistent spellings of the same manager’s name.
Keep the reporting field separate from department or location; those categories do not necessarily define hierarchy.
Choose a concise label format, such as name on the first line and title on the second.
Keep a copy of the original table as the source of truth, especially if the chart will be revised later.

Build the org chart in PowerPoint

In PowerPoint for Microsoft 365 on Windows, open the presentation and choose Insert > SmartArt > Hierarchy > Organization Chart, then select OK. Click the text-pane arrow at the left edge of the SmartArt graphic to show its outline, or use the SmartArt Design tab’s Text Pane command when it is available. Enter the top person first, then add direct reports and their teams beneath them in the correct outline levels.

In the SmartArt text pane, press Enter to add another item at the same level. Press Tab to make the current item a subordinate of the preceding item, and Shift+Tab to move it up a level. For instance, enter the director, press Enter and type a manager, press Tab before entering that manager’s report, and use Shift+Tab when returning to another direct report of the director. Check the visual result as you go: outline indentation represents reporting hierarchy, not merely a visual preference.

You can also create the SmartArt in Excel using Insert > SmartArt > Hierarchy > Organization Chart, fill it in, and copy it into the PowerPoint slide. In either application, select the chart before copying. In PowerPoint, use Ctrl+C and Ctrl+V on Windows; on a Mac, use Command+C and Command+V. After pasting, inspect the paste options: a SmartArt object may remain editable, while pasting as a picture preserves its appearance but turns the whole chart into an image. The exact choices can depend on the source and destination content.

Turn a flat employee list into a hierarchy

A table with Employee and Reports to columns is a useful source, but it is not itself the indented outline SmartArt expects. First identify the top person, then group each manager’s direct reports beneath that manager. Do not rely on alphabetical sorting to create the tree: people who work in the same department can report to different managers, and a manager’s name may appear in several rows.

For a small chart, you can use the table as a checklist while entering the outline manually. For a larger chart, prepare a separate ordered list before typing it into SmartArt. One clear outline could be Managing Director, with Sales Manager and Operations Manager beneath; indent the Sales Manager’s reports under Sales Manager, and the Operations Manager’s reports under Operations Manager. Include a person’s title in the label if the audience may not recognize names alone.

When the organization has several levels, build and verify one branch at a time. Compare each branch with the Reports to column and check that every employee appears exactly once. This catches a common error: entering a person under the correct department but under the wrong manager. If a role is vacant, label it explicitly as vacant rather than leaving an unexplained empty box.

Format the chart for a presentation

After entering the hierarchy, select the graphic to display the contextual SmartArt Design and Format tabs. SmartArt Design includes options such as Change Colors, SmartArt Styles, and layout choices. Keep the visual style restrained: use color to distinguish meaningful groups, not to imply reporting authority unless that is intentional. Consistent box wording and readable type are more useful than decorative effects.

Organization charts can become crowded quickly. A chart with many branches may be easier to read across several slides, with one overview slide and separate slides for large departments. Avoid shrinking type until the whole company fits on one page. If a slide needs to be printed, check the actual page size and print preview; text that looks readable on a monitor can become too small on paper.

SmartArt can reposition boxes as you add entries, but the resulting layout may not match the arrangement you had in mind. Use the chart’s built-in hierarchy layouts and adjust the slide design around the diagram before resorting to many manual shape edits. Extensive manual repositioning can make later edits less convenient, particularly if new reports must be added.

Move the chart and choose how to paste it

Copying the SmartArt graphic itself is usually the simplest route when you want the chart on a slide. Once it is in PowerPoint, test whether you can select and edit individual boxes. If you need a fixed visual that should not shift during presentation, paste or export a picture instead. A picture is also useful when sharing with someone who only needs to view the chart, but it cannot be updated by editing its individual names or reporting lines.

There is a difference between copying a diagram and embedding an Excel worksheet. An embedded worksheet is intended to preserve spreadsheet content inside a presentation; it is not the same as an editable org-chart SmartArt object. For a clean slide, prefer the SmartArt graphic or a picture, depending on whether editing or visual stability matters more. Keep the original workbook separately so that the underlying employee list remains available.

On a Mac, the same general SmartArt approach is available in current desktop Office apps, though ribbon placement and labels can vary by release. Use Command+C and Command+V instead of the Windows Ctrl shortcuts. If the PowerPoint or Excel web app does not show the SmartArt controls or paste choices you need, open the files in the desktop apps; feature availability and editing options can differ between desktop and browser versions.

Keep the spreadsheet and slide in sync

Because a standard SmartArt chart is not a live view of the Excel table, establish a small update process. Record when the chart was last checked, retain the source workbook, and compare the chart against the current reporting list before distributing it. For a recurring monthly or quarterly update, designate one person to make the changes and verify them. This reduces the risk that a slide deck continues to show someone’s old manager after the spreadsheet has been corrected.

If only a few people change, editing the existing SmartArt may be quickest. Open the text pane, correct the affected names or outline levels, and then review the connectors and branches. If a reorganization changes many relationships, rebuilding the outline from the current table can be safer than making scattered edits. In either case, check that all names, titles, and reporting lines match the approved source before presenting or sharing the file.

Common problems and practical alternatives

The boxes are in the wrong branch: Review the text-pane indentation and compare each person with the Reports to column. A person’s department is not proof of their manager.
The chart is too crowded: Split it into an overview and detail slides, shorten labels carefully, or show only the levels relevant to the audience.
The pasted chart is no longer editable: It was likely pasted as a picture. Return to the source SmartArt and copy it again, choosing an editable paste option if PowerPoint offers one.
The chart changes when a name is edited: SmartArt can rearrange boxes to fit text. Shorten the label or give the chart more space rather than making all text unreadably small.

For a one-time or modest org chart, SmartArt is often sufficient and is included in the Office applications; there is no separate org-chart purchase required beyond access to those apps. If you need repeatable generation from a large data set, automatic layout, or more detailed diagram controls, consider a dedicated diagramming product such as Microsoft Visio. Its availability and licensing depend on the plan and version, and it still requires checking that the source data is structured correctly. A manually drawn set of PowerPoint shapes is another option for a very small chart with unusual design needs, but it takes more effort to keep aligned and maintain.

Frequently Asked Questions

Can Excel automatically create an org chart from an employee list?
Not from an ordinary employee-and-manager table with a single automatic conversion. Excel can create a hierarchy SmartArt graphic, but you generally need to arrange the names into the correct outline levels yourself or use a data-driven diagramming tool.

Can I link an Excel org chart to PowerPoint so it updates automatically?
A standard SmartArt org chart copied from Excel is not a live, automatically updating connection to the employee table. Treat the spreadsheet as the source and update or rebuild the PowerPoint diagram when the reporting data changes.

Is SmartArt or a chart better for an org chart?
Use SmartArt’s Hierarchy category, not a standard Excel data chart. A conventional chart is designed to plot values such as dates or totals; an org chart needs boxes and reporting relationships.

How do I add another person under a manager?
Select the SmartArt graphic, open its text pane, and add the person at the appropriate outline level. You can also select a box and use SmartArt Design > Add Shape to add a subordinate or another connected role, then verify the resulting position.

Can I edit the org chart after copying it to PowerPoint?
Usually, if it was pasted as SmartArt or another editable object. If it was pasted as a picture, its names and connectors cannot be edited separately; copy the source SmartArt again using an editable paste option.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.