Step 1: Select the "Insert" tab "Pivot Table" or "Pivot Chart",

Step 2: After selecting pop-up "Create Pivot Table and Pivot Chart" window,

Step 3: Select the data you want to analyze and click OK,

Step 4: A blank pivot table will appear,

Step 5: On the right side of the "Pivot Table Field List" in the need to analyze the check box in its check box. After checking the box, the data are all inserted in the "Axis Fields (Classification)", according to the actual sub licensing requirements to drag to the "Report Filter", "Column Label", "Row Label" "Value".

Step 6: For the data labels in the chart, you can select the content, right-click and select "Add Data Label" to display the data on the chart,

Step 7: "Column Label", "Row Label" for the pivot table, and "Row Label" for the pivot table. Row Label" for the pivot table columns and rows of the option content, in order to change the main content of the need to analyze, you can also report the contents of the field directly dragged to the table,

Step 8: "numerical value" you can select the summation, counting, the average, the maximum value, etc., to customize the value of the content that needs to be analyzed

After selecting the chart, the "Data Selection View Tools" dynamic tab will appear at the top,

Step 9: After selecting the chart, the "Data Selection View Tools" dynamic tab will appear at the top.

Step 9