Excel2007新知：有關圖表的一些釋疑

Excel2007新知：有關圖表的一些釋疑

譯者：hxhgxy?? 來源：http://blogs.msdn.com/excel 發表于：2006年7月7日

Some Words About Charting 有關圖表的一些釋疑

Over the past few months, when I have posted information about charting in Office 2007, there has been plenty of feedback and discussion about the work presented.? Today, I wanted to spend a bit of time addressing some of that feedback. 在過去的幾個月里，當我發表有關Office 2007圖表的信息時，總是有非常多對現有工作的反饋和討論。今天，我想花些時間來解答其中的一些反饋。

When I read over the feedback, especially the feedback that resulted from the survey post last week, it seems to fall into three categories: 1. Why did you not add (insert your most important chart feature here) in Office 2007? 2. There is too much of an emphasis on “eye candy” in the features that you did add to Charting in Office 2007. 3. The styles that you have shown us are not “professional”. 當我看這些反饋，特別是從上周發表的調查中來的反饋時，它們可以歸為三類： 1. 你為什么不在Office 2007里面添加（在這里插入你最重要的圖表功能）？ 2. 在你添加到Office 2007圖表的功能中，對“eye candy”（譯者：可以理解為吸眼球的東西，或者是養眼的東西。Candy原意為糖果。）強調太多了。 3. 你給我們演示的樣式并不“專業”。

Here are a few thoughts on each of those items that will, hopefully, at least help everyone understand how we ended up where we are. 對于每條反饋，這是我們的一些想法，希望，至少能夠幫助每個人理解我們如何停止在我們現在的程度。

Why did you not add (insert your most important chart feature here) in Office 2007? 你為什么不在Office 2007里面添加（在這里插入你最重要的圖表功能）？

We are very aware that there is customer demand for new features in charting – new chart types, better integration with Word & PowerPoint, more control over the layout of charts, more capabilities within charts, better visuals (e.g.? anti aliasing, color schemes), better PivotCharts/a more “interactive” experience, conditional formatting, support for bigger data sets, and so on.? Over time, our goal is to deliver a great many of those features while maintaining decent backwards compatibility with the hundreds of millions of charts that our customers have created over the last 20 years.? That said, the work required to deliver all those features and maintain backwards compatibility is much bigger than would ever fit in any single release of Office, so we need to sequence the work over a period of time.? 我們很明白用戶對圖表新功能的需求——新的圖表類型，與Word和PowerPoint更好的結合，對圖表層次的更多控制，圖表更強大的能力，更好的視覺效果（例如，防止混淆，顏色方案），更好的數據透視圖表/更多的“相互作用”，條件格式，支持更大的數據，等等。隨著時間的過去，我們的目標是保留對我們用戶在過去20年來創造的無數中圖表的恰當向后兼容性的同時，也實施這些大量的新功能。這意味著，要實施這些功能并且保持向后兼容性的東西，會比Office中任何合適的單一版本大得多，因此，我們需要一段時間在一步一步實施該工作。

So how will sequencing work?? This release, we made a number of architectural changes so that we would have a solid foundation on which to build the next several releases of charting features.? Specifically, we significantly updated the charting engine and hooked into a cross-Office “rendering” platform (that’s fancy talk for “code that draws the shapes and text that makes up charts”).? This is the work that allowed us to make charts native objects in Word and PowerPoint, just like they are in Excel.? This is also the work that gave us better looking drawing of charts (anti aliasing, better text, and the other visual effects).? Because all the other features we hope to add to charts will be built on top of this foundation, we needed to get the foundation completed before we could start adding other features.? Along the way this release, we also redesigned the UI to accommodate the new ribbon and dialog architecture, which was part of a broad cross-Office initiative. 那么，如何部署該工作？在該版本里，我們做了大量的結構上的改變，這樣一來，我們就有了堅實的基礎，可以在下幾個版本中創建新的圖表功能。特別是，我們對圖表引擎做了重大的改變，并且將其與Office之間的“表演”平臺掛上鉤了（這就是那個有趣的話題“編寫代碼來繪制圖形或文本來裝扮圖表”）。這東西允許我們將圖表變成Word或PowerPoint里本身的控件，就像它們在Excel里一樣。這東西也給我們提供更好的圖表外觀（防止混淆，更好的文本，以及其它的視覺效果）。因為我們希望添加到圖表的所有這些功能會在該基礎上構建，所以，我們在能夠開始添加其它功能之前，需要完成該基礎。連同該版本，我們也重新設計了UI，以適應新的彩帶和對話框結構，它們是涵蓋整個Office之間的新東西。

The key point here is that we are aware there is a broad set of features customers want us to add to Office, and we hope to add them over time.? At some future point, I hope to figure out a way to solicit the opinions of the thousands of people that read this blog on which charting features we should focus on next. 這里所說的關鍵是，我們明白用戶希望我們添加大量的功能，而我們希望一步一步添加。對于一些進一步的東西，我希望找到一個方法來征求閱讀本博克的成千上萬的觀眾的意見，我們下一步應該關注哪些圖表功能。

There is too much of an emphasis on “eye candy” in the features that you did add to Charting in Office 2007. 在你添加到Office 2007圖表的功能中，對“eye candy”強調太多了。

This is related to the discussion above.? Charts in Office 2007 are built using a shared Office drawing layer.? We used this shared drawing layer so that charts could be native objects in any application, which is a long-standing customer request, and also because the shared drawing layer allowed us to draw very good-looking charts (meaning things like anti-aliased lines), which is another long-standing customer request.? Because the shared layer is used for more than just charts – it is also used for drawing objects, Word Art, effects in PowerPoint, etc. – the layer has plenty of modern visual capabilities which the chart engine then inherits for free, essentially.? Because these capabilities exist, we have exposed them to some extent in the chart UI.? While we understand not everyone is interested in effects like gradients and shadows, that is not universally true – for example, customers often request modern graphic effects in charts in PowerPoint.? 這個與上面的討論相關。Office 2007里的圖表是使用共享的Office繪圖層創建的。我們使用該共享的繪圖層，以至于圖表在任何應用軟件中都可以成為其本土控件，這是用戶長期以來的請求；同時，也因為共享的繪圖層讓我們可以繪制非常好看的圖表（有意思的東西，如防止混淆的線），這是用戶的另一個長期以來的請求。因為該共享繪圖層不僅用圖表上——也用在繪圖對象，藝術字，PowerPoint效果，等等——所以該繪圖層具有大量的現代視覺功能，圖表引擎可以從本質上免費繼承它。因為這些功能已經存在，我們只是將其擴展到圖表UI里面。然而，我們理解并不是每個人都對梯度效果和陰影效果感興趣，這不是普遍真實的——例如，用戶經常要求在PowerPoint圖表里使用時髦的圖形效果。

The key point here is that the “eye candy” available in charts is part of the platform that we built charts upon, so it is not like we had to “trade off” other charting features to implement these effects – they are simply part of the platform.? Additionally, while some of these visual effects may not be something in great demand in Excel, they are something that has appeal in other Office applications.? Finally, we have been careful to try and provide a balance between styles that apply these effects and simple, straightforward styles that do not … and in most cases, the defaults are the simple, straightforward styles. 這里所表達的關鍵是，圖表中可用的“eye candy”是我們在創建圖表的平臺上的一部分，因此，并不是好像我們要“賣掉”其它的圖表功能來實現這些效果——它們只是該平臺的一部分而已。另外，也許某些這種視覺效果在Excel里并不是非常的需要，它們是其它Office應用軟件要求的東西。最后，我們仔細嘗試了并且提供了在應用這些效果和簡單直接的、不應用這些效果之間的平衡。

The styles that you have shown us are not “professional” (or how you can help us make Office 2007 charts better) 你給我們演示的樣式并不“專業”（或者說，你如何幫助我們使Office 2007圖表更好）

Chart styles are part of a larger initiative across Office 2007.? We have many customers who spend significant time trying to create good-looking documents.? Our intent with Office 2007 is to make it easier to create good-looking documents.? This means providing a way to create charts, tables, diagrams, shapes, and other document components with a consistent look and feel.? Each document has a theme which defines a coordinated set of styles for each document component.? For charts, we have tried to create a wide breadth of styles to cover the broad variety of business needs in Excel, PowerPoint, and Word.? We have tried to optimize these styles for charts; e.g. emphasizing the data, while balancing a consistent look with the other document components such as tables and diagrams.? For example, axes, tick marks, and gridlines have been subdued to allow the data in the plot area to stand out more. 在Office 2007里，圖表樣式是較大的新東西之一。我們有很多用戶，花費相當多的時間試圖創建一些好看的文檔。我們Office 2007的意圖是使創建好看文檔更任意些。這意味著提供一個方法來創建帶有一致外公和感覺的圖表，表格，圖示，圖形和其它文檔組件。對于圖表，我們嘗試了創建很寬的樣式幅度，以滿足Excel，PowerPoint和Word中的各種業務需求。我們嘗試了優化這些圖表樣式，舉例來說，強調數據，同時協調和其它文檔組件如表格和圖示一致的外觀。例如，軸，標識和網格線都被柔和了，以使繪圖區的數據更加突出。

OK, so that is our intent.?? We certainly heard some feedback last week (in blog comments and the survey which many of you did fill out thanks very much) that the styles you saw were not what you would consider “professional”, or that there were things you would like to see changed.? (To be fair, neither the survey nor the images in this blog have presented a holistic view of all the styles available – for some reason, I think we tended to show the fancier more effects-laden styles, so our mistake.)? That is great feedback, and we would like to understand more. 好啦，這是我們的想法。我們上周確實聽到一些反饋（在Blog意見里，以及你們中很多人填寫的調查里。非常感謝！），你們不認為你們所看到的這些樣式是“專業的”，或者說，你們希望看到很多東西應該改變。（公平地說，不管是調查還是本博克里呈現的所以可用樣式的整體視圖——為了某些原因，我想我們試圖顯示了更多效果絢麗的樣式，這是我們的失誤。）這是非常好反饋，我們原意了解更多。

To that end, I would like to invite the folks that posted comments last week as well as other blog readers to provide us some examples of what you think a “professional” chart looks like.? While this could take a number of forms, given that a picture can be worth a thousand words, one thing that would be great is to see XL files that contain sample “professional” charts – this could be either something from the current versions of Excel or from the Excel 2007 beta.? Those of you with the beta, we would also be happy to hear specific changes you would like to see to the chart styles in the beta build.? You can send all files and comments to [email?protected].? We will take what we get in the next week or so and try and factor the feedback into the final set of styles.? Thanks in advance to all that take the time to help us out. 最后，我想邀請上周發表建議的朋友，以及其它博克上的讀者，給我們提供一些你認為“專業”圖表長什么樣的例子。這可能會需要一些形體，因為一個圖形會比一千句話更有效果，更好的是看到含有一些“專業”圖表的Excel文件——既可以是從當前Excel版本來的東西，也可以是從Excel 2007 beta版的東西。那些使用beta版的朋友，我們也很高興聽到你希望圖表樣式的具體更改。你[email?protected]?將大概在下周采取我們得到的所有反饋，并且試圖反映該反饋到最終樣式上。

Published Friday, June 02, 2006 3:13 PM by David Gainer Filed Under: Charting

版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容，請聯系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。

版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容，請聯系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。