Page 164 - Excel Data Analysis
P. 164

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







                     EXCEL DATA ANALYSIS




                  FILTER A PIVOTCHART FIELD



                       he filtering options available with PivotCharts simplify  that contain that item value display on the entire
                       the process of analyzing the data displayed on the  PivotChart. You must select at least one item for each field
                  T PivotChart; if you only want to see specific values on  or Excel displays an error message when you try to close the
                  your PivotChart, you can filter the corresponding field. You  box. See the section "Create a PivotChart from an External
                  can filter each field on a PivotChart to show only those  Database" for more information on the Page, Categories,
                  records that meet your criteria. For example, if the Category  and Series areas of the PivotChart.
                  area contains a Customer field, you can filter specific  The items for each field come from the data that generated
                  customer numbers and view sales from only specific  the PivotChart. If you created your PivotChart using an
                  customers.
                                                                      Excel list, the items in the box are the actual labels from the
                  By default, when you add a field to a PivotChart, all items  corresponding Excel column. If you created the PivotChart
                  display in the row or column. You can opt out of the default  from an External database, the fields correspond to the
                  to display only certain item values. You can select any  names of the data fields. If you do not see the appropriate
                  combination of the items in the menus for both the  item in the box, check your original data values from the
                  Categories and Series areas. If you assign a field to the Page  original Excel list or database. See Chapter 2 for information
                  area, you can either select all items or just one individual  on data lists and Chapter 5 for information on databases.
                  item. If you specify a single item for the field, only records



                   FILTER A PIVOTCHART FIELD


























                  ⁄ Click the down arrow                             ■ A list box displays the   ¤ Click Show All to remove
                  next to the field that you                         available items.          the selection from the check
                  want to filter.                                                              boxes.






                   150
   159   160   161   162   163   164   165   166   167   168   169