Instructions:

Download the Pivot Table Project Starting Data workbook that is attached to the Excel Pivot Table Project

assignment folder in D$2$L to your computer and then create the pivot tables, charts and slicers described

below.

Pivot #$1(25$ points$)$

Create a pivot table in a new worksheet. Name the worksheet Top $10$ Customers

The pivot table should show the total sales $($Document amount$)$ for the invoice and order document

types only for the top $10$ customers $($by Customer Name$)$ in descending order. It should also contain a

Grand Total column.

Make sure to only include invoice and order types in your data. The invoice total and order total

for each customer should be in separate columns.

Add the title Top $10$ Customers to the pivot table.

Change column$/$row headings on the pivot table to accurately describe the data that is being

displayed.

Use appropriate and professional formatting on title, currency and heading cells. Currency cells should

have $0$ decimal places.

Once the pivot table is created, insert a $3-$D stacked Column Pivot Chart based on the pivot table. The

graph should show the customer on the bottom axis and should be on the same worksheet as the pivot

table so that both the pivot and graph can be seen at the same time.

Add an appropriate title and legend to the chart

Show a Data Table with No Legend Keys at the bottom of the chart area

Stretch the chart so it is large enough to read all of the chart data

Arrange the pivot table and chart so they can all be easily viewed on the same sheet.