h

Visualize the Data Hint: You should still be on the Inventory Listing tab. Create a PivotTable based on all inventory balances displayed for all five years. # New worksheet tab name: Inventory PivotTable (PG-7a) Display the Year 5 Inventory Balances: (PG-7b) e Rows area: Department Columns area: Product Category # Adda Filter: Exclude all but the Northeast shipping region. (PG-7c) # Adda slicer: Show only data for product categories with an internal classification of at least Level 6. (PG-7d) Create a Clustered Bar PivotChart that displays the Internal Classification category in the legend (below any already existing categories in the legend field). Position the PivotChart with the slicer in a logical manner. (PG-8)