6.4. EXCEL CHARTS6.4.1. Import Excel ChartsTHE ANNOYANCE: I can create charts in Excel, no problem. How in the world do I get them into PowerPoint? THE FIX: Copying the chart in Excel and using Edit Paste Special in PowerPoint is probably the best way. This process gives you the widest variety of formats to choose from when pasting or linking your chart to the slide. If you choose Microsoft Office Excel Object from the Paste Special list, your entire Excel workbook will be pasted into your PowerPoint presentation file. This option severs all ties to the original Excel file and enables you to work on the chart and its data directly in PowerPoint. If you've pasted your entire workbook into your presentation, you may want to right-click the chart and choose Grouping Ungroup to remove the background data from the chart before finalizing the file or sending a copy to anyone. You cannot get the data back once youve ungrouped the chart, so you probably want to do this on a copy of the presentation file, not the actual working file. Alternatively, in PowerPoint, you can select Insert Chart, click the cell in the upper-left corner of the datasheet, and choose Edit Import File. Navigate to the saved Excel file and click the Open button. In the Import Data Options dialog box, choose the appropriate chart or datasheet (see Figure 6-38). Figure 6-38. In an activated chart, select Edit Import File to import Excel data or charts into PowerPoints MSGraph.6.4.2. Pasted Charts Cause File Size IncreaseTHE ANNOYANCE: I pasted a couple of charts from Excel into my PowerPoint presentation, and my PowerPoint file size ballooned! What happened? THE FIX: When you paste charts from Excel into PowerPoint, the entire workbook is pasted into the presentation by default. If you're pasting from a large Excel file, your PowerPoint file will get big, too. If this is an issue for you, you can choose from a few different options:
6.4.3. Update Links AutomaticallyTHE ANNOYANCE: I linked some data from an Excel spreadsheet to my PowerPoint graph spreadsheet by copying the data in Excel and using Edit Paste Link on the graph datasheet. When I close the PowerPoint file and reopen it, the data links dont update. THE FIX: You can open each graph to update its link. Or you can use the free Chart Update add-in from Microsoft PowerPoint MVP Shyam Pillai (http://skp.mvps.org/download.htm). These links don't update because you've introduced MSGraph into the mix and MSGraph has to be activated before the links will update. You can eliminate this issue by creating and copying your charts in Excel. In PowerPoint, select Edit Paste Special, choose the Paste link option, and then choose Microsoft Office Excel Chart Object (see Figure 6-39). This removes MSGraph from the mix and relies solely on OLE links to Excel workbooks. Figure 6-39. If you choose the Paste link option, any updates to the data or chart must be made in the Excel file, not in PowerPoint. Be sure to keep your Excel and PowerPoint files in the same locations, or the link will break. Best practice is to place both files in the same folder before creating the link so you can easily move the folder to another computer without breaking the link.6.4.4. Prevent Linked Charts from UpdatingTHE ANNOYANCE: I have a bunch of linked Excel charts in my presentation file. Every time I open the file, it spends forever updating the links. Is it possible to update the links when I wantlike just before I go get a cup of coffee? THE FIX: Select Edit Links to specify the link behavior for OLE linked objects (see Figure 6-40). Press the Shift or Ctrl key while clicking to select more than one linked object from the list, and then choose the Manual option. Figure 6-40. The Links dialog box lets you control the link behavior of OLE linked objects.Note: Did you know the PowerPoint team at Microsoft doesn't "own" Microsoft Graph? The Excel team is actually responsible for it. Makes sense when you think about it, since Microsoft Graph is pretty much a calculation-free subset of Excel's graphing engine.
|