| 单词 | pivottable | ||||||||||
| 释义 | pivottable
更多释义 收起释义 例句释义: 数据透视表,枢纽分析表,枢纽表 1. The only real difference between the PivotTable and Table Styles is with regards to the number of elements in a PivotTable style. 数据透视表与列表的风格真正的区别仅仅是，可用的元素的数量多少。 club.excelhome.net 2. If your PivotTable report is in indented format , move at least one field to the column area before you create the chart . 如果数据透视表为缩进格式，那么在创建图表前，至少要将一个字段移到列区域。 www.bing.com 3. Instead , you can simply select the fields that you want to see in a new PivotTable field list . 现在，您只需在新的数据透视表字段列表中选择要查看的字段即可。 www.bing.com 4. Refer to this diagram to see where the PivotTable control displays a particular element. 参考这个图表可以得知透视表控件中各元素的所在位置。 www.xgdown.com 5. Each KPI component can be added to the PivotTable Values area by checking the checkbox just like any other field. 每个KPI成员可以通过勾选复选框添加到数据透视表数值区域，正如其它字段一样。 www.vbacn.net 6. PivotTable views enable you to quickly reorient your data to help you answer multiple questions. 使用数据透视表视图，可以迅速重新定位数据以便帮助您回答多个问题。 office.microsoft.com 7. Page fields allow you to filter the entire PivotTable report to display data for a single item or all the items. 页字段允许您筛选整个数据透视表，以显示单个项或所有项的数据。 office.microsoft.com 8. As you click more non-numeric fields, Excel places them on the inside of fields already on the PivotTable, building a hierarchy. 当你点击多个非数值型字段时，Excel会自动把这些字段安排在数据透视表的字段区域当中，并建立层次结构。 www.ejchina.com 9. As you add fields to the Values area of the PivotTable, the formatting is done automatically. 当你添加字段到数据透视表的数值区域时，格式会自动完成。 www.ejchina.com 10. That's it for today. We would love to hear your feedback. Tomorrow, PivotTable styles. 今天就介绍到这里。我们将乐意听到您的反馈意见。明天，介绍数据透视表的样式。 www.ejchina.com 1. Find the answers you need faster and create and use PivotTable views more easily by dragging fields where you want them to be displayed. 将字段拖动到要显示的位置，即可更快地找到所需答案、更轻松地创建和使用数据透视表视图。 office.microsoft.com 2. With Excel 2003 PivotTable charts, I can easily convert a large amount of data into a valuable tool for analyzing sales trends. 使用Excel2003数据透视表图表，我可以轻松地将大量数据转换到有价值的工具中，以便分析销售趋势。 office.microsoft.com 3. Only one subtotal per row area, column area, or page area can be entered in a PivotTable reference. 在数据透视表中每个行区域、列区域或页区域只能有一个分类汇总。 www.dictall.com 4. To lay out a PivotTable report, you drag fields from the field list window and drop them onto the drop areas. 若要调整数据透视表的布局，请从字段列表窗口拖动字段并将其放置到拖放区域。 office.microsoft.com 5. A PivotTable report is an interactive table that you can use to quickly summarize large amounts of data. 数据透视表是一个可以用于快速汇总大量数据的交互式表格。 office.microsoft.com 6. Even if you turned off the asterisks marking totals in Excel, the asterisks are displayed in the PivotTable list on the Web. 即使在Excel中关闭了标记汇总的星号，星号也仍会显示在网站上的数据透视表列表中。 office.microsoft.com 7. Select this check box to enable filtering of a cell range, Excel Table, and PivotTable report, and to enable outlining. 如果选中此复选框，则允许对单元格区域、Excel表和数据透视表进行筛选，并允许分级显示。 office.microsoft.com 8. In a PivotTable or PivotChart report, each dimension becomes a set of fields where you can expand and collapse detail. 在数据透视表或数据透视图中，每个维成为可展开和折叠明细数据的一组字段。 office.microsoft.com 9. Users can view the PivotTable list in a Web browser and change its layout in a manner similar to an Excel PivotTable report. 用户可以在Web浏览器中查看数据透视表列表，还可以使用类似于Excel数据透视表的方式更改其布局。 office.microsoft.com 10. Use this property to make the PivotTable control display the total captions as row headings instead of column headings. 使用这个属性来使透视表控件将行标题显示为合计值的标题，而不是列标题。 dictsearch.appspot.com 1. Gets or sets a value that indicates whether the PivotTable field list can be shown. 获取或设置一个值，该值指示数据透视表字段列表是否能够显示。 msdn2.microsoft.com 2. Determines the types of PivotTable views and PivotChart views that you see. 决定您所查看的“数据透视表”视图和“数据透视图”视图的类型。 office.microsoft.com 3. Select this check box to enable sorting of a cell range, Excel Table, and PivotTable report. 如果选中此复选框，则允许对单元格区域、Excel表和数据透视表进行排序。 office.microsoft.com 4. In a PivotTable report, each column or field in your source data becomes a PivotTable field that summarizes multiple rows of information. 在数据透视表中，源数据中的每列或字段都成为汇总多行信息的数据透视表字段。 office.microsoft.com 5. In your Microsoft Excel worksheet, select the columns and rows that contain the data that you want to use to create a PivotTable report. 在您的MicrosoftExcel工作表中，选择要用于创建数据透视表的数据所在的行和列。 office.microsoft.com 6. "Tooltips on cells" controls whether tooltips are displayed when hovering over cells inside the PivotTable row, column and values areas. “单元格工具提示”控制当鼠标停留在数据透视表的行、列及值区域里的单元格上面时是否显示工具提示。 www.ejchina.com 7. A PivotTable report is an interactive table that quickly combines and compares large amounts of data. 数据透视表是交互式报表，可快速合并和比较大量数据。 office.microsoft.com 8. This procedure doesn't apply to a Microsoft Office PivotTable Component, Spreadsheet Component, or Chart Component. 该过程不适用于MicrosoftOffice数据透视表组件、电子表格组件或图表组件。 office.microsoft.com 9. The underlying rows or database records that provide the data for a PivotTable report. 为数据透视表提供数据的基础行或数据库记录。 office.microsoft.com 10. Names associated with a PivotTable report are changed to "Author" 与PivotTable（数据透视表）报表相关联的姓名更改为“作者”。 office.microsoft.com 1. A format used by the Microsoft Office Excel 2003 spreadsheet programs for a PivotTable report. MicrosoftOfficeExcel2003电子表格程序中的数据透视表使用的格式。 office.microsoft.com 2. And changing the layout of a PivotTable is also much easier to do in the new user interface. 而且，在新的用户界面中更改数据透视表的布局也更加容易。 office.microsoft.com 3. Clear this check box to prevent filtering of a cell range, Excel Table, and PivotTable report, and to prevent outlining. 如果清除此复选框，则阻止对单元格区域、Excel表和数据透视表进行筛选，并阻止分级显示。 office.microsoft.com 4. A PivotTable report is an interactive table that quickly combines and compares data. 数据透视表是一个交互式表格，它可以快速地组合和比较数据。 office.microsoft.com 5. The example PHP application builds an Excel XML file that has one worksheet for the raw data and another for the PivotTable. 示例PHP应用程序构建一个ExcelXML文件，其中为原始数据和PivotTable分别具有一个工作簿。 www.ibm.com 6. You can reduce the amount of space a PivotTable report needs by dragging some row or column fields to the page field drop area. 要减少数据透视表所需的空间，可以将某些行或列字段拖动到页字段的拖放区域。 office.microsoft.com 7. Expand or collapse levels of data and use a report filter in a PivotTable report. 在数据透视表中展开或折叠各级数据并使用报表筛选。 office.microsoft.com 8. And now the PivotTable no longer contains the subtotals for Mountain Bikes and Road Bikes. 现在透视表不再包括山地自行车和公路自车的分类汇总项目。 club.excelhome.net 9. The PivotTable report now shows the largest sales at the top (Dairy Products). 现在数据透视表在顶部显示最高销售额（点心）。 office.microsoft.com 10. One of the goals we had for our PivotTable work in Excel 12 was to make creating PivotTables a much more approachable task. 让用户很方便、很直观的创建数据透视表是我们的一个目标，我们已经在Excel12中实现了这个目标。 www.ejchina.com 1. PivotTable reports usually use Sum for data fields that contain numbers and Count for data fields that contain text. 数据透视表通常为包含数字的数据字段使用Sum，而为包含文本的数据字段使用Count。 office.microsoft.com 2. For more information, see Use a PivotTable report to make external table data available in Excel Services. 有关详细信息，请参阅使用数据透视表使外部表数据在ExcelServices中可用。 office.microsoft.com 3. Explains the steps to create a PivotTable report that connects to the Team Foundation data warehouse. 说明创建连接到TeamFoundation数据仓库的数据透视表的步骤。 msdn2.microsoft.com 4. Pivot fields directly on the sheet without starting the PivotTable Wizard by dragging the field buttons. 要在不打开数据透视表向导的情况下直接在工作表中透视字段，应拖动字段按钮。 office.microsoft.com 5. The PivotTable report was saved without the underlying data. Use the Refresh Data command to update the report. 数据透视表没有与下层数据共同保存。请使用“刷新数据”命令更新数据透视表。 de.bab.la 6. You cannot change, move a part of, or insert cells in a PivotTable report. 不能在数据透视表中更改或移动内容，或在其中插入单元格。 cn.bab.la 7. At the top are the PivotTable menu and some toolbar buttons to control the depth of the table. 顶部是PivotTable菜单和一些用于控制表深度的工具栏按钮。 www.ibm.com 8. The new filtering options in OLAP PivotTable reports require support for sub-selects on the OLAP server. OLAP数据透视表中的新增筛选选项要求支持对OLAP服务器执行再选择。 office.microsoft.com 9. In this article, you'll use data in the Pivot Table Products sample datasheet to create a PivotTable report of all product sales by quarter. 在本文中，您将使用产品数据透视表示例数据表中的数据创建一个数据透视表，按季度列出所有产品的销售额。 office.microsoft.com 10. Click Save PivotTable as Image or Save Chart as Image, and then specify a location for the image file. 单击“将数据透视表保存为图像”或“将图表保存为图像”，然后指定图像文件的位置。 office.microsoft.com 1. Report Filter. This area holds the fields that the whole PivotTable is filtered by. 报告筛选。这个区域保留整个数据透视表未被使用的字段。 club.excelhome.net 2. In PivotTable Service, the PASSTHROUGH option is part of the INSERT INTO statement. 在PivotTableService中，PASSTHROUGH选项是INSERTINTO语句的一部分。 technet.microsoft.com 3. In the same way as table styles, the PivotTable UI offer styles in a gallery. 和列表样式一样，数据透视表用户界面也提供了一个样式展台。 club.excelhome.net 4. Named sets are displayed in the PivotTable field list so that users can add them to a PivotTable on rows or columns. 名称集显示在数据透视表的字段清单里，因此用户可以添加到数据透视表的行或列中。 www.vbacn.net 5. Create a PivotTable or PivotChart view more easily by using data fields to reorient data quickly to summarize and find the answers you need. 创建数据透视表视图或数据透视图更加轻松（方法是使用数据字段迅速重新定位数据），可以汇总和找到所需的答案。 office.microsoft.com 6. PivotTable was changed during Refresh Data operation. 在“更新数据”操作后，数据透视表已改变。 de.bab.la 7. You cannot apply data validation to cells in a PivotTable. 不能对透视表应用数据有效性检验。 www.dictall.com 8. The Excel pivot table was correctly created so a PivotTable toolbar displays over the window. Excelpivot表已正确创建，所以窗口上显示一个PivotTable工具栏。 www.ibm.com 9. The Refresh Data operation changed the PivotTable report. “更新数据”操作更改了数据透视表报表。 de.bab.la 10. The pointer drags the Quarter field from the PivotTable Field List to the data area. 指针将“季度”字段从“数据透视表字段列表”拖到数据区域中。 office.microsoft.com 1. Click Scenario summary or Scenario PivotTable. 单击“方案摘要”或“方案数据透视表”。 office.microsoft.com 2. Mastering EXCEL function and PivotTable context, and other office software. 熟练掌握EXCEL函数及透视表，等办公软件。 www.hxw8.com 3. This is done in the Report Layout drop down on the PivotTable Styles tab. 这个命令已经设置在数据透视表样式标签的报告布局的下拉列表里。 club.excelhome.net 4. In step 2 of the wizard, click the PivotTable report, so that the reference in the Data range box expands to include the entire report. 在向导的第2步中，单击透视表报表，这样“数据区域”框中的引用可展开以包括整个报表。 office.microsoft.com 5. By using the PivotTable report showing top five products, you can now compare any products you want. 通过显示前五名产品的数据透视表，您现在可以比较任何所需的产品。 office.microsoft.com 6. To update a PivotTable report with the most recent data from the source list or database. 用来自源列表或数据库的最新数据更新数据透视表。 office.microsoft.com 7. The PivotTable Field List is open on the right side of the screen. 在屏幕的右侧，“数据透视表字段列表”处于打开状态。 office.microsoft.com 8. And the PivotTable now displays all the details for Canada. 透视表马上显示“加拿大”的所有详细内容。 club.excelhome.net 9. The PivotTable list "%1" contains incomplete or damaged information. 数据透视表列表“%1”含有不完整的或已遭破坏的信息。 www.jukuu.com 10. If you want to display an Excel workbook in Excel Services, you can connect to and refresh data, but you must use a PivotTable report. 如果您想要在ExcelServices中显示Excel工作簿，则可连接到数据并刷新它，但必须使用数据透视表。 office.microsoft.com 1. On the PivotTable or PivotChart toolbar, click Sort Ascending or Sort Descending. 在“数据透视表”或“数据透视图”工具栏上，单击“升序排序”或“降序排序”。 tr.bab.la 2. You can replicate the format of PivotTable and PivotChart views in a form. 可以复制窗体的数据透视表视图和数据透视图视图的格式。 tr.bab.la 3. To use PivotTable report names in structured references, you must change the defined names. 若要在结构化引用中使用数据透视表名，必须更改已定义名称。 office.microsoft.com 4. For more complex data layouts, you can use the PivotTable system. 对于更加复杂的数据布局，您可以使用PivotTable系统。 www.ibm.com 5. Another thing we hear from PivotTable users all the time is that it is too difficult or slow to clear stuff off of a PivotTable. 我们从数据透视表用户那里经常听说的另外烦恼就是清除数据透视表中的数据太困难或是太慢。 www.ejchina.com 6. A chart sheet is beneficial when you want to view a chart or a PivotChart report separately from worksheet data or a PivotTable report. 当希望单独查看图表或数据透视图（独立于工作表数据或数据透视表）时，图表工作表非常有用。 office.microsoft.com 7. Figure 2 shows an empty pivot table with the PivotTable toolbar floating over the window. 图2展示了一个空的pivot表，窗口上浮动着PivotTable工具栏。 www.ibm.com 8. What happened to the PivotTable Field List? 数据透视表中的“订单金额”字段？ office.microsoft.com 9. At this point, the user needs to simply press OK and they have a PivotTable connected to data in Excel 12. 这样，用户只需要轻松的点一下OK就可以在Excel12中得到一个连接到数据源的透视表了。 www.ejchina.com 10. For example, you can drag any item in the Field List to any part of the PivotTable report. 您可以将字段列表中的任何项目拖至数据透视表的任何部分。 office.microsoft.com 1. To illustrate, here is the PivotTable I've been using for other examples today. 举例，这儿是今天我们在其他例子已经使用过的透视表。 club.excelhome.net 2. Open a datasheet or form in PivotTable view. 在数据透视表视图中打开数据表或窗体。 office.microsoft.com 3. In the PivotTable below, I have added three fields to the row area and the sales amount field to the values area. 在数据透视表的下面，我已经添加三个字段到行区域，销售额字段添加到值区域。通常只有第一个字段的项目“年份”显示出来。 club.excelhome.net 4. There are four areas in a PivotTable, each of which is represented by a drop zone in the field list. 在数据透视表中有四个区域，在字段列表中每一个区域代表一个拖拽区域。 club.excelhome.net 5. Explains the steps to change a PivotTable report after it has been created. 说明更改创建后的数据透视表的步骤。 msdn2.microsoft.com 6. The form opens in PivotTable view. 窗体在数据透视表视图中打开。 www.tdict.com 7. Figure 3 shows the PivotTable toolbar in more detail. 图3更详细地展示了PivotTable工具栏。 www.ibm.com 8. Say you have the following PivotTable and you want to display all the available details for Canada. 比方说你有下面这样的透视表，你想显示所有“加拿大”有用的细节。 club.excelhome.net 9. The data range you have selected includes a PivotTable report. 选定的数据区域包括一张数据透视表报表。 cn.bab.la 10. For example, you can define formatting for multiple levels of data, there are multiple levels of subtotals possible in a PivotTable, etc. 譬如，你可以在数据透视表中定义多种级别数据的格式，也可以设置尽可能的多种级别的分类汇总。 club.excelhome.net 1. You can also create PivotTable and PivotChart reports from a list of work items. 您也可以通过工作项列表创建数据透视表和数据透视图报表。 msdn.microsoft.com 2. Occurs after a PivotTable report closes the connection to its data source. 在数据透视表关闭到其数据源的连接后发生。 msdn2.microsoft.com 3. Occurs after a PivotTable report opens the connection to its data source. 在数据透视表打开到其数据源的连接后发生。 msdn2.microsoft.com 4. The OWC library contains four principal components: Spreadsheet, Chart, PivotTable, and Data Source. OWC库包含四个主要的组件：电子表格组件，图表组件，透视表组件和数据源组件。 www.moon-soft.com 5. Import External Data Function Pivottable Chart Conditional Format Protection Marco Customize Toolbar 导入外部数据函数数据透视表图表条件格式工作表保护宏自定义工具栏 wenku.baidu.com 6. The Excel PivotTable's Application in the Educational Administration Management Information System of the Radio and TV University Excel透视表在电大教务管理信息系统中的应用 www.ilib.cn 7. Keys for adding fields and totals and changing the layout of a PivotTable view 用于添加字段和汇总以及更改数据透视表视图布局的快捷键 office.microsoft.com 8. pivottable report formats are provided to generate formatting automatically 数据透视表报表格式可用于自动生成格式。 www.ichacha.net 9. Move the selected row or column field in the PivotTable view to a higher level 将数据透视表视图中的选定行或列字段移到更高级别 office.microsoft.com 10. Design the layout and format of a PivotTable report 设计数据透视表的布局和格式 office.microsoft.com 1. Move the selected row or column field in the PivotTable view to a lower level 将数据透视表视图中的选定行或列字段移到更低级别 office.microsoft.com 2. Here is a screenshot of the dialog illustrating how to change the data source of a PivotTable based on an OLAP data source. 下面是对话框的一个截图，举例说明怎样改变一个基于OLAP数据源的数据透视表的数据源。 www.ejchina.com 3. PivotTable reports for Sales 2: Compare sales of your products 销售额数据透视表2：比较产品的销售情况 office.microsoft.com 4. Turn subtotals and grand totals on or off for the selected field in the PivotTable view 对数据透视表视图中的选定字段打开或关闭小计和总计 office.microsoft.com 5. Use a PivotTable report to make external table data available in Excel Services 使用数据透视表使外部表数据可用于ExcelServices office.microsoft.com 6. Add a new total field for the selected field in the PivotTable view by using the Standard Deviation Population summary function 使用“标准偏差总体”汇总函数为数据透视表视图中的选定字段添加新的汇总字段 office.microsoft.com 7. "Count how often multiple values occur by using a PivotTable report" section “使用数据透视表计算多个值出现的次数”部分 office.microsoft.com 8. Automatically show items or details in PivotTable view 在数据透视表视图中自动显示项目或明细 office.microsoft.com 9. Another easy way to add the Quarter field to the Column area is to use the PivotTable Field List 将“季度”字段添加到“列”区域的另一种简单方法是使用“数据透视表字段列表” office.microsoft.com 10. Copy the selected data from the PivotTable view to the Clipboard 将数据透视表视图中的选定数据复制到剪贴板上 office.microsoft.com 1. PivotTable report showing sales for each quarter 显示每个季度的销售额的数据透视表 office.microsoft.com 2. Keys for formatting elements in PivotTable view 用于设置数据透视表视图中的元素格式的快捷键 office.microsoft.com 3. Move the selected field in the PivotTable view to the filter area 将数据透视表视图中的选定字段移到筛选区域 office.microsoft.com 4. Move the selected field in the PivotTable view to the column area 将数据透视表视图中的选定字段移到列区域 office.microsoft.com 5. Move the selected field in the PivotTable view to the detail area 将数据透视表视图中的选定字段移到明细区域 office.microsoft.com 6. Count unique values in a range by using a PivotTable 使用数据透视表对区域中的唯一值进行计数 office.microsoft.com 7. Move the selected field in the PivotTable view to the row area 将数据透视表视图中的选定字段移到行区域 office.microsoft.com 8. Count cells in a column or row by using a PivotTable 使用数据透视表对列或行中的单元格进行计数 office.microsoft.com 9. Add values in a column or row by using a PivotTable 使用数据透视表将列或行中的值相加 office.microsoft.com 10. Drag any field button from here to the PivotTable 请将此处的任意字段按钮拖至数据透视表 www.jukuu.com 1. Make text underlined in the selected field of the PivotTable view 使数据透视表视图的选定字段中的文本加下划线 office.microsoft.com 2. Make text italic in the selected field of the PivotTable view 使数据透视表视图的选定字段中的文本倾斜 office.microsoft.com 3. Make text bold in the selected field of the PivotTable view 使数据透视表视图的选定字段中的文本加粗 office.microsoft.com 4. Add the highlighted field in the Field List pane to the area in the PivotTable view that is displayed in the Add to list 将“字段列表”窗格中突出显示的字段添加到“添加到”列表中显示的数据透视表视图中的区域中 office.microsoft.com 5. A PivotTable report of sales data 销售数据透视表 office.microsoft.com |
||||||||||
| 随便看 |
|
英汉双解词典包含2704715条英汉词条，基本涵盖了全部常用单词的翻译及用法，是英语学习的有利工具。