Click the frame to display the PivotTable Fields pane. If it doesn’t appear, right-click the frame and choose it from the resulting dialog. Using Figure C as a guide, drag fields to the lists below.

You can also use slicers to filter the data in charts. And if you have more than one PivotTable based on the same data set, you can use the same slicer for all the PivotTables.

Finally, format the values in the second column as follows: ... Now, let’s review a few ways to change the information displayed by the same pivot table. Figure D. Let’s practice.

Using Excel’s PivotTables and PivotCharts, you can quickly analyze large data sets, summarize key data, and present it in easy-to-read format. Here’s how to get started with these powerful tools.