Microsoft Office Tutorials and References
In Depth Information
Chapter 10: Using PivotTables and PivotCharts
Using PivotTables and
IN THIS CHAPTER, YOU WILL LEARN HOW TO
▪ Analyze data dynamically by using PivotTables.
▪ Filter, show, and hide PivotTable data.
▪ Edit PivotTables.
▪ Format PivotTables.
▪ Create PivotTables from external data.
▪ Create dynamic charts by using PivotCharts.
When you create Microsoft Excel 2013 worksheets, you should consider how you want the
data to appear when you show it to your colleagues. You can change the formatting of
your data to emphasize the contents of specific cells, sort and filter your worksheets based
on the contents of specific columns, or hide rows containing data that isn’t relevant to the
point you’re trying to make.
One limitation of the standard Excel worksheet is that you can’t easily change how the data
is organized on the page. For example, in a worksheet in which each column represents an
hour in the day, each row represents a day in a month, and the body of the worksheet
contains the total sales for every hourly period of the month, you can’t change the worksheet
quickly so that it displays only sales on Tuesdays during the afternoon.
However, Excel has a tool that you can use to create worksheets that can be sorted, filtered,
and rearranged dynamically to emphasize different aspects of your data. That tool is the
In this chapter, you’ll create and edit PivotTables from an existing worksheet, focus your
PivotTable data by using filters, format PivotTables, create a PivotTable that has data
imported from a text file, and summarize your data visually by using a PivotChart.