b$.$ Create another pivot chart using the Survey table, placing it in cell A$10$ on the

PivotTables worksheet.

Use the Speakers, Return and ID fields to create the PivotChart

shown below:

Name the PivotTable speaker pivot

Place the PivotChart in the range K$7$:$017$ on the Report worksheet

Click the first PivotChart to select it and then create a slicer for the School field.

a$.$ Move and resize the slicer to cover the range E$2$:$05$

b$.$ Arrange the buttons in $4$ columns.

c$.$ Connect the slicer to both PivotTables in the workbook.

Use the School slicer to filter the PivotCharts to show only the summaries of the public

school attendees.