Summarize Real Estate Sales and Commission Data

1. Open HROctSales.xlsx and save it with the name 4-HROctSales.

2. Create the PivotTable shown in Figure 4.10 in a new worksheet named PivotTable. Apply the Tan, Pivot Style Light 18 style and set the column width to 18 characters for all columns. Change the page layout to Landscape orientation.

3. Create the PivotChart shown in Figure 4.11 in a new worksheet named PivotChart. Use the 3D Clustered Column chart type and apply the Style 11 style.

4. Preview the PivotTable and PivotChart worksheets.

5. Save and then close 4-HROctSales.xlsx.

Hillsdale Realtors Hillsdale Realtors