Create a PivotTable, PivotChart, and Slicer
You want to complete a detailed sales analysis. To complete the task, you will create a PivotTable, PivotChart, and corresponding Slicer.
a. Create a PivotTable based on the range A7:G32. Place the PivotTable in cell I17 on the current worksheet.
b. Place Payment Type in the ROWS box and Amount in the VALUES box. Format the Amount with Accounting Number Format.
c. Insert a PivotChart using the Pie chart type based on the data. Place in the upper-
left corner of the chart in cell 123.
d. Format the Legend of the PivotChart to appear at the bottom of the chart area.
e. Format the Data Labels to appear on the outside end of the chart.
f. Insert a Slicer based on Date. Place in the upper-left corner of the Slicer in cell L9.
g. Save the workbook.
Attachment:- Manufacturing.rar