Use the following steps in explanation.
Explanation/Reference:
Explanation:
Step 1: In the name box type B4:I299 (or Click cell B4, shift-click cell I299).
Step 2: Click the INSERT tab, click the PivotChart button, and select PivotChart.

Step 3: In the Create PivotChart dialog box make sure New Worksheet is select, and click OK.

Step 4: Rename the worksheet by right-clicking on the sheet name (bottom left corner), select Rename from the context menu, and type: Billing_Pivot

Step 5: Select the fields Office and Name.

Step 6: Click-and-drag the Charge field to the Values area.

Step 7: Click-and-drag the Duration field to the Values area, then click on the new Sum of Duration box, and select Value Field Settings.

Step 8: In the Value Field Settings box, select Average, click OK.

Step 9: Again click-and-drag the Duration field to the Values area, then click on the new Sum of Duration box, and select Value Field Settings.

Step 10: In the Value Field Settings box, select Count, click OK.

The result will look like: