PivotTable的例句大全

A list cannot overlap a range that contains a PivotTable report, query results, protected cells or another list.

列表不能与包含数据透视表、查询结果、受保护的单元格或其他列表的区域重叠。

Cannot paste a link into a pivottable.

数据透视表上不能粘贴链接。

Include digital media files from removable media Drop to remove this field from PivotTable report

包括可移动媒体中的数字媒体文件拖动该字段，将其移出数据透视表

Only one field name may be included in a PivotTable reference.

在透视表引用中只能包含一个字段名。

Pivot fields directly on the sheet without starting the PivotTable wizard by dragging the field buttons.

要在不打开数据透视表向导的情况下直接在工作表中透视字段，应拖动字段按钮。

This PivotTable is aggregating the source data using the Sum function. Now, let's try and change this to Count.

这个透视表是使用求和功能进行数据源汇总的。现在，让我们将它改为计数。

pivottable views enable you to quickly reorient your data to help you answer multiple questions.

使用数据透视表视图，可以迅速重新定位数据以便帮助您回答多个问题。

create a pivottable or pivotchart view more easily by using data fields to reorient data quickly to summarize and find the answers you need.

创建数据透视表视图或数据透视图更加轻松（方法是使用数据字段迅速重新定位数据），可以汇总和找到所需的答案。

in the pivottable below, i have added three fields to the row area and the sales amount field to the values area.

在数据透视表的下面，我已经添加三个字段到行区域，销售额字段添加到值区域。通常只有第一个字段的项目“年份”显示出来。

there are four areas in a pivottable, each of which is represented by a drop zone in the field list.

在数据透视表中有四个区域，在字段列表中每一个区域代表一个拖拽区域。

page fields allow you to filter the entire pivottable report to display data for a single item or all the items.

页字段允许您筛选整个数据透视表，以显示单个项或所有项的数据。

To customize a PivotTable report , you can use the PivotTable Field button on the PivotTable toolbar.

使用“数据透视表”工具栏上的“数据透视表字段”按钮, 可以自定义数据透视表.

PivotCharts must be linked to a PivotTable. The PivotChart will be created on a new sheet.

数据透视图必须链接到数据透视表. 数据透视图将在新的工作表中创建.

Un checking a checkbox will remove the field from the PivotTable.

不勾选复选框的话,这些字段就会从数据透视表中移除.

Local data file ( use PivotTable while disconnected )

本地数据文件 ( 断开连接时使用数据透视表 )

The PivotTable field name is not valid.

数据透视表字段名无效.

This wizard automatically creates a form in PivotTable view.

向导将在“数据透视表”视图中自动生成一个窗体.

A PivotTable report cannot overlap another PivotTable report.

数据透视表不能覆盖另一个数据透视表.

To lay out your report, drag fields from the PivotTable toolbar to the marked worksheet areas.

如要布置报表, 可将字段从数据透视表工具栏拖到已标示的工作表区域.

Analyze data by using the PivotTable and PivotChart components.

使用数据透视表组件和图表组件分析数据.