Creating an Effective Presentation: Integrating Excel Data Into PowerPoint for Organizational Charts

Creating an Effective Presentation: Integrating Excel Data Into PowerPoint for Organizational Charts

Christopher Lv12

Creating an Effective Presentation: Integrating Excel Data Into PowerPoint for Organizational Charts

Building an organizational chart in Excel makes sense because it’s easy to pull data from sources like other Excel documents or Outlook. When it comes time to show off that chart, you’ll probably want to use PowerPoint, though. Fortunately, bringing the Excel chart over to PowerPoint is fairly simple.

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

www.sentrypc.com

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

Kanto Player Professional

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

  • Title: Creating an Effective Presentation: Integrating Excel Data Into PowerPoint for Organizational Charts
  • Author: Christopher
  • Created at : 2024-08-28 05:41:22
  • Updated at : 2024-08-29 05:41:22
  • Link: https://win-blog.techidaily.com/creating-an-effective-presentation-integrating-excel-data-into-powerpoint-for-organizational-charts/
  • License: This work is licensed under CC BY-NC-SA 4.0.