Microsoft Office Tutorials and References

In Depth Information

**Organizing Lists in Pivot Tables**

Deleting a Sparkline

After you’ve created one or more Sparklines, you may want to delete them.

To delete a Sparkline, follow these steps:

1. Click on the cell that contains a Sparkline.

2. Click on the Design tab.

3. Click the Clear icon in the Group category.

Your chosen Sparkline disappears.

Organizing Lists in Pivot Tables

Ordinary spreadsheets let you compare two sets of data such as sales versus

time or products sold versus the salesperson who sold them. Unfortunately,

if you want to know how many products each salesperson sold in a certain

month, deciphering this information from a spreadsheet may not be easy.

That’s where pivot tables come in. A
pivot table
lets you yank data from your

spreadsheet and organize it in different ways in a table. By rearranging (or

“pivoting”) your data from a row to a column (and vice versa), pivot tables

can help you spot trends that may not be easily identified trapped within the

confines of an ordinary spreadsheet.

Creating a pivot table

Pivot tables use the column headings of a spreadsheet to organize data in

a table. Ideally, each column in the spreadsheet should identify a different

type of data, such as the name of each salesperson, the sales region he or she

works in, and the total amount of sales made, as shown in Figure 10-13.

After you design a spreadsheet with multiple columns of data, follow these

steps to create a pivot table:

1. Select the cells (including column labels) that you want to include in

your pivot table.

2. Click the Insert tab.

3. Click the top half of the PivotTable icon in the Tables group.

The Create PivotTable dialog box appears, as shown in Figure 10-14.