Build a PowerPoint Organizational Chart With Excel Data - - Windows Tips and Tricks with Geek

Sunday, November 14, 2021

Build a PowerPoint Organizational Chart With Excel Data

 powerpoint logo

Creating the Organizational Chart in Excel

First, open a new Excel sheet. Head over to the “Insert” tab and select the “SmartArt” option.

Insert SmartArt in Excel

The “Choose a SmartArt Graphic” window will appear. In the pane on the left-hand side, select “Hierarchy.” You’ll see several different chart styles appear on the right. Choose the one that suits your needs best. In this example, we’ll choose the “Name and Title Organizational Chart” option.

Heirarchy Art

After you select your chart style, a preview of the chart and the chart’s description will appear on the right-hand side of the window. Select “OK” when you’re ready.

smart art description

Your chart will now appear in the Excel sheet. Fill out the relevant information for your team members in the chart (or pull the data from other sources). Once you’re finished, you should have something that looks like this.

organization chart - excel

Our chart includes team members and their respective positions. Double-check to make sure the information is correct, save the Excel file, then exit out.

Inserting Your Organizational Chart in PowerPoint

Now it’s time to work in PowerPoint. Open up your presentation and move to the slide where you want the organizational chart. Go to the “Insert” tab and select “Object.”

insert object

The “Insert Object” window will appear. Here, choose the “Create from file” option and select “Browse.”

create from file

Go to the location of the Excel file containing the organizational chart, select it, and then click “OK.”

Browse PC for excel file

Make sure the file path is correct and then click “OK.”

insert excel file in powerpoint

Your organizational chart from Excel now appears in your PowerPoint presentation! If you need to edit any of the content inside the chart, it’s as simple as double-clicking the chart and editing the content. You’ll have full access to Excel tools when you do.

Merging the cells in the background may also be a good idea, as they can be quite distracting. To do so, double click the chart and then select all of the cells that appear.

O the “Home” tab, select “Merge & Center.”

merge and center

Now you’ll have a nice, clean organizational chart in your PowerPoint presentation. Good luck!

No comments:

Post a Comment