The application of data perspective in Excel in the statistics of teachers ' teaching hours

The application of data Perspective in Excel in the statistics of teachers ' teaching hours

1, with Ecxel2013 Open the document "Lesson statistics". xlsx, open the interface as follows:

2. Select any cell in any area of the statistic, click the menu insert → PivotChart report, select PivotChart, and open the Create PivotChart dialog box, as shown in:

3, in the pop-up dialog box, the entire area of the original data is selected by default, the area of the parsed data is confirmed as the entire worksheet, and the location of the PivotChart report is selected as a new worksheet: Click OK, and Excel inserts a new worksheet that contains the PivotChart report:

4. In the PivotChart Field List pane, lay out the fields as follows: The class name, course name and total Hours field drag to the axis (category) list box, drag the weekly field to the Legend (series) list box, and drag the number of hours field to the Value list box. As shown in the following figure:

5, the above PivotChart report on the "Week" to group: Select the field in the PivotChart data analysis area in the cell, and then right-click, pop-up options, select Create Group, open the Combo dialog box, as shown in the figure: