57 10.3 Integrating Excel® with Word® and PowerPoint® (21/13) -- Excel

57 10.3 Integrating Excel® with Word® and PowerPoint® Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn Learning Objectives - Learn how to paste an image of an Excel chart into a Word document. - Learn how to paste a link to an Excel chart into a PowerPoint slide. Charts that are created in Excel are commonly used in Microsoft Word documents or for presentations that use Microsoft PowerPoint slides. Excel provides options for pasting an image of a chart into either a Word document or a PowerPoint slide. You can also establish a link to your Excel charts so that if you change the data in your Excel file, it is automatically reflected in your Word or PowerPoint files. We will demonstrate both methods in this section. Pasting a Chart Image into Word For this exercise you will need two files: - The Excel spreadsheet you have been working with during the Charts & Graphs chapter: CH4 Charting. - A Word document data file — CH4 Diversity Excel charts can be valuable tools for explaining quantitative data in a written report. Reports that address business plans, public policies, budgets, and so on all involve quantitative data. For this example, we will assume that the Change in Enrollment Statistics Spend Source stacked column chart is being used in a student’s written report (see Figure 10.3.1). The following steps demonstrate how to paste an image, or picture, of this chart into a Word document: - Using the data given in the figure 10.3.1 below, add a sheet to your workbook that uses the data found in the figure for ethnicity at these three colleges. - Create a pipe chart showing enrollment by ethnicity. - Open CH4 Diversity. Save it as CH4 Diversity in Enrollment in Community Colleges - Click below the figure heading in the Word document that reads: Figure 1: Enrollment by Race. The image of the stacked column chart will be placed below this heading. - If needed, open the Excel file you have been working with (CH4 Charting). Activate the Enrollment by Race chart in the Enrollment by Race Chart sheet. If you don’t have this chart, you can use another chart from this file. - Click the down arrow on the Copy button in the Home tab of the ribbon. Select Copy as Picture - Select OK — Accepting the Copy Pictures defaults: - As shown on Screen - Picture - Go back to the CH4 Diversity in Enrollment in Community Colleges Word document by clicking the file in the taskbar. - Confirm that the insertion point is below the Figure 1: Enrollment by Race heading (see Figure 10.3.2) and click the Paste button in the Home tab of the ribbon ( or press Crtl-V). Oh no!! The picture is so big that it falls on to the next page. We will need to change its size. - Click anywhere on the picture of the chart to activate it. - Click the Format tab under the Picture Tools section of the ribbon (see Figure 10.3.2). - Click the down arrow on the Shape Width button in the Size group of commands. Continue to click the down arr