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.
Search JabSto ::

Custom Search