Select an element in PivotTable or PivotChart view - Access

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this link

Printer-Friendly Version Bookmark and Share

Select an element in PivotTable or PivotChart view

Applies to: Microsoft Office Access 2003

Show Select an element in PivotTable view

Open a datasheet or form in PivotTable view.
Do one of the following:

Show Select one or more data cells

To select a single cell, click it. To select a group of cells, click and drag the mouse pointer until all the cells you want are selected.

Show Select a row, column, filter, detail, or total field

Click the field label.

Notes

Selecting a row (row field: A field in the row area of PivotTable view. Items in row fields are listed down the left side of the view. Inner row fields are closest to the detail area; outer row fields are to the left of the inner row fields.) or column field (column field: A field in the column area of PivotTable view. Items in column fields are listed across the top of a PivotTable list. Inner column fields are closest to the detail area; outer column fields are above the inner column fields.) also selects all of the items of data in the field.
If detail data is displayed for several items so that the field label is displayed more than once, clicking one instance of the field label selects all instances.
Formats that you apply affect the data cells of all total fields in the view.

Show Select one or more items

To select a single item (item: A unique element of data within a field. When a lower level of items is available for display in a PivotTable list or the field list, an expand indicator (+) appears beside the item.), click the item label. To add more items to the selection, press and hold the CTRL key when clicking the item labels.
To select a range of items, click the label of the first item, press SHIFT, and then click the label of the last item.

Notes

Selecting an item selects all of the data for that item.
Formats that you apply to one item affect all other items in the field.

Show Select a subtotal or grand total

Click the subtotal or grand total.

Note Selecting a subtotal or grand total also selects all of the data for the subtotal or grand total.

Show Select a drop area

Click Properties on the PivotTable toolbar, and then click the Captions tab.
In the Select caption list, select the item you want.

Note Formats that you apply to a drop area (drop area: An area in PivotTable or PivotChart view where you can drop fields from the field list to display the data in the field. The labels on each drop area indicate the types of fields that you can create in the view.) do not affect other drop areas.

Show Select an element in PivotChart view

Open a datasheet or form in PivotChart view (PivotChart view: A view that shows a graphical analysis of data in a datasheet or form. You can see different levels of detail or specify the layout by dragging fields and items or by showing and hiding items in the drop-down lists for the fields.).
Click once on the item in the chart you want to select. To select an entire group of items, such as an entire data series (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern. You can plot one or more data series in a chart.), click a second time.
Note You can also select items in the Select box on the General tab of the Properties dialog box (click Properties on the PivotChart toolbar). For example, to select the first value axis on the chart, click Value Axis 1 in the Select box.