麗水會計繼續(xù)教育網(wǎng)：Excel2007新知-選項卡和模板

高頓網(wǎng)校友情提示，*7麗水會計繼續(xù)教育網(wǎng)上總結(jié)信息Excel2007新知-選項卡和模板等內(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.
 

　　在前兩個貼子里,我寫了如何通過4個簡單步驟創(chuàng)建專業(yè)圖表：圖表類型、圖表版式、圖表樣式、文檔主題。希望對你有益。我們知道有些用戶想從各個方面來調(diào)節(jié)圖表。今天我想通過ribbon上的圖表選項卡來介紹圖表設(shè)置。我也會簡要介紹一下模板。
 

　　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è)計、樣式、格式。下圖是設(shè)計選項卡。

　　(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.

　　用戶可以通過設(shè)計選項卡設(shè)定圖表版式、圖表樣式。此外,還可改變圖表類型,改變數(shù)據(jù)源,移動圖表及其他一些設(shè)定，大多數(shù)在以前的貼子中介紹過。
 

　　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.

　　版式選項卡

　　圖表版式選項卡可以方便地設(shè)置各種圖表元素：標題、圖例、軸、數(shù)據(jù)系列、數(shù)據(jù)標志等。每個圖表元素都可以從自己的圖形目錄中選取樣式，大多數(shù)選項在以前的Excel版本中已經(jīng)使用了,但你必須找到正確的對話框來使用。現(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.

　　有兩個例子：一個是圖例的，一個是軸的。從圖例圖形目錄中可以選擇圖例的位置，從軸圖形目錄中可以選擇可見的軸。其他圖形目錄還可選擇數(shù)據(jù)標志的位置，分類軸方向和網(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.)

　　注意圖形目錄最下面有個"更多選項…"，使用圖形目錄的目的是通過一次點擊方便地進行設(shè)置。因為不是每功能都能放在圖形目錄中,所以針對每個圖表元素還設(shè)置了一個格式對話框。當用戶點擊"更多選項…"時就會出現(xiàn)對話框，象以前Excel版本似的，這可以充分發(fā)揮用戶的設(shè)置格式水平。(格式對話框是非模態(tài)對話框,可以點擊其他元素并設(shè)置格式。這些選項也可以重新排列，試試排列得更合適些。)

　　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)在,你大概就越來越感到ribbon 提供的"三個層次"的方法。*6層，用戶可以在設(shè)計選項卡的圖形目錄里選擇(圖表版式，圖表樣式) 非常簡單地創(chuàng)建各種圖表；如果用戶想進行更細的設(shè)置，可以轉(zhuǎn)到圖表樣式選項卡中，再利用非常直觀、預(yù)覽結(jié)果的圖形目錄設(shè)置圖表上的對象；如果要進行更細致的設(shè)置,可以通過格式對話框進行各種設(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.

　　格式選項卡

　　格式選項卡是基于圖形的格式(在我的貼子里還沒有介紹,但我會在合適的時候介紹的)。你可以選擇任何圖表元素，通過藝術(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.

　　填充色選項包括:1600萬種顏色、透明度、漸變、紋理和圖片填充。線條選項包括:1600萬種顏色、透明度、虛線、復(fù)合線、箭頭,平頭,接合點等。效果選項包括:陰影、發(fā)光、羽化、傾斜,也可以直接使用格式選項卡。所有這些都使用了OfficeArt,所以效果很好并且顏色協(xié)調(diào)。 如果要讓折線圖更好看可以用OfficeArt畫平滑線,好多了. 3D圖表可用3D OfficeArt繪制，包括平滑、照明、陰影和材質(zhì)。在幾個月前的一個貼子中,可以看到許多圖表效果。

　　格式選項卡也包括文本藝術(shù)字，如果你想讓圖表標題發(fā)光或看上有鑿痕，使用藝術(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.

　　模板

　　最后一個關(guān)鍵詞是模板。你可以將一個以前設(shè)計好的自定義圖表存為圖表模板，這與在以前的版本自定義圖表類型相似，但也有一點新的特色(在ribbon和創(chuàng)建圖表對話框上都有)。 圖表模板作為單獨的文件存放在一個目錄中,可以方便地在不同用戶或不同機器間共享使用。 最后,可以在你的新文件中使用你感興趣的模板創(chuàng)建圖表。

 　　　　

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

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