How to use PivotTables and PivotCharts in Excel

4 weeks ago AndyC

The starting data set for our PivotTable examples.

Starting a PivotTable in Excel.

Your blank canvas for PivotTable creation.

This PivotTable shows the quantity of each product type sold.

[…]

The starting data set for our PivotTable examples.

Starting a PivotTable in Excel.

Your blank canvas for PivotTable creation.

This PivotTable shows the quantity of each product type sold.

In this version of the PivotTable, another element is shown: Order_Category.

Reversing how Product_# and Order_Category are displayed in the PivotTable.

The PivotTable now has columns for different unit prices.

Filtering the PivotTable to show only Products 1, 2, and 3.

Filtering the PivotTable to show only items that cost $4.00, $5.00, and $7.00.

Another way to filter PivotTable data is by using the Filters area in the PivotTable Fields sidebar.

Starting a PivotChart in Excel.

Your blank canvas for PivotChart creation.

The PivotChart graphically displays the information from the PivotTable at left.

Choosing a different chart type for the PivotChart.

The PivotChart in 3-D pie chart form.

The PivotChart with Large Orders collapsed into a single slice of pie.

About Author

AndyC

Andy Curtis is an award-winning security consultant, researcher and public speaker. He has been working in the computer security industry since the early 1990s, having been employed by state and federal government, leading healthcare and banking providers across three continents. He has given talks about computer security for some of the world’s largest companies, worked with law enforcement agencies on investigations into hacking groups, and is a regular voice on TV and radio explaining IT security threats.

See author's posts