powerpoint 发布_如何使用Excel数据构建PowerPoint组织结构图

powerpoint 发布

powerpoint 发布

powerpoint logo

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.

在Excel中构建组织结构图很有意义,因为很容易从其他Excel文档或Outlook等来源中提取数据。 但是,当需要炫耀该图表时,您可能会想要使用PowerPoint。 幸运的是,将Excel图表带到PowerPoint相当简单。

在Excel中创建组织结构图 (Creating the Organizational Chart in Excel)

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

首先,打开一个新的Excel工作表。 转到“插入”标签,然后选择“ SmartArt”选项。

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.

出现“选择SmartArt图形”窗口。 在左侧窗格中,选择“层次结构”。 您会在右侧看到几种不同的图表样式。 选择最适合您的需求。 在此示例中,我们将选择“名称和标题组织结构图”选项。

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.

您的图表现在将出现在Excel工作表中。 在图表中为您的团队成员填写相关信息(或从其他来源提取数据)。 完成后,您应该会看到类似以下的内容。

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.

我们的图表包括团队成员及其各自的职位。 仔细检查以确保信息正确,保存Excel文件,然后退出。

在PowerPoint中插入组织结构图 (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.”

现在是时候在PowerPoint中工作了。 打开您的演示文稿,然后移至需要组织结构图的幻灯片。 转到“插入”标签,然后选择“对象”。

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.”

转到包含组织结构图的Excel文件的位置,将其选中,然后单击“确定”。

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.

Excel中的组织结构图现在显示在PowerPoint演示文稿中! 如果您需要编辑图表中的任何内容,只需双击图表并编辑内容即可。 完成后,您将拥有对Excel工具的完全访问权限。

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!

现在,您的PowerPoint演示文稿中将有一个漂亮,整洁的组织结构图。 祝好运!

翻译自: https://www.howtogeek.com/402680/how-to-build-a-powerpoint-organizational-chart-with-excel-data/

powerpoint 发布

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值