高頓網(wǎng)校友情提示，*7合肥會(huì)計(jì)繼續(xù)教育網(wǎng)上總結(jié)信息Excel2007新知-數(shù)據(jù)透視圖等內(nèi)容公布如下：　　Charting V – PivotCharts
　　數(shù)據(jù)透視圖
　　Whenever we talk to users about PivotCharts, the first request we hear is that they behave more like regular charts.  In previous versions, PivotCharts had very limited layout and formatting options. In addition, if you refreshed the PivotTable that the PivotChart was based upon, the PivotChart would lose whatever formatting it had. We heard from many users that they would often just create regular charts instead of PivotCharts, since could be problematic  As PivotTables and charts changed in Excel 2007, we made sure PivotCharts changed along with them – with a key goal being that they became more consistent.
　　只要我們和用戶(hù)談?wù)撚嘘P(guān)數(shù)據(jù)透視圖,我們聽(tīng)到的*9個(gè)要求是,能像正常圖表一樣使用. 以前的版本, 數(shù)據(jù)透視圖只有非常有限的布局和格式選項(xiàng)。此外,如果更新數(shù)據(jù)透視圖的基礎(chǔ)：數(shù)據(jù)透視表,它就會(huì)丟失所有已設(shè)置的格式. 我們聽(tīng)到許多用戶(hù)往往只能用正常圖表代替數(shù)據(jù)透視圖。因?yàn)檫@些問(wèn)題，在Excel 2007中的數(shù)據(jù)透視表和數(shù)據(jù)透視圖有所改變,我們相信數(shù)據(jù)透視圖改變的主要目標(biāo)是讓圖表變得更加一致。
 
　　Formatting
　　PivotCharts in Excel 2007 can have all the same formatting as regular charts, including all the layouts and styles talked about in previous posts.  You can move and resize chart elements, or change formatting of individual data points.  One of the few restrictions that we did not have time to address in this version is the one on chart types – you still can’t create scatter, bubble, or stock PivotCharts.
　　If you refresh the data for your PivotChart, the chart updates and the formatting does not change.  Any new series or data points will be formatted to match the style or series as appropriate.  As a result, you can easily make PivotCharts for presentation or publication.
　　Furthermore, PivotChart will remember formatting across pivots.  If you set the colour of the series or a particular data point to red, then change the pivot so your data is no longer showing, the red band is gone as well. If you bring the data back into view, the red colour returns.
　　格式
　　Excel2007數(shù)據(jù)透視圖和正常圖表一樣有許多相同格式,包括前面討論的所有的設(shè)計(jì)風(fēng)格和圖表類(lèi)型。你可以移動(dòng)和改變圖表元素,或變更單個(gè)數(shù)據(jù)系列的格式. 少數(shù)的限制中的一項(xiàng)是,我們沒(méi)有時(shí)間處理圖表類(lèi)型：在這個(gè)版本中還是不能創(chuàng)建散點(diǎn)圖、氣泡圖、股票圖等數(shù)據(jù)透視圖.
　　如果你更新數(shù)據(jù)透視圖、數(shù)據(jù)會(huì)更新而圖表格式不會(huì)改變. 任何新的數(shù)據(jù)系列或數(shù)據(jù)點(diǎn)格式將設(shè)置成相同的風(fēng)格. 因此,很容易創(chuàng)建數(shù)據(jù)透視圖來(lái)制作幻燈片或出版物。
　　此外, 數(shù)據(jù)透視圖將通過(guò)字段記憶格式. 如果你設(shè)定某系列或某數(shù)據(jù)點(diǎn)的顏色為紅色,那么當(dāng)你改變透視關(guān)系不再顯示此數(shù)據(jù)系列，紅色系列消失了；如果你再設(shè)置顯示該字段時(shí),紅色系列又回來(lái)了。
　　PivotTable Field List
　　PivotCharts use the same field list as PivotTables.  Just as with PivotTables, you can click the checkboxes for the fields you are interested in, and they will be reasonably laid out as a PivotChart.  You can also drag the fields around from region to region to pivot the PivotChart.  The field list also provides access to field settings such as how to summarize the data.
　　數(shù)據(jù)透視圖字段列表
　　數(shù)據(jù)透視圖使用和數(shù)據(jù)透視表相同的字段列表. 如同數(shù)據(jù)透視表,你可以點(diǎn)擊字段列表來(lái)插入,并創(chuàng)建合適的數(shù)據(jù)透視圖. 你還可以拖放字段,從數(shù)據(jù)透視圖的一個(gè)區(qū)域移動(dòng)另一個(gè)區(qū)域. 字段列表還規(guī)定了字段取數(shù),例如如何匯總數(shù)據(jù).
　　PivotChart Filter Pane
　　The PivotChart filter pane is a new task pane that enables you to filter PivotCharts.  In previous versions, filters were accessed from buttons in the PivotChart, but removed these so they didn’t affect the layout of the PivotChart.  The filter pane has the same filter capabilities as for PivotTables.  See filtering in PivotTables for details.  Below is a shot of the PivotChart field list and Filter task pane.
　　據(jù)透視圖篩選窗格
　　數(shù)據(jù)透視圖篩選窗格是一個(gè)新的任務(wù)窗口,便于進(jìn)行數(shù)據(jù)透視圖篩選。以前的版本,是使用數(shù)據(jù)透視圖的篩選按鈕，去掉這些按鈕并不影響數(shù)據(jù)透視圖的布局。篩選窗口和數(shù)據(jù)透視表具有相同的篩選功能。詳細(xì)的數(shù)據(jù)透視表篩選參見(jiàn). 下面是一張關(guān)于數(shù)據(jù)透視圖的字段和篩選窗口的截圖。
 　　　　
　　掃一掃微信，學(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)，可以幫助考生全面提升備考效果。