高頓網(wǎng)校友情提示，*7麗水會(huì)計(jì)繼續(xù)教育網(wǎng)上總結(jié)信息Excel2007新知-選項(xiàng)卡和模板等內(nèi)容公布如下：
　　Charting III – Tabs and Templates
　　In the previous two charting posts, I wrote about how you can make a professional chart with four simple choices – chart type, chart layout, chart style, and document theme. As useful as we hope that is, we know that some users will want to tweak and control every aspect of their charts. Today I want to walk through the tabs that are available when you are working with a chart and provide an overview of all the capabilities that are exposed in the ribbon. I am also going to briefly cover templates.
 
　　圖表三：選項(xiàng)卡和模板
　　在前兩個(gè)貼子里,我寫了如何通過(guò)4個(gè)簡(jiǎn)單步驟創(chuàng)建專業(yè)圖表：圖表類型、圖表版式、圖表樣式、文檔主題。希望對(duì)你有益。我們知道有些用戶想從各個(gè)方面來(lái)調(diào)節(jié)圖表。今天我想通過(guò)ribbon上的圖表選項(xiàng)卡來(lái)介紹圖表設(shè)置。我也會(huì)簡(jiǎn)要介紹一下模板。
 
　　Design Tab
　　When you are working with a chart, three additional contextual tabs will be available – Design, Layout, and Format. Here is a shot if the Design Tab.
 
　　設(shè)計(jì)選項(xiàng)卡
　　當(dāng)你制作圖表時(shí),有三個(gè)選項(xiàng)卡可用：設(shè)計(jì)、樣式、格式。下圖是設(shè)計(jì)選項(xiàng)卡。
　　(Click to enlarge)
　　The Design tab allows users to set the style and layout of a chart. In addition, this is where you change the chart type, change the data source, move the chart, and a few other things. The bulk of this was covered in previous posts.
　　用戶可以通過(guò)設(shè)計(jì)選項(xiàng)卡設(shè)定圖表版式、圖表樣式。此外,還可改變圖表類型,改變數(shù)據(jù)源,移動(dòng)圖表及其他一些設(shè)定，大多數(shù)在以前的貼子中介紹過(guò)。
 
　　Layout Tab
　　The chart layout tab contains easy access to the various elements of a chart – title, legend, axes, series, data labels, etc. Each element has its own gallery of simple choices to construct charts. Most of these choices were available in previous versions of Excel, but you had to find the correct dialog to use them. With the ribbon, these choices are much more accessible and results-oriented.
　　版式選項(xiàng)卡
　　圖表版式選項(xiàng)卡可以方便地設(shè)置各種圖表元素：標(biāo)題、圖例、軸、數(shù)據(jù)系列、數(shù)據(jù)標(biāo)志等。每個(gè)圖表元素都可以從自己的圖形目錄中選取樣式，大多數(shù)選項(xiàng)在以前的Excel版本中已經(jīng)使用了,但你必須找到正確的對(duì)話框來(lái)使用。現(xiàn)在用ribbon有更多的選擇和預(yù)覽效果。
　　(Click to enlarge)
　　Here are examples – one for legends, and the one for an axis. The legend gallery gives you a choice of places to put the legend. The axis gallery gives you a choice of how you would like to see the axis. Other galleries give choices for data label position, category axis direction, and gridline patterns.
　　有兩個(gè)例子：一個(gè)是圖例的，一個(gè)是軸的。從圖例圖形目錄中可以選擇圖例的位置，從軸圖形目錄中可以選擇可見(jiàn)的軸。其他圖形目錄還可選擇數(shù)據(jù)標(biāo)志的位置，分類軸方向和網(wǎng)格線模式。
　　(Click to enlarge)
　　Note that the galleries have a “More Options …” choice at the bottom. The goal of the galleries is to make it easy to apply common settings with one click. Since not every capability would fit in these galleries, so there is still a format dialog for each chart element, much like in previous versions of Excel, which is launched when the user selects “More Options …” This gives the user the finest level of control over the features. (The format dialog is now modeless, so you can click to other elements and change their formatting. Also, the choices have also been rearranged somewhat, trying to make them fit better together.)
　　注意圖形目錄最下面有個(gè)"更多選項(xiàng)…"，使用圖形目錄的目的是通過(guò)一次點(diǎn)擊方便地進(jìn)行設(shè)置。因?yàn)椴皇敲抗δ芏寄芊旁趫D形目錄中,所以針對(duì)每個(gè)圖表元素還設(shè)置了一個(gè)格式對(duì)話框。當(dāng)用戶點(diǎn)擊"更多選項(xiàng)…"時(shí)就會(huì)出現(xiàn)對(duì)話框，象以前Excel版本似的，這可以充分發(fā)揮用戶的設(shè)置格式水平。(格式對(duì)話框是非模態(tài)對(duì)話框,可以點(diǎn)擊其他元素并設(shè)置格式。這些選項(xiàng)也可以重新排列，試試排列得更合適些。)
　　By now, you are probably getting a sense as to the “three level” approach that the ribbon affords us. At the top level, users can select from galleries on the Design tab (chart layout, chart style) that to create a wide variety of charts very simply. If users then want to do more detailed tweaking, they can move to the Layout tab, where they can manipulate the objects on the chart, again using very visual, results-oriented galleries. And, for those folks that want even more fine-grained control, there are modal dialogs with every available setting.
　　現(xiàn)在,你大概就越來(lái)越感到ribbon 提供的"三個(gè)層次"的方法。*6層，用戶可以在設(shè)計(jì)選項(xiàng)卡的圖形目錄里選擇(圖表版式，圖表樣式) 非常簡(jiǎn)單地創(chuàng)建各種圖表；如果用戶想進(jìn)行更細(xì)的設(shè)置，可以轉(zhuǎn)到圖表樣式選項(xiàng)卡中，再利用非常直觀、預(yù)覽結(jié)果的圖形目錄設(shè)置圖表上的對(duì)象；如果要進(jìn)行更細(xì)致的設(shè)置,可以通過(guò)格式對(duì)話框進(jìn)行各種設(shè)定。
　　Format Tab
　　The Format tab is based on the Format tab used for shapes (which I haven’t yet covered in a post, but I will at some point). You can choose any chart element, and format it just as though it is an OfficeArt shape.
　　格式選項(xiàng)卡
　　格式選項(xiàng)卡是基于圖形的格式(在我的貼子里還沒(méi)有介紹,但我會(huì)在合適的時(shí)候介紹的)。你可以選擇任何圖表元素，通過(guò)藝術(shù)字的形狀調(diào)整格式。
　　(Click to enlarge)
　　This includes control over the fill: 16 million colours, transparency, gradient fills, and texture and picture fills. It also includes control over the lines: 16 million colours, transparency, dashing, compound lines, arrows, and even cap and join settings. Effects, such as shadow, glow, soft edges, and bevel, can also be accessed from the Format tab. All of these are drawn using OfficeArt, so they are high quality and look consistent. OfficeArt draws smooth antialiased lies, which makes line charts look so much better. 3-D charts are drawn with OfficeArt 3-D, including antialiasing, lighting, shadows, and materials. In a post from a few months back, you can see many of these effects on charts.
　　The Format tab also includes WordArt effects for text. If you want your chart title to glow or look chiselled, the WordArt effects enable it. The text is drawn with ClearType, making it much more readable than text on charts in previous versions, especially at smaller sizes.
　　填充色選項(xiàng)包括:1600萬(wàn)種顏色、透明度、漸變、紋理和圖片填充。線條選項(xiàng)包括:1600萬(wàn)種顏色、透明度、虛線、復(fù)合線、箭頭,平頭,接合點(diǎn)等。效果選項(xiàng)包括:陰影、發(fā)光、羽化、傾斜,也可以直接使用格式選項(xiàng)卡。所有這些都使用了OfficeArt,所以效果很好并且顏色協(xié)調(diào)。 如果要讓折線圖更好看可以用OfficeArt畫平滑線,好多了. 3D圖表可用3D OfficeArt繪制，包括平滑、照明、陰影和材質(zhì)。在幾個(gè)月前的一個(gè)貼子中,可以看到許多圖表效果。
　　格式選項(xiàng)卡也包括文本藝術(shù)字，如果你想讓圖表標(biāo)題發(fā)光或看上有鑿痕，使用藝術(shù)字效果就行了。該文本使用透明類型，比以前版本的圖表中文字更好看,尤其是文字較小的時(shí)候。
　　Templates
　　Finally, a quick word about templates. Once you have a finished designing a custom chart to look just like you want it, you can save it as a template. This is similar to the custom chart types of previous versions, but we have exposed the feature a bit more carefully (both on the ribbon and in the Create Chart dialog). Also, the templates are stored as separate files in a directory, making it much easier to share them from user to user or machine to machine. Finally, for those interested in the new file formats, templates use the same schema as charts.
　　模板
　　最后一個(gè)關(guān)鍵詞是模板。你可以將一個(gè)以前設(shè)計(jì)好的自定義圖表存為圖表模板，這與在以前的版本自定義圖表類型相似，但也有一點(diǎn)新的特色(在ribbon和創(chuàng)建圖表對(duì)話框上都有)。 圖表模板作為單獨(dú)的文件存放在一個(gè)目錄中,可以方便地在不同用戶或不同機(jī)器間共享使用。 最后,可以在你的新文件中使用你感興趣的模板創(chuàng)建圖表。
 　　　　
　　掃一掃微信，學(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)，可以幫助考生全面提升備考效果。