4.3 Using Charts with Microsoft® Word® and Microsoft® PowerPoint®
4.3 Using Charts with Microsoft® Word® and Microsoft® PowerPoint®
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 on this chapter — CH4 Charting.
- A Word document data file — CH4 CC Enrollment
Excel charts can be valuable tools for explaining quantitative data in a written report. Reports that address business plans, public policies, budgets, and so. For this example, we will assume that the total enrollment per state from the Enrollment Statistics Map chart is being used in a student’s written report. (see Figure 4.26). The following steps demonstrate how to paste an image, or picture, of this chart into a Word document:
- Open CH4 CC Enrollment. Save it as CH4 Enrollment Totals Per State.
- Move your cursor to the bottom of the document by clicking below the heading that reads: Figure 1: Enrollment by State. The image of the Map chart will be placed below this heading.
- If needed, open the Excel file you have been working with (CH4 Charting). Activate the Map chart.
- On the Home tab of the ribbon. Click the Copy button dropdown arrow and select Copy as Picture.
- Select OK — Accepting the Copy Pictures defaults:
- As shown on Screen
- Picture
- Go back to the CH4 Enrollment Totals Per State Word document.
- Confirm that the insertion point is below Figure 1: Enrollment by State heading, click the Paste button in the Home tab of the ribbon ( or press Crtl-V).
- Note the picture of the Map chart will need to be resized. Resize the image by slowly dragging one of the corner sizing handles so it’s large enough to fill space below the text on the first page. Make sure the image does not spill over to the next page. This document should be one page only.
- Save your work.
Skill Refresher
Pasting a Chart Image into Word
- Activate an Excel chart and click the Copy button in the Home tab of the ribbon.
- Click on the location in the Word document where the Excel chart will be pasted.
- Click the down arrow of the Paste button in the Home tab of the ribbon.
- Click the Picture option from the drop-down list.
- Click the Format tab in the Picture Tools section of the ribbon.
- Resize the picture by clicking the up or down arrow on the Shape Width or Shape Height buttons.
Pasting a Linked Chart Image into PowerPoint
For this exercise you will need two files:
- The Excel s