Page 157 - Excel Data Analysis

09 537547 Ch08.qxd 3/4/03 12:06 PM Page 143

CREATING PIVOTCHARTS 8

When you use the Query Wizard to select The Query Wizard lets you sort the database fields
the database table fields to import for the as it imports. You can skip this step when importing
PivotChart, you have the option of filtering the database table fields for use with a PivotTable or
data based on a specific data value. If you want PivotChart. Because both report types are dynamic,
to import a large database table, consider Excel sorts the records based on the report
filtering out only the desired range of data selections. You can customize the sorting of the
values. For example, if the database contains values displayed on the PivotChart by clicking
sales information for the last year, but you only Data ➪ Sort within Excel.
want to show the sales for the last three months,
you can use the Filter Data page of the Query
Wizard to filter out the excess data records. By
filtering the data records, you reduce the number
of records that you need to work with in the
PivotChart.

MS Access Database*

■ The second page of the ˇ Click Get Data. ■ The Choose Data Source Note: See Chapter 5 for information
Wizard appears. dialog box opens. on importing data fields from a
database table.
Á Select the data fields from
the appropriate database.
CONTINUED
143