高頓網(wǎng)校友情提示,*7寧波會計繼續(xù)教育網(wǎng)上總結(jié)信息Excel2007新知-專業(yè)圖表輕松做等內(nèi)容公布如下:  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.
  我在以前的幾個貼子中描述“精美的文檔”時提到過圖表。在最近一到二周將詳細(xì)介紹Excel2007圖表。在一開始的二個貼子中,將講述如何只用3-4步,輕松創(chuàng)建精美的專業(yè)圖表。
  When talking to customers about charting in Excel, one of the big pieces of feedback we hear is how hard it is to make a chart that looks ready to publish. Generally, users aren’t graphic designers or experts in information visualization, yet they still want a result that looks professional and communicates their information effectively. With advent of the ribbon, we have a new UI design approach – results-oriented design (which is discussed in a blog post here). In a nutshell, the idea is to give users a couple of reasonable choices for professional designs, then allow them to mix and match those choices into a professional document. While we’ll still give users access to the detailed features that make their documents look good, they should be able to get close to a final result in just a few clicks. To that end, chart creation in Office 2007 can be as simple as making four straightforward choices that give users access to a vast range of possibilities. The four choices are: what type of chart they want, how they want the elements on that chart laid out, how they want their chart formatted, and what document theme they would like to use. I’ll talk about two of these choices in this post, and the other two choices in the next post.
  用戶在使用Excel圖表時,首要的問題是利用現(xiàn)成的模板來創(chuàng)建圖表。一般,用戶不是專業(yè)的圖形設(shè)計師,他們只想得到一個能展示其數(shù)據(jù)效果的專業(yè)圖表。在Exce2007中,有一個全新的預(yù)覽效果向?qū)У挠脩艚缑?。總之,這項目設(shè)計是為用戶提供一系列的選擇來完成專業(yè)設(shè)計的工作,然后通過組合和調(diào)整創(chuàng)建專業(yè)圖表。我們將詳細(xì)介紹這些功能來創(chuàng)建精美的圖表,使用戶能通過幾次點擊便能完成圖表。在Exce2007中通過簡單的四個步驟創(chuàng)建圖表,從而引導(dǎo)新用戶入門。這四步是:選擇圖表類型,選擇圖表版式,設(shè)置圖表樣式,設(shè)置文檔主題。在本貼我將介紹前面二步,其余二步在下一貼介紹。
 
  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.
  圖表類型
  在當(dāng)前版本中創(chuàng)建一個圖表,*9步就是要選擇圖表類型:柱形圖、折線圖、散點圖、餅圖、曲面圖等等。在Excel 2007中,有更多的圖表類型以供選擇。以下演示如何選擇圖表類型:在插入圖表欄中插入一個圖表,Excel 2007的插入菜單中有個插入圖表欄(共七種圖表類型)。利用大圖標(biāo)和細(xì)分圖表類型的工具提示,可以非常容易地選擇所需的圖表類型。
  (Click to enlarge)
  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)建圖表對話框可以容易地瀏覽和選擇圖表類型。
  (Click to enlarge)
  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在當(dāng)前工作表中創(chuàng)建默認(rèn)圖表類型的圖表對象;F11新建默認(rèn)圖表類型的圖表對象
  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中我們未能提供更多的圖表類型。我們計劃在下個版本中深入研究和重新考慮,當(dāng)然,也請你提供更多的反饋信息。
     
  掃一掃微信,學(xué)習(xí)實務(wù)技巧
   
  高頓網(wǎng)校特別提醒:已經(jīng)報名2014年財會考試的考生可按照復(fù)習(xí)計劃有效進(jìn)行!另外,高頓網(wǎng)校2014年財會考試高清課程已經(jīng)開通,通過針對性地講解、訓(xùn)練、答疑、???,對學(xué)習(xí)過程進(jìn)行全程跟蹤、分析、指導(dǎo),可以幫助考生全面提升備考效果。