Q1.
- Take a new workbook.
- Create a sales report of four quarters.
- Add table formatting to it.
- Create a column stack pyramid chart.
Format it and move the chart to a sheet.
Q2.
Create Pivot Table & Pivot Chart shown as per data shown below.
- Remove total column from table.
- Remove quarters column, keep only name and total in Pivot chart.
- Format table and chart properly.
- Move pivot chart to sheet.