Page 170 - Ms Excel Note and Workbook

MICROSOFT EXCEL NOTE AND WORKBOOK

4. The PivotChart will appear.

TIP
To view different subsets
of information, change the
columns or rows in your
PivotTable..

Try using filters or slicers to narrow down the data in your PivotChart. To view different subsets of
information, change the columns or rows in your PivotTable. In the example below, we've changed
the PivotTable to view the monthly sales for each salesperson.

161 | P a g e