[1] Open an original worksheet in Excel, with the mouse, select the data in the cell, and then the mouse to the Insert tab, click the Drop-down button in the PivotTable option group, and select PivotChart in the Drop-down menu that appears;
[2] A "Create a PivotTable" dialog box pops up, and the text after "Table/area" shows the data we selected, then click OK;
[3] After that we'll find the PivotChart filter pane and the PivotTable Field list in the worksheet, and in the Fields list, select the option that you want to summarize the data, where we'll sum up all the data;
[4] then put the mouse on the blank place of the worksheet click, you will find that the previous table data has been summed up, the effect of the chart below;
Tip: The PivotChart report has been created, and it's important to note that you must select the data cells that you want to summarize before you create the perspective.
Note : more Wonderful tutorials please focus on the Triple computer Tutorials section, triple Computer office group: 189034526 Welcome to join