{"id":154,"date":"2016-11-14T23:24:10","date_gmt":"2016-11-14T23:24:10","guid":{"rendered":"https:\/\/pressbooks.usnh.edu\/math502\/chapter\/using-charts-with-microsoft-word-and-microsoft-powerpoint\/"},"modified":"2023-03-24T14:26:13","modified_gmt":"2023-03-24T14:26:13","slug":"using-charts-with-microsoft-word-and-microsoft-powerpoint","status":"publish","type":"chapter","link":"https:\/\/pressbooks.usnh.edu\/mth402\/chapter\/using-charts-with-microsoft-word-and-microsoft-powerpoint\/","title":{"raw":"Using Charts with Microsoft\u00ae Word\u00ae and Microsoft\u00ae PowerPoint\u00ae","rendered":"Using Charts with Microsoft\u00ae Word\u00ae and Microsoft\u00ae PowerPoint\u00ae"},"content":{"raw":"<div class=\"textbox learning-objectives\">\n<h3>Learning Objectives<\/h3>\n<ol>\n \t<li>Learn how to paste an image of an Excel chart into a Word document.<\/li>\n \t<li>Learn how to paste a link to an Excel chart into a PowerPoint slide.<\/li>\n<\/ol>\n<\/div>\nCharts 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.\n<h2>Pasting a Chart Image into Word<\/h2>\nIf you wish to follow along, for this exercise you will need two files:\n<ul>\n \t<li><em>The Excel spreadsheet you have been working with in this chapter -- <strong>CH4 Charting<\/strong>.<\/em><\/li>\n \t<li><em>A\u00a0Word document data file --\u00a0<a href=\"https:\/\/granite.pressbooks.pub\/app\/uploads\/sites\/30\/2019\/10\/Ch4-Diversity.docx#fixme\">CH4 Diversity<\/a><\/em><\/li>\n<\/ul>\nExcel 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 \u00a0is being used in a student\u2019s written report (see <strong>Figure 2.81<\/strong>). The following steps demonstrate how to paste an image, or picture, of this chart into a Word document:\n<ol>\n \t<li>Open\u00a0<em>CH4 Diversity<\/em>. Save it as <em>CH4 Diversity in Enrollment in Community Colleges<\/em><\/li>\n \t<li>Click below the figure heading in the Word document that reads: <strong>Figure 1: Enrollment by Race<\/strong>. The image of the stacked column chart will be placed below this heading.<\/li>\n \t<li>If needed, open the Excel file you have been working with (<em>CH4 Charting)<\/em>. Activate the<strong> Enrollment by Race<\/strong> chart in the <strong>Enrollment by Race Chart<\/strong> sheet.<\/li>\n \t<li>Click the down arrow on the\u00a0<strong>Copy<\/strong> button in the <strong>Home<\/strong> tab of the ribbon. \u00a0Select\u00a0<strong>Copy as Picture<\/strong><\/li>\n \t<li>Select<strong> OK -- <\/strong>Accepting the Copy Pictures defaults:\n<ul>\n \t<li>As shown on Screen<\/li>\n \t<li>Picture<\/li>\n<\/ul>\n<\/li>\n \t<li>Go back to the <em>CH4 Diversity in Enrollment in Community Colleges<\/em>\u00a0Word document by clicking the file in the taskbar.<\/li>\n \t<li>Confirm that the insertion point is below the Figure 1: Enrollment by Race heading (see Figure 4.42) and click the <strong>Paste<\/strong> button in the Home tab of the ribbon ( or press\u00a0<strong>Crtl-V<\/strong>).<\/li>\n<\/ol>\n[caption id=\"attachment_152\" align=\"aligncenter\" width=\"649\"]<img class=\"wp-image-148 size-full\" src=\"http:\/\/pressbooks.usnh.edu\/math502\/wp-content\/blogs.dir\/12\/files\/2016\/11\/Figure-4-42.jpg\" alt=\"Insertion point is below &quot;Figure 1: Enrollment by Race&quot;\" width=\"649\" height=\"356\"> Figure 2.81 Paste Picture in Word[\/caption]\n\nOh no!! The picture is so big that it falls on to the next page. We will need to change its size.\n<ol>\n \t<li>Click anywhere on the picture of the chart to activate it.<\/li>\n \t<li>Click the <strong>Format<\/strong> tab under the <strong>Picture Tools<\/strong> section of the ribbon (see <strong>Figure 2.82<\/strong>).<\/li>\n \t<li>Click the down arrow on the <strong>Shape Width<\/strong> button in the <strong>Size<\/strong> group of commands. Continue to click the down arrow until the width of the picture is <strong>5.4<\/strong>.\" As you reduce the width of the picture, the height is automatically reduced as well. (The height should be ~\u00a0<strong>3.92\"<\/strong>)<\/li>\n \t<li>To center the chart on the page, make sure the chart is activated. \u00a0Then go to the\u00a0<strong>Home<\/strong> tab, to the <strong>Paragraph<\/strong> group,\u00a0and select\u00a0<strong>Center.<\/strong><\/li>\n \t<li>Save your work.<\/li>\n<\/ol>\n[caption id=\"attachment_152\" align=\"aligncenter\" width=\"539\"]<img class=\"wp-image-149 size-full\" src=\"http:\/\/pressbooks.usnh.edu\/math502\/wp-content\/blogs.dir\/12\/files\/2023\/03\/Figure-4-43.jpg\" alt=\"Format tab to Size group options with Shape Width field selected and 5.4&quot; entered. Height is 3.92&quot;\" width=\"539\" height=\"168\"> Figure 2.82 Changing the Size of a Picture in Word[\/caption]\n\n<strong>Figure 2.83<\/strong>\u00a0shows the final appearance of the Enrollment by Race Source chart pasted into a Word document. It is best to use either the Shape Width or Shape Height buttons to reduce the size of the chart. Using either button automatically reduces the height and width of the chart in proper proportion. If you choose to use the sizing handles to resize the chart, holding the SHIFT key while clicking and dragging on a corner sizing handle will also keep the chart in proper proportion.\n\n[caption id=\"attachment_152\" align=\"aligncenter\" width=\"518\"]<img class=\"wp-image-150 size-full\" src=\"http:\/\/pressbooks.usnh.edu\/math502\/wp-content\/blogs.dir\/12\/files\/2023\/03\/Figure-4-44.jpg\" alt=\"Word document with title at top, followed by body of text, then color chart at bottom of page.\" width=\"518\" height=\"669\"> Figure 2.83 Final Appearance of Pasting a Chart Image into Word[\/caption]\n\n<div class=\"textbox examples\">\n<h3><b>Skill<\/b><b> <\/b><b>R<\/b><b>e<\/b><b>f<\/b><b>resher<\/b><\/h3>\n<b>P<\/b><b>a<\/b><b>sting<\/b><b> <\/b><b>a<\/b><b> <\/b><b>C<\/b><b>h<\/b><b>art<\/b><b> <\/b><b>I<\/b><b>m<\/b><b>a<\/b><b>g<\/b><b>e<\/b><b> <\/b><b>i<\/b><b>n<\/b><b>t<\/b><b>o<\/b><b> <\/b><b>W<\/b><b>o<\/b><b>rd<\/b>\n<div>\n<ol>\n \t<li>Activate an Excel chart and click the Copy button in the Home tab of the ribbon.<\/li>\n \t<li>Click on the location in the Word document where the Excel chart will be pasted.<\/li>\n \t<li>Click the down arrow of the Paste button in the Home tab of the ribbon.<\/li>\n \t<li>Click the Picture option from the drop-down list.<\/li>\n \t<li>Click the Format tab in the Picture Tools section of the ribbon.<\/li>\n \t<li>Resize the picture by clicking the up or down arrow on the Shape Width or Shape Height buttons.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<h2>Pasting a Linked Chart Image into PowerPoint<\/h2>\nIf you wish to follow along, for this exercise you will need two files:\n<ul>\n \t<li><em>The Excel spreadsheet you have been working with in this chapter -- <strong>CH4 Charting<\/strong>.<\/em><\/li>\n \t<li><em>A\u00a0PowerPoint data file\u00a0\u2013\u00a0<a href=\"https:\/\/drive.google.com\/file\/d\/0B-J6TXqfqqmuQ1cweGNmaU9CckpDQThjWC0wRjM5UUNUQkYw\/view?usp=sharing\" target=\"_blank\" rel=\"noopener noreferrer\">CH4 Diversity<\/a>.<\/em><\/li>\n<\/ul>\nMicrosoft PowerPoint is perhaps the most commonly used tool for delivering live presentations. The charts used in a live presentation are critical for efficiently delivering your ideas to an audience. Similar to written documents, a wide range of presentations may require the explanation of quantitative data. This demonstration includes a PowerPoint slide that could be used in a presentation. We will paste the Enrollment by Race chart into this PowerPoint slide. However, instead of pasting an image, as demonstrated in the Word document, we will establish a link to the Excel file. As a result, if we change the chart in the Excel file, the change will be reflected in the PowerPoint file. The following steps explain how to accomplish this:\n<ol>\n \t<li>Open <em>CH4 Diversity.pptx<\/em>. Save it as <em>CH4 Diversity in Enrollment in Community Colleges<\/em>.<\/li>\n \t<li>Navigate to <strong>Slide 6<\/strong> \u2013 <strong>Diversity in Enrollment<\/strong>. This is the slide where you will place the linked chart.<\/li>\n \t<li>If needed, open the Excel file you have been working with (<em>CH4 Charting)<\/em>. Activate the<strong> Enrollment by Race<\/strong> chart in the <strong>Enrollment by Race Chart<\/strong> sheet.<\/li>\n \t<li>Click the down arrow on the\u00a0<strong>Copy<\/strong> button in the <strong>Home<\/strong> tab of the ribbon. \u00a0Select\u00a0<strong>Copy<\/strong> (not Copy as Picture.)<\/li>\n \t<li>Go back to the <em>CH4 Diversity in Enrollment in Community Colleges<\/em>\u00a0presenation\u00a0by clicking the file in the taskbar.<\/li>\n \t<li>Make sure you are still on Slide 6 - Diversity in Enrollment. Click on the <strong>outside edge<\/strong> of the empty prompt box on the right.<\/li>\n \t<li>Click the down arrow below the <strong>Paste<\/strong> button in the <strong>Home<\/strong> tab of the ribbon in the PowerPoint file.<\/li>\n \t<li>Hover over each of the Paste Options until you find <strong>Keep Source Formatting &amp; Link Data<\/strong> (see Figure 2.84). \u00a0Select this option. This pastes an image of the Excel chart into the PowerPoint slide. In addition, a link is created so that any changes made to the chart (in Excel) appear on the PowerPoint slide.<\/li>\n<\/ol>\n[caption id=\"attachment_152\" align=\"aligncenter\" width=\"603\"]<a href=\"https:\/\/openoregon.pressbooks.pub\/app\/uploads\/sites\/7\/2016\/11\/fig45.png\"><img class=\"wp-image-151 size-full\" src=\"http:\/\/pressbooks.usnh.edu\/math502\/wp-content\/blogs.dir\/12\/files\/2023\/03\/fig45.png\" alt=\"Home tab in PowerPoint to Paste drop-down menu, Paste option &quot;Keep Source Formatting &amp; Link Data&quot; selected.\" width=\"603\" height=\"498\"><\/a> Figure 2.84 Creating a Link to an Excel Chart in PowerPoint[\/caption]\n\nNext we need to make some changes to clean up the chart a bit. \u00a0First, we are going to apply a different chart style.\n<ol>\n \t<li>Click anywhere in the plot area of the column chart pasted into the PowerPoint slide. You will see the same <strong>Excel Chart Tools<\/strong> tabs added to the ribbon (see <strong>Figure 2.85<\/strong>).<\/li>\n \t<li>On the\u00a0<strong>Design<\/strong> tab, select\u00a0<strong>Style 8<\/strong> in the\u00a0<strong>Chart Style<\/strong> group.<\/li>\n<\/ol>\n[caption id=\"attachment_152\" align=\"aligncenter\" width=\"530\"]<img class=\"wp-image-152 size-full\" src=\"http:\/\/pressbooks.usnh.edu\/math502\/wp-content\/blogs.dir\/12\/files\/2023\/03\/Figure-4-46.jpg\" alt=\"Column chart selected in PowerPoint slide shows Excel Chart Tools tab in ribbon.\" width=\"530\" height=\"790\"> Figure 2.85 Modifying and Excel Chart Pasted into a PowerPoint Slide[\/caption]\n\nPaste linking this chart caused trouble with the text boxes we added, so next we are going to delete them.\n<ol>\n \t<li>Select each text box by clicking on the outside edge of the text box with the four-headed arrow. Press the delete key on your keyboard. Be sure that the insertion point is NOT blinking inside the text box. \u00a0If it is, you will be editing the contents of the text box instead of deleting the actual text box.<\/li>\n<\/ol>\nThe benefit of adding this chart to the presentation as a link\u00a0is that it will automatically update when you change the data in the linked spreadsheet file.\n<ol>\n \t<li>Return to your\u00a0<em>CH4 Charting <\/em>Excel\u00a0file.<\/li>\n \t<li>Select the <strong>Enrollment Statistics<\/strong>\u00a0worksheet (the one with the Enrollment data.) Change the value in\u00a0cell D3\u00a0to\u00a0<strong>1000<\/strong>. \u00a0You have just changed the number of white students at Clackamas Community College to <strong>1000<\/strong>. This isn\u2019t true, but you want to change the data enough to see the effect in the charts.<\/li>\n \t<li>Select the <strong>Enrollment by Race Chart<\/strong>\u00a0worksheet. Notice how the chart has changed.<\/li>\n \t<li>Return to the Diversity in Enrollment in Community Colleges PowerPoint file by clicking the file in the taskbar.<\/li>\n \t<li>On Slide6, you should see the updated chart (see <strong>Figure 2.86<\/strong>).<\/li>\n \t<li>If the chart has not changed; be sure that your chart is selected, click the <strong>Design<\/strong> tab in the <strong>Chart Tools<\/strong> section of the ribbon. Click the <strong>Refresh Data<\/strong> button. The change made in the Excel workbook is now reflected on the PowerPoint slide.<\/li>\n \t<li>If that still doesn't work, you may have created a \"normal\" link -- instead of a <strong>Paste Link<\/strong>. \u00a0Delete the chart and follow the steps again. \u00a0Start\u00a0from the beginning of this section.<\/li>\n \t<li>Save your work. \u00a0You will submit both the Word and PowerPoint files, along with the Excel file, at the end of the next section.<\/li>\n<\/ol>\n<strong>Figure 4.47<\/strong> shows the appearance of the column chart after the change was made in the Enrollment Statistics worksheet in the Excel file. Note that the Data Chart at the bottom reflects the new number, too. The change that was made in the Excel file will appear in the PowerPoint file after clicking the Refresh Data button.\n\n[caption id=\"attachment_152\" align=\"aligncenter\" width=\"1031\"]<a href=\"https:\/\/openoregon.pressbooks.pub\/app\/uploads\/sites\/7\/2016\/11\/fig47.png\"><img class=\"wp-image-153 size-full\" src=\"http:\/\/pressbooks.usnh.edu\/math502\/wp-content\/blogs.dir\/12\/files\/2023\/03\/fig47.png\" alt=\"Changes made in Excel workbook shown updated in Column chart on PowerPoint slide after refreshing.\" width=\"1031\" height=\"588\"><\/a> Figure 2.86 Styled and Updated Chart.[\/caption]\n\n<div class=\"textbox integrity\">\n<h3>Integrity Check<\/h3>\n<strong>Refreshing Linked Charts in PowerPoint and Word<\/strong>\n\nWhen creating a link to a chart in Word or PowerPoint, you must refresh the data if you make any changes in the Excel workbook. This is especially true if you make changes in the Excel file prior to opening the Word or PowerPoint file that contains a link to a chart. To refresh the chart, make sure it is activated, then click the Refresh Data button in the Design tab of the ribbon. Forgetting this step can result in old or erroneous data being displayed on the chart.\n\n<\/div>\n&nbsp;\n<div class=\"textbox integrity\">\n<h3>Integrity Check<\/h3>\n<strong>Severed Link?<\/strong>\n\nWhen creating a link to an Excel chart in Word or PowerPoint, you must keep the Excel workbook in its original location on your computer or network. If you move or delete the Excel workbook, you will get an error message when you try to update the link in your Word or PowerPoint file. You will also get an error if the Excel workbook is saved on a network drive that your computer cannot access. These errors occur because the link to the Excel workbook has been severed. Therefore, if you know in advance that you will be using a USB drive to pull up your documents or presentation, move the Excel workbook to your USB drive before you establish the link in your Word or PowerPoint file.\n\n<\/div>\n&nbsp;\n<div>\n<div class=\"textbox examples\">\n<h3><b>Skill<\/b><b> <\/b><b>R<\/b><b>e<\/b><b>f<\/b><b>resher<\/b><b>:<\/b><\/h3>\n<b>P<\/b><b>a<\/b><b>sting<\/b><b> <\/b><b>a<\/b><b> <\/b><b>Linked<\/b><b> C<\/b><b>hart<\/b><b> <\/b><b>Image<\/b><b> <\/b><b>in<\/b><b>t<\/b><b>o<\/b><b> <\/b><b>P<\/b><b>o<\/b><b>w<\/b><b>er<\/b><b>P<\/b><b>oint<\/b>\n<ol>\n \t<li>Activate an Excel chart and click the Copy button in the Home tab of the ribbon.<\/li>\n \t<li>Click in the PowerPoint slide where the Excel chart will be pasted.<\/li>\n \t<li>Click the down arrow of the Paste button in the Home tab of the ribbon.<\/li>\n \t<li>Click the Keep Source Formatting &amp; Link Data option from the drop-down list.<\/li>\n \t<li>Click the Refresh Data button in the Design tab of the ribbon to ensure any changes in the Excel file are reflected in the chart.<\/li>\n<\/ol>\n<\/div>\n&nbsp;\n\n<\/div>\n<div class=\"textbox key-takeaways\">\n<h3>Key Takeaways<\/h3>\n<ul>\n \t<li>When pasting an image of an Excel chart into a Word document or PowerPoint file, use the <strong>Picture<\/strong> option from the Paste drop-down list of options - if you want the image to act as an image. \u00a0You will not be able to make any changes to the content of the picture.<\/li>\n \t<li>When creating a link to a chart in Word or PowerPoint, you may need to refresh the data if you make any changes in the originating spreadsheet. \u00a0You should \u00a0not use the <strong>Picture<\/strong> option.<\/li>\n<\/ul>\n<\/div>\n<h2>Attribution<\/h2>\nAdapted by Noreen Brown from <a href=\"https:\/\/saylordotorg.github.io\/text_how-to-use-microsoft-excel-v1.1\/index.html\" target=\"_blank\" rel=\"noopener noreferrer\">How to Use Microsoft Excel: The Careers in Practice Series<\/a>,\u00a0adapted by <a href=\"https:\/\/www.saylor.org\" target=\"_blank\" rel=\"noopener noreferrer\">The Saylor Foundation<\/a> without attribution as requested by the work\u2019s original creator or licensee,\u00a0and licensed under <a href=\"http:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\" target=\"_blank\" rel=\"noopener noreferrer\">CC BY-NC-SA 3.0<\/a>.","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Objectives<\/h3>\n<ol>\n<li>Learn how to paste an image of an Excel chart into a Word document.<\/li>\n<li>Learn how to paste a link to an Excel chart into a PowerPoint slide.<\/li>\n<\/ol>\n<\/div>\n<p>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.<\/p>\n<h2>Pasting a Chart Image into Word<\/h2>\n<p>If you wish to follow along, for this exercise you will need two files:<\/p>\n<ul>\n<li><em>The Excel spreadsheet you have been working with in this chapter &#8212; <strong>CH4 Charting<\/strong>.<\/em><\/li>\n<li><em>A\u00a0Word document data file &#8212;\u00a0<a href=\"https:\/\/granite.pressbooks.pub\/app\/uploads\/sites\/30\/2019\/10\/Ch4-Diversity.docx#fixme\">CH4 Diversity<\/a><\/em><\/li>\n<\/ul>\n<p>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 \u00a0is being used in a student\u2019s written report (see <strong>Figure 2.81<\/strong>). The following steps demonstrate how to paste an image, or picture, of this chart into a Word document:<\/p>\n<ol>\n<li>Open\u00a0<em>CH4 Diversity<\/em>. Save it as <em>CH4 Diversity in Enrollment in Community Colleges<\/em><\/li>\n<li>Click below the figure heading in the Word document that reads: <strong>Figure 1: Enrollment by Race<\/strong>. The image of the stacked column chart will be placed below this heading.<\/li>\n<li>If needed, open the Excel file you have been working with (<em>CH4 Charting)<\/em>. Activate the<strong> Enrollment by Race<\/strong> chart in the <strong>Enrollment by Race Chart<\/strong> sheet.<\/li>\n<li>Click the down arrow on the\u00a0<strong>Copy<\/strong> button in the <strong>Home<\/strong> tab of the ribbon. \u00a0Select\u00a0<strong>Copy as Picture<\/strong><\/li>\n<li>Select<strong> OK &#8212; <\/strong>Accepting the Copy Pictures defaults:\n<ul>\n<li>As shown on Screen<\/li>\n<li>Picture<\/li>\n<\/ul>\n<\/li>\n<li>Go back to the <em>CH4 Diversity in Enrollment in Community Colleges<\/em>\u00a0Word document by clicking the file in the taskbar.<\/li>\n<li>Confirm that the insertion point is below the Figure 1: Enrollment by Race heading (see Figure 4.42) and click the <strong>Paste<\/strong> button in the Home tab of the ribbon ( or press\u00a0<strong>Crtl-V<\/strong>).<\/li>\n<\/ol>\n<figure id=\"attachment_152\" aria-describedby=\"caption-attachment-152\" style=\"width: 649px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-148 size-full\" src=\"http:\/\/pressbooks.usnh.edu\/math502\/wp-content\/blogs.dir\/12\/files\/2016\/11\/Figure-4-42.jpg\" alt=\"Insertion point is below &quot;Figure 1: Enrollment by Race&quot;\" width=\"649\" height=\"356\" srcset=\"https:\/\/pressbooks.usnh.edu\/mth402\/files\/2016\/11\/Figure-4-42.jpg 649w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2016\/11\/Figure-4-42-300x165.jpg 300w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2016\/11\/Figure-4-42-65x36.jpg 65w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2016\/11\/Figure-4-42-225x123.jpg 225w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2016\/11\/Figure-4-42-350x192.jpg 350w\" sizes=\"auto, (max-width: 649px) 100vw, 649px\" \/><figcaption id=\"caption-attachment-152\" class=\"wp-caption-text\">Figure 2.81 Paste Picture in Word<\/figcaption><\/figure>\n<p>Oh no!! The picture is so big that it falls on to the next page. We will need to change its size.<\/p>\n<ol>\n<li>Click anywhere on the picture of the chart to activate it.<\/li>\n<li>Click the <strong>Format<\/strong> tab under the <strong>Picture Tools<\/strong> section of the ribbon (see <strong>Figure 2.82<\/strong>).<\/li>\n<li>Click the down arrow on the <strong>Shape Width<\/strong> button in the <strong>Size<\/strong> group of commands. Continue to click the down arrow until the width of the picture is <strong>5.4<\/strong>.&#8221; As you reduce the width of the picture, the height is automatically reduced as well. (The height should be ~\u00a0<strong>3.92&#8243;<\/strong>)<\/li>\n<li>To center the chart on the page, make sure the chart is activated. \u00a0Then go to the\u00a0<strong>Home<\/strong> tab, to the <strong>Paragraph<\/strong> group,\u00a0and select\u00a0<strong>Center.<\/strong><\/li>\n<li>Save your work.<\/li>\n<\/ol>\n<figure id=\"attachment_152\" aria-describedby=\"caption-attachment-152\" style=\"width: 539px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-149 size-full\" src=\"http:\/\/pressbooks.usnh.edu\/math502\/wp-content\/blogs.dir\/12\/files\/2023\/03\/Figure-4-43.jpg\" alt=\"Format tab to Size group options with Shape Width field selected and 5.4&quot; entered. Height is 3.92&quot;\" width=\"539\" height=\"168\" srcset=\"https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/Figure-4-43.jpg 539w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/Figure-4-43-300x94.jpg 300w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/Figure-4-43-65x20.jpg 65w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/Figure-4-43-225x70.jpg 225w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/Figure-4-43-350x109.jpg 350w\" sizes=\"auto, (max-width: 539px) 100vw, 539px\" \/><figcaption id=\"caption-attachment-152\" class=\"wp-caption-text\">Figure 2.82 Changing the Size of a Picture in Word<\/figcaption><\/figure>\n<p><strong>Figure 2.83<\/strong>\u00a0shows the final appearance of the Enrollment by Race Source chart pasted into a Word document. It is best to use either the Shape Width or Shape Height buttons to reduce the size of the chart. Using either button automatically reduces the height and width of the chart in proper proportion. If you choose to use the sizing handles to resize the chart, holding the SHIFT key while clicking and dragging on a corner sizing handle will also keep the chart in proper proportion.<\/p>\n<figure id=\"attachment_152\" aria-describedby=\"caption-attachment-152\" style=\"width: 518px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-150 size-full\" src=\"http:\/\/pressbooks.usnh.edu\/math502\/wp-content\/blogs.dir\/12\/files\/2023\/03\/Figure-4-44.jpg\" alt=\"Word document with title at top, followed by body of text, then color chart at bottom of page.\" width=\"518\" height=\"669\" srcset=\"https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/Figure-4-44.jpg 518w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/Figure-4-44-232x300.jpg 232w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/Figure-4-44-65x84.jpg 65w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/Figure-4-44-225x291.jpg 225w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/Figure-4-44-350x452.jpg 350w\" sizes=\"auto, (max-width: 518px) 100vw, 518px\" \/><figcaption id=\"caption-attachment-152\" class=\"wp-caption-text\">Figure 2.83 Final Appearance of Pasting a Chart Image into Word<\/figcaption><\/figure>\n<div class=\"textbox examples\">\n<h3><b>Skill<\/b><b> <\/b><b>R<\/b><b>e<\/b><b>f<\/b><b>resher<\/b><\/h3>\n<p><b>P<\/b><b>a<\/b><b>sting<\/b><b> <\/b><b>a<\/b><b> <\/b><b>C<\/b><b>h<\/b><b>art<\/b><b> <\/b><b>I<\/b><b>m<\/b><b>a<\/b><b>g<\/b><b>e<\/b><b> <\/b><b>i<\/b><b>n<\/b><b>t<\/b><b>o<\/b><b> <\/b><b>W<\/b><b>o<\/b><b>rd<\/b><\/p>\n<div>\n<ol>\n<li>Activate an Excel chart and click the Copy button in the Home tab of the ribbon.<\/li>\n<li>Click on the location in the Word document where the Excel chart will be pasted.<\/li>\n<li>Click the down arrow of the Paste button in the Home tab of the ribbon.<\/li>\n<li>Click the Picture option from the drop-down list.<\/li>\n<li>Click the Format tab in the Picture Tools section of the ribbon.<\/li>\n<li>Resize the picture by clicking the up or down arrow on the Shape Width or Shape Height buttons.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<h2>Pasting a Linked Chart Image into PowerPoint<\/h2>\n<p>If you wish to follow along, for this exercise you will need two files:<\/p>\n<ul>\n<li><em>The Excel spreadsheet you have been working with in this chapter &#8212; <strong>CH4 Charting<\/strong>.<\/em><\/li>\n<li><em>A\u00a0PowerPoint data file\u00a0\u2013\u00a0<a href=\"https:\/\/drive.google.com\/file\/d\/0B-J6TXqfqqmuQ1cweGNmaU9CckpDQThjWC0wRjM5UUNUQkYw\/view?usp=sharing\" target=\"_blank\" rel=\"noopener noreferrer\">CH4 Diversity<\/a>.<\/em><\/li>\n<\/ul>\n<p>Microsoft PowerPoint is perhaps the most commonly used tool for delivering live presentations. The charts used in a live presentation are critical for efficiently delivering your ideas to an audience. Similar to written documents, a wide range of presentations may require the explanation of quantitative data. This demonstration includes a PowerPoint slide that could be used in a presentation. We will paste the Enrollment by Race chart into this PowerPoint slide. However, instead of pasting an image, as demonstrated in the Word document, we will establish a link to the Excel file. As a result, if we change the chart in the Excel file, the change will be reflected in the PowerPoint file. The following steps explain how to accomplish this:<\/p>\n<ol>\n<li>Open <em>CH4 Diversity.pptx<\/em>. Save it as <em>CH4 Diversity in Enrollment in Community Colleges<\/em>.<\/li>\n<li>Navigate to <strong>Slide 6<\/strong> \u2013 <strong>Diversity in Enrollment<\/strong>. This is the slide where you will place the linked chart.<\/li>\n<li>If needed, open the Excel file you have been working with (<em>CH4 Charting)<\/em>. Activate the<strong> Enrollment by Race<\/strong> chart in the <strong>Enrollment by Race Chart<\/strong> sheet.<\/li>\n<li>Click the down arrow on the\u00a0<strong>Copy<\/strong> button in the <strong>Home<\/strong> tab of the ribbon. \u00a0Select\u00a0<strong>Copy<\/strong> (not Copy as Picture.)<\/li>\n<li>Go back to the <em>CH4 Diversity in Enrollment in Community Colleges<\/em>\u00a0presenation\u00a0by clicking the file in the taskbar.<\/li>\n<li>Make sure you are still on Slide 6 &#8211; Diversity in Enrollment. Click on the <strong>outside edge<\/strong> of the empty prompt box on the right.<\/li>\n<li>Click the down arrow below the <strong>Paste<\/strong> button in the <strong>Home<\/strong> tab of the ribbon in the PowerPoint file.<\/li>\n<li>Hover over each of the Paste Options until you find <strong>Keep Source Formatting &amp; Link Data<\/strong> (see Figure 2.84). \u00a0Select this option. This pastes an image of the Excel chart into the PowerPoint slide. In addition, a link is created so that any changes made to the chart (in Excel) appear on the PowerPoint slide.<\/li>\n<\/ol>\n<figure id=\"attachment_152\" aria-describedby=\"caption-attachment-152\" style=\"width: 603px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/openoregon.pressbooks.pub\/app\/uploads\/sites\/7\/2016\/11\/fig45.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-151 size-full\" src=\"http:\/\/pressbooks.usnh.edu\/math502\/wp-content\/blogs.dir\/12\/files\/2023\/03\/fig45.png\" alt=\"Home tab in PowerPoint to Paste drop-down menu, Paste option &quot;Keep Source Formatting &amp; Link Data&quot; selected.\" width=\"603\" height=\"498\" srcset=\"https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/fig45.png 603w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/fig45-300x248.png 300w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/fig45-65x54.png 65w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/fig45-225x186.png 225w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/fig45-350x289.png 350w\" sizes=\"auto, (max-width: 603px) 100vw, 603px\" \/><\/a><figcaption id=\"caption-attachment-152\" class=\"wp-caption-text\">Figure 2.84 Creating a Link to an Excel Chart in PowerPoint<\/figcaption><\/figure>\n<p>Next we need to make some changes to clean up the chart a bit. \u00a0First, we are going to apply a different chart style.<\/p>\n<ol>\n<li>Click anywhere in the plot area of the column chart pasted into the PowerPoint slide. You will see the same <strong>Excel Chart Tools<\/strong> tabs added to the ribbon (see <strong>Figure 2.85<\/strong>).<\/li>\n<li>On the\u00a0<strong>Design<\/strong> tab, select\u00a0<strong>Style 8<\/strong> in the\u00a0<strong>Chart Style<\/strong> group.<\/li>\n<\/ol>\n<figure id=\"attachment_152\" aria-describedby=\"caption-attachment-152\" style=\"width: 530px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-152 size-full\" src=\"http:\/\/pressbooks.usnh.edu\/math502\/wp-content\/blogs.dir\/12\/files\/2023\/03\/Figure-4-46.jpg\" alt=\"Column chart selected in PowerPoint slide shows Excel Chart Tools tab in ribbon.\" width=\"530\" height=\"790\" srcset=\"https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/Figure-4-46.jpg 530w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/Figure-4-46-201x300.jpg 201w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/Figure-4-46-65x97.jpg 65w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/Figure-4-46-225x335.jpg 225w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/Figure-4-46-350x522.jpg 350w\" sizes=\"auto, (max-width: 530px) 100vw, 530px\" \/><figcaption id=\"caption-attachment-152\" class=\"wp-caption-text\">Figure 2.85 Modifying and Excel Chart Pasted into a PowerPoint Slide<\/figcaption><\/figure>\n<p>Paste linking this chart caused trouble with the text boxes we added, so next we are going to delete them.<\/p>\n<ol>\n<li>Select each text box by clicking on the outside edge of the text box with the four-headed arrow. Press the delete key on your keyboard. Be sure that the insertion point is NOT blinking inside the text box. \u00a0If it is, you will be editing the contents of the text box instead of deleting the actual text box.<\/li>\n<\/ol>\n<p>The benefit of adding this chart to the presentation as a link\u00a0is that it will automatically update when you change the data in the linked spreadsheet file.<\/p>\n<ol>\n<li>Return to your\u00a0<em>CH4 Charting <\/em>Excel\u00a0file.<\/li>\n<li>Select the <strong>Enrollment Statistics<\/strong>\u00a0worksheet (the one with the Enrollment data.) Change the value in\u00a0cell D3\u00a0to\u00a0<strong>1000<\/strong>. \u00a0You have just changed the number of white students at Clackamas Community College to <strong>1000<\/strong>. This isn\u2019t true, but you want to change the data enough to see the effect in the charts.<\/li>\n<li>Select the <strong>Enrollment by Race Chart<\/strong>\u00a0worksheet. Notice how the chart has changed.<\/li>\n<li>Return to the Diversity in Enrollment in Community Colleges PowerPoint file by clicking the file in the taskbar.<\/li>\n<li>On Slide6, you should see the updated chart (see <strong>Figure 2.86<\/strong>).<\/li>\n<li>If the chart has not changed; be sure that your chart is selected, click the <strong>Design<\/strong> tab in the <strong>Chart Tools<\/strong> section of the ribbon. Click the <strong>Refresh Data<\/strong> button. The change made in the Excel workbook is now reflected on the PowerPoint slide.<\/li>\n<li>If that still doesn&#8217;t work, you may have created a &#8220;normal&#8221; link &#8212; instead of a <strong>Paste Link<\/strong>. \u00a0Delete the chart and follow the steps again. \u00a0Start\u00a0from the beginning of this section.<\/li>\n<li>Save your work. \u00a0You will submit both the Word and PowerPoint files, along with the Excel file, at the end of the next section.<\/li>\n<\/ol>\n<p><strong>Figure 4.47<\/strong> shows the appearance of the column chart after the change was made in the Enrollment Statistics worksheet in the Excel file. Note that the Data Chart at the bottom reflects the new number, too. The change that was made in the Excel file will appear in the PowerPoint file after clicking the Refresh Data button.<\/p>\n<figure id=\"attachment_152\" aria-describedby=\"caption-attachment-152\" style=\"width: 1031px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/openoregon.pressbooks.pub\/app\/uploads\/sites\/7\/2016\/11\/fig47.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-153 size-full\" src=\"http:\/\/pressbooks.usnh.edu\/math502\/wp-content\/blogs.dir\/12\/files\/2023\/03\/fig47.png\" alt=\"Changes made in Excel workbook shown updated in Column chart on PowerPoint slide after refreshing.\" width=\"1031\" height=\"588\" srcset=\"https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/fig47.png 1031w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/fig47-300x171.png 300w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/fig47-1024x584.png 1024w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/fig47-768x438.png 768w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/fig47-65x37.png 65w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/fig47-225x128.png 225w, https:\/\/pressbooks.usnh.edu\/mth402\/files\/2023\/03\/fig47-350x200.png 350w\" sizes=\"auto, (max-width: 1031px) 100vw, 1031px\" \/><\/a><figcaption id=\"caption-attachment-152\" class=\"wp-caption-text\">Figure 2.86 Styled and Updated Chart.<\/figcaption><\/figure>\n<div class=\"textbox integrity\">\n<h3>Integrity Check<\/h3>\n<p><strong>Refreshing Linked Charts in PowerPoint and Word<\/strong><\/p>\n<p>When creating a link to a chart in Word or PowerPoint, you must refresh the data if you make any changes in the Excel workbook. This is especially true if you make changes in the Excel file prior to opening the Word or PowerPoint file that contains a link to a chart. To refresh the chart, make sure it is activated, then click the Refresh Data button in the Design tab of the ribbon. Forgetting this step can result in old or erroneous data being displayed on the chart.<\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<div class=\"textbox integrity\">\n<h3>Integrity Check<\/h3>\n<p><strong>Severed Link?<\/strong><\/p>\n<p>When creating a link to an Excel chart in Word or PowerPoint, you must keep the Excel workbook in its original location on your computer or network. If you move or delete the Excel workbook, you will get an error message when you try to update the link in your Word or PowerPoint file. You will also get an error if the Excel workbook is saved on a network drive that your computer cannot access. These errors occur because the link to the Excel workbook has been severed. Therefore, if you know in advance that you will be using a USB drive to pull up your documents or presentation, move the Excel workbook to your USB drive before you establish the link in your Word or PowerPoint file.<\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<div>\n<div class=\"textbox examples\">\n<h3><b>Skill<\/b><b> <\/b><b>R<\/b><b>e<\/b><b>f<\/b><b>resher<\/b><b>:<\/b><\/h3>\n<p><b>P<\/b><b>a<\/b><b>sting<\/b><b> <\/b><b>a<\/b><b> <\/b><b>Linked<\/b><b> C<\/b><b>hart<\/b><b> <\/b><b>Image<\/b><b> <\/b><b>in<\/b><b>t<\/b><b>o<\/b><b> <\/b><b>P<\/b><b>o<\/b><b>w<\/b><b>er<\/b><b>P<\/b><b>oint<\/b><\/p>\n<ol>\n<li>Activate an Excel chart and click the Copy button in the Home tab of the ribbon.<\/li>\n<li>Click in the PowerPoint slide where the Excel chart will be pasted.<\/li>\n<li>Click the down arrow of the Paste button in the Home tab of the ribbon.<\/li>\n<li>Click the Keep Source Formatting &amp; Link Data option from the drop-down list.<\/li>\n<li>Click the Refresh Data button in the Design tab of the ribbon to ensure any changes in the Excel file are reflected in the chart.<\/li>\n<\/ol>\n<\/div>\n<p>&nbsp;<\/p>\n<\/div>\n<div class=\"textbox key-takeaways\">\n<h3>Key Takeaways<\/h3>\n<ul>\n<li>When pasting an image of an Excel chart into a Word document or PowerPoint file, use the <strong>Picture<\/strong> option from the Paste drop-down list of options &#8211; if you want the image to act as an image. \u00a0You will not be able to make any changes to the content of the picture.<\/li>\n<li>When creating a link to a chart in Word or PowerPoint, you may need to refresh the data if you make any changes in the originating spreadsheet. \u00a0You should \u00a0not use the <strong>Picture<\/strong> option.<\/li>\n<\/ul>\n<\/div>\n<h2>Attribution<\/h2>\n<p>Adapted by Noreen Brown from <a href=\"https:\/\/saylordotorg.github.io\/text_how-to-use-microsoft-excel-v1.1\/index.html\" target=\"_blank\" rel=\"noopener noreferrer\">How to Use Microsoft Excel: The Careers in Practice Series<\/a>,\u00a0adapted by <a href=\"https:\/\/www.saylor.org\" target=\"_blank\" rel=\"noopener noreferrer\">The Saylor Foundation<\/a> without attribution as requested by the work\u2019s original creator or licensee,\u00a0and licensed under <a href=\"http:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\" target=\"_blank\" rel=\"noopener noreferrer\">CC BY-NC-SA 3.0<\/a>.<\/p>\n","protected":false},"author":11,"menu_order":8,"template":"","meta":{"pb_show_title":"","pb_short_title":"","pb_subtitle":"","pb_authors":["noreen-brown","barbara-lave","julie-romey","mary-schatz","diane-shingledecker"],"pb_section_license":"cc-by"},"chapter-type":[49],"contributor":[63,66,64,65,62],"license":[53],"class_list":["post-154","chapter","type-chapter","status-publish","hentry","chapter-type-numberless","contributor-barbara-lave","contributor-diane-shingledecker","contributor-julie-romey","contributor-mary-schatz","contributor-noreen-brown","license-cc-by"],"part":30,"_links":{"self":[{"href":"https:\/\/pressbooks.usnh.edu\/mth402\/wp-json\/pressbooks\/v2\/chapters\/154","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pressbooks.usnh.edu\/mth402\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/pressbooks.usnh.edu\/mth402\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/pressbooks.usnh.edu\/mth402\/wp-json\/wp\/v2\/users\/11"}],"version-history":[{"count":1,"href":"https:\/\/pressbooks.usnh.edu\/mth402\/wp-json\/pressbooks\/v2\/chapters\/154\/revisions"}],"predecessor-version":[{"id":155,"href":"https:\/\/pressbooks.usnh.edu\/mth402\/wp-json\/pressbooks\/v2\/chapters\/154\/revisions\/155"}],"part":[{"href":"https:\/\/pressbooks.usnh.edu\/mth402\/wp-json\/pressbooks\/v2\/parts\/30"}],"metadata":[{"href":"https:\/\/pressbooks.usnh.edu\/mth402\/wp-json\/pressbooks\/v2\/chapters\/154\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/pressbooks.usnh.edu\/mth402\/wp-json\/wp\/v2\/media?parent=154"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/pressbooks.usnh.edu\/mth402\/wp-json\/pressbooks\/v2\/chapter-type?post=154"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/pressbooks.usnh.edu\/mth402\/wp-json\/wp\/v2\/contributor?post=154"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/pressbooks.usnh.edu\/mth402\/wp-json\/wp\/v2\/license?post=154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}