The list or table that's used to create a PivotTable or PivotChart report. Source data can be taken from an Excel table or range, an external database or cube, or another PivotTable report.
The cell ranges that you consolidate in the destination area you specify. Source areas can be on any worksheet in a workbook, in other open or closed workbooks, or on Lotus 1-2-3 worksheets.
A way to arrange data based on value or data type. You can sort data alphabetically, numerically, or by date. Sort orders use an ascending (1 to 9, A to Z) or descending (9 to 1, Z to A) order.
A cell that has been linked to a non-repeating element in an XML map.
A workbook set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the workbook sees the changes made by other users.
In 2-D stacked bar and column charts, lines that connect the data markers in each data series that are used to emphasize the difference in measurement between each series.
A field that's displayed in the series area of a PivotChart report. Items in a series field are listed in the legend and provide the names of the individual data series.
A chart axis that represents the depth dimension in a true 3-D chart. It displays the series names as arbitrary text values; it cannot display scaled numerical values.