安慶會(huì)計(jì)繼續(xù)教育網(wǎng)：Excel2007新知-PowerPoint和Word中的圖表

高頓網(wǎng)校友情提示，*7安慶會(huì)計(jì)繼續(xù)教育網(wǎng)上總結(jié)信息Excel2007新知-PowerPoint和Word中的圖表等內(nèi)容公布如下：
　　圖表四：PowerPoint和Word中的圖表

　　One thing we know is that many of the charts that folks created in Excel end up in PowerPoint presentations or Word documents (I think the statistic is that 50% of all charts in PowerPoint presentations originate from Excel.  While users work in Excel to analyze their data, the final results are often given to others, and they rarely want to include all the intermediate steps from Excel.  Furthermore, users have all kinds of solutions to transfer their charts.  Most just use copy and paste, but some use Excel’s copy as picture command, or write VBA solutions, to update their charts in various ways.  In Office 2007, our goal was to make copying and pasting charts into PowerPoint and Word as easy as possible.  We also wanted the resulting charts to be as easy to use in PowerPoint and Word as they are in Excel, and we wanted to address a lot of problematic *s that existed in current versions of Office when you moved charts from Excel to PowerPoint one way or another.  Today I am going to briefly review the work that we did in this area.

　　我們知道有很多圖表是在Excel中創(chuàng)建，然后在PowerPoint或 Word中使用（我覺(jué)得PowerPoint中大約有50%的圖表是來(lái)自Excel的）。當(dāng)用戶使用Excel進(jìn)行數(shù)據(jù)分析時(shí),最后的報(bào)表往往不包含中間步驟，而是將最終結(jié)果交給別人。 此外,用戶還會(huì)使用各種各樣的方式傳遞圖表。最多的就是使用拷貝和粘貼，也有些用戶會(huì)用Excel的“復(fù)制為圖片”命令,或?qū)慥BA解決方案,以各種方式來(lái)更新圖表。在Office 2007中, 我們的目標(biāo)是使復(fù)制并粘貼圖表到PowerPoint 和Word中易如反掌。我們也希望此圖表在PowerPoint 和Word中的使用與在Excel中一樣方便。在當(dāng)前Office版本中，當(dāng)你用某種方式移動(dòng)Excel圖表到PowerPoint中時(shí)，我們要解決很多問(wèn)題。今天我想簡(jiǎn)單地回顧一下這方面的內(nèi)容。
 

　　At the core of all the improvements we have made in this area, charts in PowerPoint 2007 and Word 2007 are just like charts in Excel 2007.  They are native objects in PowerPoint and Word, just like they are in Excel, and as a result, the user experience and * is pretty much identical in all three applications.  They have the same themes, chart types, layouts, and styles that were discussed in the last article.  They even have almost the identical ribbons and dialogs as Excel 2007.  Here is a screenshot of charting in Word 2007 in a near-beta-2 build.  You can see how this is identical to what we looked at in Excel 2007 last week.

　　我們?cè)谶@方面改進(jìn)的核心是：在PowerPoint 2007和Word 2007中使用圖表有如在Excel中使用圖表。在PowerPoint和Word中圖表是默認(rèn)對(duì)象,就像在Excel中一樣。在三種不同的應(yīng)用程序中其制作方法和過(guò)程基本相同，他們有同樣的源數(shù)據(jù)，圖表類型,布局和風(fēng)格，也有與Excel 2007幾乎相同的Ribbon和對(duì)話框。 這是一張Word 2007 beta-2的圖表截圖, 你可以看到這與我們上一篇里Excel 2007圖表是多么相似。

　　(Click to enlarge)

　　The chart’s default theme will come from the presentation or document, just as it does from the spreadsheet’s theme in Excel.  This ensures that your charts will match the rest of your document, whichever of the three applications you are using.

　　For Office developers, the entire chart object model from Excel is now available for charts in Word and PowerPoint too.  With a few modifications, it’s possible to migrate solutions that used the Microsoft Graph object model over to the new charts, although you can keep using Graph should you not want to migrate your code.

　　圖表的默認(rèn)源數(shù)據(jù)將來(lái)自幻燈片或文檔,就象Excel中源數(shù)據(jù)來(lái)自工作表一樣。 這保證你的圖表與文檔相符合, 你用三個(gè)應(yīng)用程序中的無(wú)論哪一個(gè)進(jìn)行Office開(kāi)發(fā),整個(gè)Excel圖表對(duì)象模型現(xiàn)在也可在Word和PowerPoint中應(yīng)用。會(huì)有一些修改,新的圖表移植解決方案中會(huì)使用微軟的圖表對(duì)象模型,雖然可以繼續(xù)使用圖表，但是不能移植代碼。
 

　　There is one big difference, of course, between charts in Excel and charts in Word and PowerPoint – Word and PowerPoint don’t have a grid for the data.  The solution to that in Office 2007 is to use Excel for the chart data in all three applications.  When you create a chart in PowerPoint, PowerPoint and Excel tile side by side.  You can type the data in Excel, and watch the chart update in PowerPoint. Better still, you can use the full power of Excel for all charts, including formulas, connections to external data sources, and sorting & filtering.  When you are done entering the data, you can close Excel, and PowerPoint will return to full size.  In this case, the Excel spreadsheet containing your data is embedded in your PowerPoint document in case you need to edit it later.

　　在Excel中作圖與在Word 和PowerPoint中作圖有一個(gè)很大的不同：Word 和PowerPoint沒(méi)有數(shù)據(jù)表格。在Office 2007中解決這個(gè)問(wèn)題的辦法是在這三個(gè)應(yīng)用程序中都使用Excel表格作為數(shù)據(jù)源。當(dāng)你在PowerPoint中創(chuàng)建圖表時(shí)Excel和PowerPoint的標(biāo)題欄會(huì)并列顯示。 你可以在Excel中輸入數(shù)據(jù),在PowerPoint中觀看圖表的更新。 更好的是,你可以充分利用Excel的所有功能來(lái)表現(xiàn)圖表,包括公式、連接外部數(shù)據(jù)源,排序和篩選。當(dāng)你輸完數(shù)據(jù),你可以關(guān)閉Excel，PowerPoint將恢復(fù)實(shí)際大小。在這種情況下,包含了數(shù)據(jù)的Excel表格是內(nèi)嵌在PowerPoint中的，以后如果需要可以隨時(shí)進(jìn)行修改。

　　(Click to enlarge)

　　You can also have a chart with data linked to an external file.  This allows you to update your document with the latest data from your spreadsheet, whenever you wish.  It also lets you share a document with someone else, without them needing the spreadsheet containing your calculations. They can even change the presentation and the chart formatting, and then you can update the data later.  We think this is a valuable scenario.  For those familiar with OLE linking & embedding for charts in previous versions of PowerPoint, it is important to remember that the chart is always part of the presentation, it is only the data that linked or embedded.  Therefore, you can edit the chart fully in PowerPoint – you only need the embedded or linked spreadsheet when you try to edit the data.  All of the above also applies to Word.

　　您也可以將圖表數(shù)據(jù)源與外部數(shù)據(jù)連接。只要你愿意，你就可以更新文檔為*7數(shù)據(jù)表。你也可與別人共享文件,他們需要你的數(shù)據(jù)計(jì)算。他們甚至可以改變幻燈片和圖表格式,然后就可以更新數(shù)據(jù)。我們認(rèn)為這是一個(gè)很有價(jià)值的情況. 對(duì)于前在一個(gè)PowerPoint版本中熟悉的Ole連結(jié)和內(nèi)嵌圖表, 圖表是幻燈片中重要的一部分，這只是數(shù)據(jù)連結(jié)和內(nèi)嵌。因此, 當(dāng)你要編輯數(shù)據(jù)時(shí)，你完全可以在PowerPoint中編輯圖表，只需要連結(jié)和內(nèi)嵌數(shù)據(jù)表就行了。以上也適用于Word.
 

　　The primary way to transfer a chart from Excel to PowerPoint or Word is by copying them in Excel and pasting them into the presentation or document. This is a full fidelity paste – the chart will look exactly the same as it did in Excel. It is also the same on screen and when printed.  No more funny sizing problems, and because the chart is a native object in PowerPoint, all the PowerPoint features and tools just work.

　　When you paste the chart into PowerPoint or Word from Excel, a smart tag appears that gives you several different paste options.
 

　　將Excel圖表轉(zhuǎn)移到Word 和PowerPoint的主要方法是在Excel中復(fù)制，然后粘貼到幻燈片或文檔中。 這是最完全的復(fù)制：圖表與Excel中的完全相同。 不管是屏幕顯示還是打印效果都一樣。更沒(méi)有尺寸的問(wèn)題,因?yàn)閳D表是PowerPoint的默認(rèn)對(duì)象,所有PowerPoint的工具和特性都正常。當(dāng)你將Excel圖表粘貼到Word 和PowerPoint時(shí)，會(huì)顯示智能標(biāo)簽,讓你選擇不同的選項(xiàng)。

　　The second and third choices are to have embedded or linked data (as described in the previous section).  The last two choices also allow you to choose between the theme in the source spreadsheet, and the theme in the destination document.  You can keep your chart exactly as you had it in Excel, or make it automatically match the rest of your presentation.  The first choice allows you to choose to paste the chart as a picture in PNG format.  In that case, the chart can no longer be edited.

　　第二和第三個(gè)選項(xiàng)是選擇連接或嵌入數(shù)據(jù)(如前一節(jié))。最后兩個(gè)選項(xiàng)是讓你選擇這個(gè)圖表的源數(shù)據(jù)是在數(shù)據(jù)表還是在目標(biāo)文件中。你可以顯示圖表與Excel中一樣,或者自動(dòng)配合你的幻燈片。*9個(gè)選項(xiàng)讓你選擇粘貼圖表為PNG格式. 在這種情況下,就不能再編輯圖表了。
 

　　Some of you may be wondering what happened to Microsoft Graph.  Microsoft Graph still exists in Office 2007, and it’s identical to previous versions (meaning that none of the improvements to charting have been added to Microsoft Graph). Users of Microsoft Graph in Microsoft Access, for example, will find nothing has changed.  Microsoft Word documents in “compatibility mode”(more on what that is in a later post) continue to use Microsoft Graph as well.  PowerPoint and Word users who don’t have Excel will also get Microsoft Graph.  Finally, users can continue to use Insert Object to insert a Microsoft Graph object into any OLE application.
 

　　你可能有些奇怪Microsoft Graph發(fā)生了什么變化。Microsoft Graph在Office 2007中仍然存在,它的前幾個(gè)版本都相同(即Microsoft Graph沒(méi)有任何改進(jìn)). Microsoft Graph用戶在使用微軟Access時(shí),認(rèn)為一切都沒(méi)有改變. 微軟Word文檔在"兼容模式"時(shí)(更多的東西,后面繼續(xù)討論。)繼續(xù)利用Microsoft Graph較好. PowerPoint和Word用戶即使沒(méi)有Excel也可通過(guò)Microsoft Graph制作圖表。最后,用戶可以繼續(xù)使用插入一個(gè)Microsoft Graph對(duì)象到任何OLE應(yīng)用程序。
 

　　I’ve talked about and emphasized that workbooks on the client look as similar as possible in the browser.  Charts, too, can be generated on the server.  Currently, Excel services does not support 3D charts, and it does not support all of the OfficeArt formatting options from the client.  However, charts in the browser have a high degree of fidelity with charts in Excel.

　　圖表和Excel服務(wù)器

　　我們主要討論：在客戶機(jī)上的工作簿在瀏覽器中顯示。圖表也可以在服務(wù)器上生成。目前, Excel服務(wù)器并不支持3D圖表,也不支持OfficeArt格式的所有選項(xiàng)。不過(guò),在瀏覽器中的圖表與Excel圖表是非常接近的。

 　　　　

　　掃一掃微信，學(xué)習(xí)實(shí)務(wù)技巧

　　高頓網(wǎng)校特別提醒：已經(jīng)報(bào)名2014年財(cái)會(huì)考試的考生可按照復(fù)習(xí)計(jì)劃有效進(jìn)行！另外，高頓網(wǎng)校2014年財(cái)會(huì)考試高清課程已經(jīng)開(kāi)通，通過(guò)針對(duì)性地講解、訓(xùn)練、答疑、模考，對(duì)學(xué)習(xí)過(guò)程進(jìn)行全程跟蹤、分析、指導(dǎo)，可以幫助考生全面提升備考效果。