When you create a DataPilot table, you can select the source
data and define where to place the result.
To select the data source and place the result in the area
that you want, complete the following steps:
- Click . The Create
DataPilot Table window opens.
- Click Shrink to temporarily hide
the window.
- Select the range in the sheet, and then click the Maximize button. The selected cells are the data source.
- If you select a cell in a range of cells before you launched
the Create DataPilot Table window, the cells
around the selected cell are the data source.
- Put the cursor in the Range field
and type your entries in the Range field to
define the data source.
- To place the result, click New
Sheet.
- Click Existing place.
- Click the Shrink button to temporarily
hide the window.
- Select the range in the sheet, and then click the Maximize button.
The result is placed in the select range.