1. Create a pivot table(chart) and set the row label as order date and column label as product category and the values are sales, divide the row label into 4 quarters according to the order date. Draw a column chart where x-axis is the quarter of a year and y-axis is the total sales. (see figure 1 for reference)
2. Plot a pie chart for the total order quantity for different order quantities. . (see figure 2 for reference)

1017445.32_1643308.32 4014597.764 3 Sum of Sales Column Labels 4 Row Labels Furniture Office Supplies Technology Grand Total 5 Qtr1 1429189.378 900715.67 1568783.043 3898688.091 6 Qtr2 1159992.926 962646.13 1285599.277 3408238.333 7 Qtr3 1235564.114 871954.98 1486557.543 3594076.637 8 Qtr4 1353844.124 9 Grand Total 5178590.542 3752762.1 5984248.182 14915600.82 10 11 Sum of Sales demonstration 12 1800000 13 1600000 14 1400000 15 1200000 16 Product Category 1000000 17 Furniture 800000 18 Office Supplies 600000 19 Technology 400000 20 200000 21 22 Qtr1 Qtr2 Qtr3 Qtr4 23 24 Order Date 25 0 Figure 1 Sum of Order Quantity demonstration Critical High Low Medium Not Specified Grand Total Figure 2 1017445.32_1643308.32 4014597.764 3 Sum of Sales Column Labels 4 Row Labels Furniture Office Supplies Technology Grand Total 5 Qtr1 1429189.378 900715.67 1568783.043 3898688.091 6 Qtr2 1159992.926 962646.13 1285599.277 3408238.333 7 Qtr3 1235564.114 871954.98 1486557.543 3594076.637 8 Qtr4 1353844.124 9 Grand Total 5178590.542 3752762.1 5984248.182 14915600.82 10 11 Sum of Sales demonstration 12 1800000 13 1600000 14 1400000 15 1200000 16 Product Category 1000000 17 Furniture 800000 18 Office Supplies 600000 19 Technology 400000 20 200000 21 22 Qtr1 Qtr2 Qtr3 Qtr4 23 24 Order Date 25 0 Figure 1 Sum of Order Quantity demonstration Critical High Low Medium Not Specified Grand Total Figure 2