Simply copy and paste it into a blank Excel file to get started. Now that we have a table, simply click on any cell in the table and then select Insert ... the box next to each slicer you ...

Add the Personnel column to the Axis (Categories) list and as a slicer. At this point, we have a PivotTable, which Excel created for you, a PivotChart and a Slicer. You could position the two and ...