Filter Pareto Data using Slicers in Excel
1. Put raw data in Table format
2. Add Month Column using EOMONTH Formula
=EOMONTH([@[Date]],-1)+1
3. Add “Filter Column” using Subtotal Formula
=SUBTOTAL(3,[@[Project Name]])
4. Add slicers for columns to filter
5. Use Filter function with Filter Column
6. Create Summary of Failure Counts
7. Create Named Ranges for Failures and Counts
8. Create Pareto Chart
9. Replace Chart Ranges with Named Ranges
0:00 Intro
2:13 Put raw data in Table format
2:33 Add Month Column using EOMONTH Formula
3:16 Add “Filter Column” using Subtotal Formula
3:43 Add slicers for columns to filter
4:02 Use Filter function with Filter Column
4:58 Create Summary of Failure Counts
5:30 Create Named Ranges for Failures and Counts
6:18 Create Pareto Chart
6:47 Replace Chart Ranges with Named Ranges