專業(yè)圖表輕松做

專業(yè)圖表輕松做

譯者：snood?? 來源：http://blogs.msdn.com/excel 發(fā)表于：2006年7月7日

Charting I – Professional charts, made easy 圖表一：專業(yè)圖表輕松做

A few posts ago when I described the work we did in the area of “great looking documents”, I mentioned charting. I am going to spend the next week or two covering charting in detail. For this first two posts, I want to cover how we have used the ribbon to make it possible, with no more than 3-4 clicks, to create a wide variety of professional-looking charts. 我在以前的幾個貼子中描述“精美的文檔”時提到過圖表。在最近一到二周將詳細介紹Excel2007圖表。在一開始的二個貼子中，將講述如何只用3-4步，輕松創(chuàng)建精美的專業(yè)圖表。

Chart Types In current versions of Excel, when a user creates a chart, the first thing they need to do is select the type of chart – column, line, scatter, pie, surface, and etc. In Excel 2007, we’ve made the variety of chart types available a lot more visible, and we have offered help for users to choose between them. To insert a chart, a user would start with the Insert tab. Excel 2007 has an insert chart type “group” (7 related controls) on the ribbon’s insert tab. This makes it easy to pick a chart type, with large icons and tooltips that describe when to use a particular type. 圖表類型 在當前版本中創(chuàng)建一個圖表，第一步就是要選擇圖表類型：柱形圖、折線圖、散點圖、餅圖、曲面圖等等。在Excel 2007中，有更多的圖表類型以供選擇。以下演示如何選擇圖表類型：在插入圖表欄中插入一個圖表，Excel 2007的插入菜單中有個插入圖表欄（共七種圖表類型）。利用大圖標和細分圖表類型的工具提示，可以非常容易地選擇所需的圖表類型。

Note that we have provided galleries for the most common chart types – column, line, pie, bar, area, and scatter – with the remaining chart types surfaced in a 7th gallery. For those who want to browse through the full list of chart types, or change the type of an existing chart, the Create Chart dialog makes it easier to explore the list of chart types and pick the one you want. Excel 2007除了提供最常見的圖表種類：柱形圖、折線圖、餅圖、條形圖、面積圖、散點圖等，其余圖表種類全部放在其它圖表欄中。如果要瀏覽全部圖表類型，或改變已有圖表的種類，打開創(chuàng)建圖表對話框可以容易地瀏覽和選擇圖表類型。

And for those who love shortcut keys, Alt+F1 will now create a chart object with the default chart type, while F11 still creates a chart sheet with the default chart type. 快捷鍵：Alt+F1在當前工作表中創(chuàng)建默認圖表類型的圖表對象；F11新建默認圖表類型的圖表對象

Although we do hear many customer requests for new chart types, unfortunately we weren’t able to add any in Office 2007. We’re not yet planning the next version of Office in depth, but no doubt that will be considered again, as this is another area where we hear a lot of feedback. 曾經(jīng)有用戶提出增加圖表類型的請求，非常遺憾在Office 2007中我們未能提供更多的圖表類型。我們計劃在下個版本中深入研究和重新考慮，當然，也請你提供更多的反饋信息。

Chart Layouts Once a user has chosen a chart type, there are a variety of charting features that can help the user communicate their data effectively. In previous versions of Excel, these are scattered around through a variety of dialog boxes, making it hard for all but the most diligent users to take advantage of the settings. For Office 2007, we studied a massive number of charts that we found in publications, books, and Excel spreadsheets to determine the most common combinations of chart elements such as titles, legend, data table, etc. From this, we created a gallery of predefined chart layouts (e.g. combinations of chart elements) that can be applied with one click. Here is what the gallery looks like for a bar chart 圖表版式 圖表類型一旦選擇后，用戶為了獲得更好的圖表效果，需設(shè)置不同的圖表元素。在早期的Excel版本里，是一個包含很多分散內(nèi)容的對話框，對經(jīng)常設(shè)置圖表格式的用戶來說比較麻煩。在Office 2007開發(fā)中，我們研究了大量刊物、書籍、Excel表格的中圖表的標題、圖例、數(shù)據(jù)表等元素的組合，從而設(shè)計了一個內(nèi)置圖表庫(如組合圖元素)，只要點一下鼠標就能運用到你的圖表中了。

And here is what the galleries look like for a few other chart types. Note that each chart type has its own unique set of chart layouts. 這是內(nèi)置的其他幾個圖表類型.每個圖表類型都有自己獨特的圖表版式.

I have not included the pictures of the chart layouts for all the chart types, but I’ve tried to include those for most of the more popular chart types. We have tried to included layouts for the sorts of charts we are commonly asked about. For example, there’s a chart layout designed for making histograms – the third choice in the second row of the column chart layouts. There’s a chart layout designed for making sparklines – the first choice in the third row of the line chart layouts. There’s a chart layout designed for making pie charts with labelled slices instead of a legend. Each chart layout is a useful high-quality chart which presents data in a different way. We are still refining the set of chart layouts and their icons, so expect some changes before Office 2007 is done. 內(nèi)置圖表沒有包括所有圖表類型, 但盡量選擇了一些最常用的的圖表類型。我們?yōu)閮?nèi)置圖表分類以滿足用戶的需求。例如, 直方圖的圖表版式設(shè)計- 在柱形圖快選版式第二行的第三個圖表；sparklines圖的圖表版式設(shè)計- 在折線圖快選版式第三行的第一個圖表；餅圖的圖表版式設(shè)計用圖文框代替圖例。在不同行業(yè)，每個圖表版式都是有用的高質(zhì)量圖表. 我們還在完善這套圖表版式及其圖標,在Office 2007發(fā)布以前希望做一些變革。

Published Tuesday, April 11, 2006 9:49 AM by David Gainer

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

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