Creating Pivot Chart in Excel 2007:-


You follow these steps to create your first pivot chart:

1. Select one cell in your dataset and choose Insert, PivotTable, PivotChart, as shown in the first Figure (given below).



(You use the drop-down at the bottom of the PivotTable icon to access the PivotChart menu item.)

2. In the Create PivotTable with PivotChart dialog, Excel guesses about the extent of your dataset. If your dataset is either a table or follows the rules given earlier, Excel guesses correctly. In this dialog, you can choose to create the pivot table on the current worksheet or on a new worksheet. The default is to use a new worksheet. Click OK.

You now have the makings of a blank pivot table and pivot chart. There are four elements visible on the worksheet shown in the second Figure (given below).



(You are ready to start building a pivot chart by adding fields to the report.)

a. Columns A;C contain a blank area where the pivot table will be built.

b. Columns E;M contain the area where the chart will be built.

c. The PivotTable Field List box contains a list of fields at the top of the dialog and four drop zones at the bottom of the dialog. (If your field list looks different than the one in the second Figure, you can select the drop-down at the top of the list and choose Fields Section and Areas Section Stacked.)

d. The PivotChart Filter Pane box is an abbreviated version of the PivotTable Field List box. You can use the icon in the upper-right corner of this pane to turn on or off the larger field list.

Four new PivotChart Tools ribbon tabs appear. The first three tabs—Design, Layout, and Format—are identical to the charting ribbon tabs that you have been using throughout this book. You can use the Analyze tab to toggle on or off the PivotTable Field List box or PivotChart Filter Pane box or to refresh the pivot chart. Look into the second Figure.

Say that you want to create a chart that summarizes revenue by product. To do so, you follow these steps:

1. Choose the check box next to the Product field in the top of the PivotTable Field List box. Excel shows a unique list of products in column A of the pivot table. The Product field heading appears in the Axis Fields section of the PivotTable Field List box. You do not see a chart yet; you need to specify at least one field in the Σ Values area of the PivotTable Field List box.

2. Click the Revenue field in the top of the PivotTable Field List box. If your data contains no blank cells, the Revenue field appears in the Σ Values area of the field list, and your chart appears as shown in the third Figure (given below). If the Revenue field instead moves to the Axis Fields area, you have one or more blank or text cells in your data. In an ideal world, you would fix these. Instead, you can drag the field from the Axis Fields drop zone to the Σ Values drop zone.



(Excel starts with the default chart, as defined in your copy of Excel.)