0 1 figure 1 is the sales data table. In order to compare the sales situation of each department and each salesman, it is necessary to create a dynamic chart.
First select a blank cell, such as D2, and then click Insert-Pivot Table in the toolbar;
In the dialog box for creating a PivotTable, we select the cells of salesperson, department and sales volume as the selection area, as shown in figure 1 ... and then check these items in the PivotTable field window on the right;
After checking, you will see the "Line Labels" window in the table. Click the cell of the row label, and then click Insert-Slicer;
In the "Insert Slicer" dialog box that pops up, we check the items salesperson and department, and click OK to pop up these two slicers at the top of the table, as shown in Figure 2 below. ...
Next, click the cell "line label" again, but this time we choose "insert"-"two-dimensional histogram";
If we click on different salespeople and departments, the histogram will show the sales of the corresponding salespeople and departments. For example, if we click on salesperson Wang Wu and marketing department A, the bar chart will show the sales situation in Wang Wu, as shown in Figure 2.
We want to compare the sales of all departments and salespeople comprehensively, so hold down the Ctrl key on the keyboard and select all the options in the slicer, so that you can see the histogram shown below. ...