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
Step5:Select the fields Office and Name.
Step 6: Click-and-drag the Charge field tothe 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, selectCount, click OK.
The result will look like:
