1. Select a data range. Under the Insert option of the PivotTable report, select New Worksheet as the location to generate the PivotTable report. Then, in the PivotTable field on the right, drag the field name of the business representative into the row, drag the company name into the column, and then drag it into the column.

2. Select the data range, and in the chart pivotchart under the Insert option, select the new worksheet as the location for generating the PivotTable report. Then, in the PivotTable field on the right, drag the field name Salesman into the row, drag the company name into the column, and then drag the sales amount.