6. Management would like to know - what is the split in terms of prot. across the Product Categories, for each quarter. Use a Line Chart to show the numbers. Rank the Product categories in terms of prot. a. g. h. Create a new worksheet titled "06 - Qtr. Prot" and insert a new pivot table for the data in the sheet - "Raw data". Move the worksheet after 05 worksheet. . List all the Product Categories in the lst column. . Split the Quarter across the categories [ Hint: Drag the Date eld in the "Column Label" area] Use the following to group the date eld into quarters: \"Select any cell in the Date column in the Pivot Table. Go to Pivot Table Tools -:=- Analyze -=- Group -> Group Selection." . Add the profit by category and quarter. Format the data in currency format. . Add meaningful column labels. Add a meaningful title to the worksheet at the top and center it across the pivot table. Select the Pivot Table and Click on 0ptions> Pivot Chart Insert a Column Chart of your choice