Microsoft Office Tutorials and References
In Depth Information
Exhibit 5.10 Case count summary selection
various regions and gender combinations— East , We s t , etc. Exhibit 5.15 shows
the results of the extension. Note that I have selected Age as the new Report
9. One final feature of special note is the capability to identify the specific respon-
dents’ records that are in the cells of the data field. Simply double-click the cell
of interest in the Pivot Table, and a separate sheet is created with the records of
interest. This allows you to drill-down into the records of the specific respondents
in the cell count. In Exhibit 5.16, the 11 males that responded Good to Product 1
are shown; they are respondents 1, 2, 25, 4, 22, 21, 20, 19, 18, 14, and 11. If you
return to Exhibit 5.12, you can see the cell of interest to double-click, N13.
5.3.3 PivotCharts
Now, let us repeat the process steps described above to construct a PivotChart . There
is little difference in the steps to construct a table versus a chart. In fact, the process
Search JabSto ::

Custom Search