Helpdesk Baruch College

How to Build a PowerPoint Organizational Chart With Excel Data

Building an organizational chart in Excel makes sense due to the fact that it’s easy to draw data from resources like other Excel papers or Outlook. When it comes time to flaunt that chart, you’ll most likely wish to utilize PowerPoint, however. Luckily, bringing the Excel graph over to PowerPoint is fairly simple.

Creating the Organizational Chart in Excel

Initially, open up a brand-new Excel sheet. Head over to the “Insert” tab and select the “SmartArt” option.

The “Choose a SmartArt Graphic” window will show up. In the pane on the left-hand side, pick “Hierarchy.” You’ll see numerous various chart designs show up on the right. Select the one that matches your needs best. In this example, we’ll pick the “Name and Title Organizational Chart” option.

After you choose your graph design, a sneak peek of the graph and also the graph’s description will show up on the right-hand side of the home window. Select “OK” when you’re prepared.

Your graph will certainly now show up in the Excel sheet. Complete the pertinent info for your employee in the graph (or draw the data from various other sources). As soon as you’re ended up, you need to have something that appears like this.

Our chart consists of team members and also their respective settings. Double-check to ensure the info is correct, conserve the Excel file, then exit out.

Inserting Your Organizational Chart in PowerPoint

Now it’s time to work in PowerPoint. Open your presentation as well as relocate to the slide where you desire the organizational graph. Most likely to the “Insert” tab and select “Object.”

The “Insert Object” home window will appear. Here, choose the “Create from documents” alternative and also select “Browse.”

Go to the place of the Excel documents containing the business chart, select it, and then click “OK.”

Make certain the data course is correct and after that click “OK.”

Your organizational graph from Excel currently appears in your PowerPoint discussion! If you require to edit any one of the material inside the graph, it’s as straightforward as double-clicking the graph and also modifying the material. You’ll have complete accessibility to Excel tools when you do.

Merging the cells behind-the-scenes may additionally be a good concept, as they can be quite distracting. To do so, dual click the chart and afterwards pick every one of the cells that appear.

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

Now you’ll have a nice, tidy organizational chart in your PowerPoint presentation. All the best!

Exit mobile version
Skip to toolbar