{"id":6267,"date":"2021-07-21T17:29:49","date_gmt":"2021-07-21T17:29:49","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=6267"},"modified":"2024-03-28T10:49:52","modified_gmt":"2024-03-28T10:49:52","slug":"create-pivot-and-chart-slicers","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/create-pivot-and-chart-slicers\/","title":{"rendered":"Create Pivot and Chart Slicers in Excel"},"content":{"rendered":"\n
Pivot Tables<\/strong> are great to manipulate large amounts of data and creating reports for various stakeholders. They filter our data.<\/p>\n\n\n\n We can all agree that these representations of data are not very user-friendly. Luckily, we have a solution for this as well. To present our data in a much neater way, we can use visual filters, better known as slicers.<\/p>\n\n\n\n Excel Slicers<\/strong> are graphic representations of tables, pivot tables, and pivot charts<\/a>. They can be used in all kinds of reports. The earliest version of their appearance is in Excel 2010<\/strong>.<\/p>\n\n\n\n In their essence, there is little difference between pivot table filters<\/a> and slicers. However, unlike pivot filters, slicers are easier to use, you can connect them to multiple tables and charts, they can be moved, and work better in touch screen environments. On the downside, they cannot be easily automated with VBA code.<\/p>\n\n\n\n As in previous examples, we will create a table with NBA players, their clubs, conferences, and their statistics from three nights of basketball.<\/p>\n\n\n\nInsert Slicer into Excel Table<\/h2>\n\n\n\n