Inserting a Data Sheet

The Data Sheet provides a tabular view of selected fields in a table. It is typically used to examine the underlying raw data and for visually correlating across multiple measures (for example, does a discount increase as the transaction amount increases).

Features

• Row ordering by column(s) including nested sorts

• Column rearranging

• Text search

• Export

• Zoom out to convert data to Bar charts

Inserting a New Data Sheet

1. In the Author Ribbon, click on the "Add New Chart" button (under Pick Charts) and click Data Sheet.

2. If the Data Configuration form is not already showing, click the configuration button to open the Data Configuration window. If the Data Table shown is not the one you want, use the drop-down list to select the right one.

3. Select all fields to be included in the datasheet by clicking the checkboxes next to the field name(s). To select all fields, click the Check All button (or click Uncheck All to de-select all fields).

4. Click OK. The datasheet displays the data you selected in a columnar format.

See Data Sheet Toolbar for a description of toolbar functions.

See also:

• Data Sheet Toolbar

• Data Sheet Chart

• Visual Discovery