{"id":15358,"date":"2024-10-29T09:32:18","date_gmt":"2024-10-29T09:32:18","guid":{"rendered":"https:\/\/www.pickl.ai\/blog\/?p=15358"},"modified":"2024-10-29T09:32:20","modified_gmt":"2024-10-29T09:32:20","slug":"slicers-in-excel","status":"publish","type":"post","link":"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/","title":{"rendered":"Slicers in Excel: A Guide to Enhancing Data Visualisation"},"content":{"rendered":"\n<p><strong>Summary: <\/strong>Customising slicers in Excel enhances their functionality and visual appeal, improving user interaction with data. By adjusting styles, sizes, layouts, and settings, you can create a more engaging experience that facilitates effective Data Analysis and presentation, making reports easier to navigate and understand.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#Introduction\" >Introduction<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#What_are_Slicers_in_Excel\" >What are Slicers in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#Advantages_of_Using_Slicers\" >Advantages of Using Slicers<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#User-Friendly_Interface\" >User-Friendly Interface<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#Enhanced_Visual_Clarity\" >Enhanced Visual Clarity<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#Multiple_Selections\" >Multiple Selections<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#Connection_with_Multiple_PivotTables\" >Connection with Multiple PivotTables<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#Dynamic_Dashboards\" >Dynamic Dashboards<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#How_to_Insert_Slicers_in_Excel\" >How to Insert Slicers in Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#Step-by-Step_Instructions\" >Step-by-Step Instructions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#Alternative_Methods\" >Alternative Methods<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#How_to_Use_Slicers_to_Filter_Data\" >How to Use Slicers to Filter Data<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#Example_Scenario\" >Example Scenario<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#Customising_Slicers\" >Customising Slicers<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#Change_Slicer_Style\" >Change Slicer Style<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#Create_a_Custom_Slicer_Style\" >Create a Custom Slicer Style<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#Resize_and_Position_Slicers\" >Resize and Position Slicers<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#Change_Button_Layout\" >Change Button Layout<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#Customise_Slicer_Settings\" >Customise Slicer Settings<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#Use_Conditional_Formatting\" >Use Conditional Formatting<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#Conclusion\" >Conclusion<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#Frequently_Asked_Questions\" >Frequently Asked Questions<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#What_Versions_of_Excel_Support_Slicers\" >What Versions of Excel Support Slicers?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#Can_I_use_Slicers_with_Regular_Tables\" >Can I use Slicers with Regular Tables?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#How_do_I_Clear_Filters_Applied_Through_Slicers\" >How do I Clear Filters Applied Through Slicers?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 id=\"introduction\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Introduction\"><\/span><strong>Introduction<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Slicers in Excel are powerful tools that enhance data visualisation by allowing users to filter information quickly and intuitively. This guide explores what slicers are, their advantages, how to use them effectively, and much more.<\/p>\n\n\n\n<p>In the realm of <a href=\"https:\/\/pickl.ai\/blog\/different-types-of-data-analysis\/\">Data Analysis<\/a>, the ability to visualise and interact with data is crucial for making informed decisions. Excel, a widely-used spreadsheet application, offers various features to enhance data representation.&nbsp;<\/p>\n\n\n\n<p>Among these features, slicers stand out as an intuitive way to filter data in tables and <a href=\"https:\/\/pickl.ai\/blog\/learn-how-to-make-and-use-pivot-table-in-excel\/\">PivotTables.<\/a> This blog will provide a comprehensive overview of slicers, including their functionality, advantages, and practical applications.<\/p>\n\n\n\n<h2 id=\"what-are-slicers-in-excel\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_are_Slicers_in_Excel\"><\/span><strong>What are Slicers in Excel?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Slicers are visual filtering tools available in Excel that allow users to filter data in tables or PivotTables interactively. Introduced in Excel 2010, slicers provide a user-friendly interface for filtering data based on specific criteria.&nbsp;<\/p>\n\n\n\n<p>They display buttons representing different categories or values within the dataset, enabling users to click and filter the displayed information instantly.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Interactive Filtering:<\/strong> Unlike traditional filters that require multiple clicks and dropdown menus, slicers offer a straightforward way to filter data with a single click.<\/li>\n\n\n\n<li><strong>Visual Representation:<\/strong> Slicers enhance the visual appeal of reports and dashboards by providing colourful buttons that indicate the current filtering state.<\/li>\n<\/ul>\n\n\n\n<p><strong>Key Takeaways<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Slicers provide intuitive filtering options for enhanced data interaction.<\/li>\n\n\n\n<li>Customising slicers improves the visual appeal of reports and dashboards.<\/li>\n\n\n\n<li>Users can easily select multiple items for complex filtering.<\/li>\n\n\n\n<li>Slicers enhance interactivity in dashboards for better insights.<\/li>\n\n\n\n<li>Create unique slicer styles to match your report&#8217;s theme or branding.<\/li>\n<\/ul>\n\n\n\n<h2 id=\"advantages-of-using-slicers\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Advantages_of_Using_Slicers\"><\/span><strong>Advantages of Using Slicers<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXdx0JCFf7KzyE26c_NKzeIB926tOVQ3ciTBMwUh10-xMV6LoDD6TkNrK8pZgvweQCf13F8t6-7HAKoG-6mx4CDNj2z8ICM5hESctnwD5yv1WdKm16SCwOFeOVPSnbM_ciQ6Ufjn_6AUQXoTFFv-HNaeAHef?key=-uhd4kcmHhv_K6C9FnkZRQ\" alt=\"Slicers in Excel\"\/><\/figure>\n\n\n\n<p>Slicers are a powerful feature in Excel that enhance <a href=\"https:\/\/pickl.ai\/blog\/exploratory-data-analysis-through-visualization\/\">data visualisation<\/a> and interactivity, particularly when working with PivotTables and charts. Here are some key advantages of using slicers:<\/p>\n\n\n\n<h3 id=\"user-friendly-interface\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"User-Friendly_Interface\"><\/span><strong>User-Friendly Interface<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>It provides an intuitive, visual interface for filtering data. Unlike traditional filters that require navigating through dropdown menus, slicers allow users to filter data with a simple click of a button. This ease of use makes it accessible for users of all skill levels, facilitating quicker decision-making.<\/p>\n\n\n\n<h3 id=\"enhanced-visual-clarity\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Enhanced_Visual_Clarity\"><\/span><strong>Enhanced Visual Clarity<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Slicers display the current filtering state clearly, allowing users to see which filters are applied at a glance. This visual representation helps users understand the data context better and makes it easier to communicate insights to others.<\/p>\n\n\n\n<h3 id=\"multiple-selections\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Multiple_Selections\"><\/span><strong>Multiple Selections<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Users can select multiple items simultaneously by holding down the Ctrl key while clicking on slicer buttons. This feature allows for more complex filtering scenarios without the need for additional steps, making data exploration more efficient.<\/p>\n\n\n\n<h3 id=\"connection-with-multiple-pivottables\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Connection_with_Multiple_PivotTables\"><\/span><strong>Connection with Multiple PivotTables<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Slicers can be connected to multiple PivotTables or charts within the same workbook. This means that a single slicer can control the filtering of several related datasets simultaneously, saving time and ensuring consistency across analyses.<\/p>\n\n\n\n<h3 id=\"dynamic-dashboards\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Dynamic_Dashboards\"><\/span><strong>Dynamic Dashboards<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Incorporating slicers into dashboards enhances interactivity, allowing users to explore different dimensions of data dynamically. This capability enables stakeholders to gain insights tailored to their specific interests without cluttering the interface with numerous filters.<\/p>\n\n\n\n<h2 id=\"how-to-insert-slicers-in-excel\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_Insert_Slicers_in_Excel\"><\/span><strong>How to Insert Slicers in Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Slicers are a valuable tool in Excel that enhance data visualisation and interactivity, allowing users to filter data in PivotTables and regular tables easily. Here\u2019s a comprehensive guide on how to insert slicers in Excel.<\/p>\n\n\n\n<h3 id=\"step-by-step-instructions\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step-by-Step_Instructions\"><\/span><strong>Step-by-Step Instructions<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Prepare Your Data: Before inserting a slicer, ensure you have a table or PivotTable ready. If you\u2019re using a regular dataset, convert it into a table by selecting any cell within the data range and pressing Ctrl + T, or go to the Insert tab and select Table.<\/p>\n\n\n\n<p><strong>Step 1: Select Your Table or PivotTable:<\/strong> Start by clicking anywhere inside the table or PivotTable where you&#8217;d like to add a slicer. This sets the location for the slicer placement.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Access the Insert Tab:<\/li>\n\n\n\n<li>For PivotTables: Go to the PivotTable Analyze tab (or Options tab in older versions).<\/li>\n\n\n\n<li>For Regular Tables: Navigate to the Insert tab on the Ribbon.<\/li>\n<\/ul>\n\n\n\n<p><strong>Step 2: Insert Slicer:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on the Insert Slicer button.<\/li>\n\n\n\n<li>A dialog box will appear, displaying available fields for slicing.<\/li>\n<\/ul>\n\n\n\n<p><strong>Step 3: Choose Fields for Slicing: <\/strong>Begin by selecting the fields you want for your slicers. Check their boxes in the dialog box, and then click OK to apply your choices.<\/p>\n\n\n\n<p><strong>Step 4: Position Your Slicer: <\/strong>The slicer will be inserted into your worksheet. You can move and resize it as needed.<\/p>\n\n\n\n<h3 id=\"alternative-methods\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Alternative_Methods\"><\/span><strong>Alternative Methods<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>Right-Click Method for PivotTables:<\/strong> If you prefer a quicker method, right-click on any field in the PivotTable field list and select \u201cAdd as Slicer.\u201d This method is particularly effective when dealing with many fields, as it allows for quick access without navigating through tabs.<\/p>\n\n\n\n<p><strong>Multiple Slicers at Once: <\/strong>In the dialog box that appears when you click on Insert Slicer, you can select multiple fields simultaneously by checking their boxes before clicking OK. This allows you to add several slicers at once for more complex filtering options.<\/p>\n\n\n\n<p><strong>Read More: <\/strong><a href=\"https:\/\/pickl.ai\/blog\/insert-checkbox-in-excel\/\"><strong>Let\u2019s Check How You Can Insert a Checkbox in Excel<\/strong><\/a><\/p>\n\n\n\n<h2 id=\"how-to-use-slicers-to-filter-data\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_Use_Slicers_to_Filter_Data\"><\/span><strong>How to Use Slicers to Filter Data<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Slicers in Excel are intuitive tools that allow users to filter data in PivotTables and regular tables quickly. They enhance the user experience by providing a visual way to interact with data, making it easier to analyse and present information. Here\u2019s a step-by-step guide on how to use slicers effectively for filtering data.<\/p>\n\n\n\n<p><strong>Step 1: Select Your Table or PivotTable:<\/strong><\/p>\n\n\n\n<p>Click anywhere inside the table or PivotTable that you want to filter using a slicer.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Insert the Slicer.<\/li>\n\n\n\n<li><strong>For PivotTables:<\/strong> Go to the PivotTable Analyze tab on the Ribbon. In the Filter group, click on Insert Slicer.<\/li>\n\n\n\n<li><strong>For Regular Tables: <\/strong>Navigate to the Insert tab, and in the Filters group, click on Slicer.<\/li>\n<\/ul>\n\n\n\n<p><strong>Step 2: Choose Fields for Slicing<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A dialog box will appear displaying available fields from your dataset.<\/li>\n\n\n\n<li>Check the boxes next to the fields you want to create slicers for (e.g., &#8220;Country,&#8221; &#8220;Product&#8221;) and click OK.<\/li>\n<\/ul>\n\n\n\n<p><strong>Step 3: Position Your Slicer<\/strong><\/p>\n\n\n\n<p>The slicer(s) will be inserted into your worksheet. You can drag them to reposition or resize them as needed.<\/p>\n\n\n\n<p><strong>Step 4: Using the Slicer to Filter Data<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on any button within the slicer to filter your data based on that selection. For example, clicking &#8220;United States&#8221; will filter the PivotTable or table to show only data related to the United States.<\/li>\n\n\n\n<li>To select multiple items, hold down the Ctrl key while clicking on additional buttons within the slicer. Alternatively, you can use the Multi-Select button (if available) on the slicer.<\/li>\n<\/ul>\n\n\n\n<p><strong>Step 5: Clear Filters<\/strong><\/p>\n\n\n\n<p>To remove filters applied through a slicer, click the clear filter button (often represented by an icon with a crossed-out funnel) located at the top right corner of the slicer.<\/p>\n\n\n\n<p><strong>Step 6: Connecting Multiple Slicers<\/strong><\/p>\n\n\n\n<p>If you have multiple PivotTables that you want to filter simultaneously:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select one of your slicers.<\/li>\n\n\n\n<li>Go to the Slicer Tools Options tab and click on Report Connections (or PivotTable Connections) depending on your version.<\/li>\n\n\n\n<li>Check all PivotTables you want this slicer connected to and click OK.<\/li>\n<\/ul>\n\n\n\n<h4 id=\"example-scenario\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Example_Scenario\"><\/span><strong>Example Scenario<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Imagine you have sales data for different products across various countries stored in a PivotTable. By using slicers, you can quickly filter this data:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Insert a slicer for &#8220;Country&#8221; and another for &#8220;Product.&#8221;<\/li>\n\n\n\n<li>Click on &#8220;Canada&#8221; in the Country slicer; your PivotTable updates to show sales data only for Canada.<\/li>\n\n\n\n<li>Hold down Ctrl and select both &#8220;Apples&#8221; and &#8220;Oranges&#8221; in the Product slicer; now your PivotTable reflects sales for those two products in Canada.<\/li>\n<\/ul>\n\n\n\n<h2 id=\"customising-slicers\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Customising_Slicers\"><\/span><strong>Customising Slicers<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Slicers are a powerful tool in Excel that enhance<a href=\"https:\/\/pickl.ai\/blog\/types-of-data-visualization\/\"> data visualisation <\/a>and interactivity. Customising slicers allows you to tailor their appearance and functionality to better suit your needs and improve the overall look of your reports. Here\u2019s a comprehensive guide on how to customise slicers effectively.<\/p>\n\n\n\n<h3 id=\"change-slicer-style\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Change_Slicer_Style\"><\/span><strong>Change Slicer Style<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Excel provides several built-in styles for slicers, but you can easily change the style to match your report&#8217;s theme or personal preferences.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Select Your Slicer<\/strong>: Click on the slicer you want to customise.<\/li>\n\n\n\n<li><strong>Access Slicer Tools<\/strong>: Go to the <strong>Slicer Tools Options<\/strong> tab that appears on the Ribbon.<\/li>\n\n\n\n<li><strong>Choose a New Style<\/strong>: In the <strong>Slicer Styles<\/strong> group, click on the thumbnail of the style you want to apply. If you want to see more options, click the <strong>More<\/strong> button (downward arrow) to view additional styles.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"create-a-custom-slicer-style\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Create_a_Custom_Slicer_Style\"><\/span><strong>Create a Custom Slicer Style<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>If none of the default styles meet your needs, you can create your own custom slicer style:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Select Your Slicer<\/strong>: Click on the slicer.<\/li>\n\n\n\n<li><strong>Go to Slicer Tools Options<\/strong>: In the Ribbon, navigate to the <strong>Slicer Tools Options<\/strong> tab.<\/li>\n\n\n\n<li><strong>Create New Style<\/strong>: Click on the <strong>More<\/strong> button and select <strong>New Slicer Style<\/strong> at the bottom of the gallery.<\/li>\n\n\n\n<li><strong>Name Your Style<\/strong>: Give your new style a name.<\/li>\n\n\n\n<li><strong>Format Elements<\/strong>: Select different slicer elements (e.g., Header, Selected Items, Unselected Items) and click on the <strong>Format<\/strong> button to customise their appearance (font, colour, border, etc.).<\/li>\n\n\n\n<li><strong>Finish and Apply<\/strong>: Click <strong>OK<\/strong> when done. Your new style will now appear in the Slicer Styles gallery for future use.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"resize-and-position-slicers\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Resize_and_Position_Slicers\"><\/span><strong>Resize and Position Slicers<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Adjusting the size and position of slicers can improve layout and usability:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Resize<\/strong>: Click on the edges of the slicer and drag to resize it. Alternatively, select the slicer, go to the <strong>Slicer Tools Options<\/strong> tab, and set specific height and width values.<\/li>\n\n\n\n<li><strong>Lock Position<\/strong>: To prevent a slicer from moving when cells are added or deleted, right-click on the slicer, select <strong>Size and Properties<\/strong>, and check the box for &#8220;Don&#8217;t move or size with cells.&#8221;<\/li>\n<\/ul>\n\n\n\n<h3 id=\"change-button-layout\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Change_Button_Layout\"><\/span><strong>Change Button Layout<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>If you have many items in a slicer, changing its layout can enhance usability:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Select Your Slicer<\/strong>: Click on it to activate it.<\/li>\n\n\n\n<li><strong>Adjust Columns<\/strong>: Go to the <strong>Slicer Tools Options<\/strong> tab, find the <strong>Buttons<\/strong> group, and enter a number in the <strong>Columns<\/strong> box to display items in multiple columns. This is particularly useful for long lists.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"customise-slicer-settings\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Customise_Slicer_Settings\"><\/span><strong>Customise Slicer Settings<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>You can further refine how your slicer behaves:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Right-click on the Slicer<\/strong>: Choose <strong>Slicer Settings\u2026<\/strong><\/li>\n\n\n\n<li>In this dialog box, you can:\n<ul class=\"wp-block-list\">\n<li>Hide or show the header by checking or unchecking &#8220;Display header.&#8221;<\/li>\n\n\n\n<li>Sort items in ascending or descending order.<\/li>\n\n\n\n<li>Hide items with no data by unchecking &#8220;Hide items with no data.&#8221;<\/li>\n\n\n\n<li>Hide items deleted from the data source by adjusting relevant options.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 id=\"use-conditional-formatting\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Use_Conditional_Formatting\"><\/span><strong>Use Conditional Formatting<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>While Excel does not directly support conditional formatting for slicers, you can create visual cues by customising styles based on selection states:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Change colours or styles of selected\/unselected items by modifying your custom slicer styles accordingly. This helps users quickly identify which filters are active.<\/li>\n<\/ul>\n\n\n\n<h2 id=\"conclusion\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><strong>Conclusion<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Slicers in Excel are invaluable tools for enhancing data visualisation and interactivity within reports and dashboards. By providing an intuitive way to filter information quickly, they empower users to explore datasets dynamically and gain insights effortlessly. Whether working with PivotTables or regular tables, incorporating slicers into your workflow can significantly improve your analytical capabilities.<\/p>\n\n\n\n<h2 id=\"frequently-asked-questions\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions\"><\/span><strong>Frequently Asked Questions<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 id=\"what-versions-of-excel-support-slicers\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_Versions_of_Excel_Support_Slicers\"><\/span><strong>What Versions of Excel Support Slicers?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Slicers are available starting from Excel 2010 onwards for both Windows and Mac versions.<\/p>\n\n\n\n<h3 id=\"can-i-use-slicers-with-regular-tables\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Can_I_use_Slicers_with_Regular_Tables\"><\/span><strong>Can I use Slicers with Regular Tables?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Yes! You can insert slicers into regular tables; they will act as visual filters similar to auto-filters.<\/p>\n\n\n\n<h3 id=\"how-do-i-clear-filters-applied-through-slicers\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_do_I_Clear_Filters_Applied_Through_Slicers\"><\/span><strong>How do I Clear Filters Applied Through Slicers?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>To clear filters from a slicer, click on the clear filter button located at the top right corner of the selected slicer button set.<\/p>\n","protected":false},"excerpt":{"rendered":" Enhance Excel slicers&#8217; functionality and appearance for improved data visualisation and user interaction.\n","protected":false},"author":30,"featured_media":15361,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2318],"tags":[1401,2162,2115,25,3349,3372,3371],"ppma_author":[2221,2183],"class_list":{"0":"post-15358","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel","8":"tag-artificial-intelligence","9":"tag-data-science","10":"tag-excel","11":"tag-machine-learning","12":"tag-ms-excel","13":"tag-slicers","14":"tag-slicers-in-excel"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Excel Slicers: Easy Data Filtering and Visualization<\/title>\n<meta name=\"description\" content=\"Customize Excel slicers for better functionality and style. Enhance data visualization with tailored layouts and aesthetics for a seamless experience.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Slicers in Excel: A Guide to Enhancing Data Visualisation\" \/>\n<meta property=\"og:description\" content=\"Customize Excel slicers for better functionality and style. Enhance data visualization with tailored layouts and aesthetics for a seamless experience.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Pickl.AI\" \/>\n<meta property=\"article:published_time\" content=\"2024-10-29T09:32:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-29T09:32:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/10\/Slicers-In-Excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Karan Sharma, Nitin Choudhary\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Karan Sharma\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/slicers-in-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/slicers-in-excel\\\/\"},\"author\":{\"name\":\"Karan Sharma\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/de08f3d5a7022f852ddba0423c717695\"},\"headline\":\"Slicers in Excel: A Guide to Enhancing Data Visualisation\",\"datePublished\":\"2024-10-29T09:32:18+00:00\",\"dateModified\":\"2024-10-29T09:32:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/slicers-in-excel\\\/\"},\"wordCount\":1925,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/slicers-in-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Slicers-In-Excel.jpg\",\"keywords\":[\"Artificial intelligence\",\"Data science\",\"excel\",\"Machine Learning\",\"MS Excel\",\"Slicers\",\"Slicers In Excel\"],\"articleSection\":[\"Excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/slicers-in-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/slicers-in-excel\\\/\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/slicers-in-excel\\\/\",\"name\":\"Excel Slicers: Easy Data Filtering and Visualization\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/slicers-in-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/slicers-in-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Slicers-In-Excel.jpg\",\"datePublished\":\"2024-10-29T09:32:18+00:00\",\"dateModified\":\"2024-10-29T09:32:20+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/de08f3d5a7022f852ddba0423c717695\"},\"description\":\"Customize Excel slicers for better functionality and style. Enhance data visualization with tailored layouts and aesthetics for a seamless experience.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/slicers-in-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/slicers-in-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/slicers-in-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Slicers-In-Excel.jpg\",\"contentUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Slicers-In-Excel.jpg\",\"width\":1200,\"height\":628,\"caption\":\"Slicers In Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/slicers-in-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/category\\\/excel\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Slicers in Excel: A Guide to Enhancing Data Visualisation\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\",\"name\":\"Pickl.AI\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/de08f3d5a7022f852ddba0423c717695\",\"name\":\"Karan Sharma\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/avatar_user_30_1723028625-96x96.jpgaf8d83d4b00a2c2c3f17630ff793e43f\",\"url\":\"https:\\\/\\\/pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/avatar_user_30_1723028625-96x96.jpg\",\"contentUrl\":\"https:\\\/\\\/pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/avatar_user_30_1723028625-96x96.jpg\",\"caption\":\"Karan Sharma\"},\"description\":\"With more than six years of experience in the field, Karan Sharma is an accomplished data scientist. He keeps a vigilant eye on the major trends in Big Data, Data Science, Programming, and AI, staying well-informed and updated in these dynamic industries.\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/author\\\/karansharma\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Excel Slicers: Easy Data Filtering and Visualization","description":"Customize Excel slicers for better functionality and style. Enhance data visualization with tailored layouts and aesthetics for a seamless experience.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"Slicers in Excel: A Guide to Enhancing Data Visualisation","og_description":"Customize Excel slicers for better functionality and style. Enhance data visualization with tailored layouts and aesthetics for a seamless experience.","og_url":"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/","og_site_name":"Pickl.AI","article_published_time":"2024-10-29T09:32:18+00:00","article_modified_time":"2024-10-29T09:32:20+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/10\/Slicers-In-Excel.jpg","type":"image\/jpeg"}],"author":"Karan Sharma, Nitin Choudhary","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Karan Sharma","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/"},"author":{"name":"Karan Sharma","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/de08f3d5a7022f852ddba0423c717695"},"headline":"Slicers in Excel: A Guide to Enhancing Data Visualisation","datePublished":"2024-10-29T09:32:18+00:00","dateModified":"2024-10-29T09:32:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/"},"wordCount":1925,"commentCount":0,"image":{"@id":"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/10\/Slicers-In-Excel.jpg","keywords":["Artificial intelligence","Data science","excel","Machine Learning","MS Excel","Slicers","Slicers In Excel"],"articleSection":["Excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/","url":"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/","name":"Excel Slicers: Easy Data Filtering and Visualization","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/10\/Slicers-In-Excel.jpg","datePublished":"2024-10-29T09:32:18+00:00","dateModified":"2024-10-29T09:32:20+00:00","author":{"@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/de08f3d5a7022f852ddba0423c717695"},"description":"Customize Excel slicers for better functionality and style. Enhance data visualization with tailored layouts and aesthetics for a seamless experience.","breadcrumb":{"@id":"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#primaryimage","url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/10\/Slicers-In-Excel.jpg","contentUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/10\/Slicers-In-Excel.jpg","width":1200,"height":628,"caption":"Slicers In Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.pickl.ai\/blog\/slicers-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pickl.ai\/blog\/"},{"@type":"ListItem","position":2,"name":"Excel","item":"https:\/\/www.pickl.ai\/blog\/category\/excel\/"},{"@type":"ListItem","position":3,"name":"Slicers in Excel: A Guide to Enhancing Data Visualisation"}]},{"@type":"WebSite","@id":"https:\/\/www.pickl.ai\/blog\/#website","url":"https:\/\/www.pickl.ai\/blog\/","name":"Pickl.AI","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pickl.ai\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/de08f3d5a7022f852ddba0423c717695","name":"Karan Sharma","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/08\/avatar_user_30_1723028625-96x96.jpgaf8d83d4b00a2c2c3f17630ff793e43f","url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/08\/avatar_user_30_1723028625-96x96.jpg","contentUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/08\/avatar_user_30_1723028625-96x96.jpg","caption":"Karan Sharma"},"description":"With more than six years of experience in the field, Karan Sharma is an accomplished data scientist. He keeps a vigilant eye on the major trends in Big Data, Data Science, Programming, and AI, staying well-informed and updated in these dynamic industries.","url":"https:\/\/www.pickl.ai\/blog\/author\/karansharma\/"}]}},"jetpack_featured_media_url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/10\/Slicers-In-Excel.jpg","authors":[{"term_id":2221,"user_id":30,"is_guest":0,"slug":"karansharma","display_name":"Karan Sharma","avatar_url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/08\/avatar_user_30_1723028625-96x96.jpg","first_name":"Karan","user_url":"","last_name":"Sharma","description":"With more than six years of experience in the field, Karan Sharma is an accomplished data scientist. He keeps a vigilant eye on the major trends in Big Data, Data Science, Programming, and AI, staying well-informed and updated in these dynamic industries."},{"term_id":2183,"user_id":18,"is_guest":0,"slug":"nitin-choudhary","display_name":"Nitin Choudhary","avatar_url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/10\/avatar_user_18_1697616749-96x96.jpeg","first_name":"Nitin","user_url":"","last_name":"Choudhary","description":"I've been playing with data for a while now, and it's been pretty cool! I like turning all those numbers into pictures that tell stories. When I'm not doing that, I love running, meeting new people, and reading books. Running makes me feel great, meeting people is fun, and books are like my new favourite thing. It's not just about data; it's also about being active, making friends, and enjoying good stories. Come along and see how awesome the world of data can be!"}],"_links":{"self":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/15358","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/users\/30"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/comments?post=15358"}],"version-history":[{"count":2,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/15358\/revisions"}],"predecessor-version":[{"id":15360,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/15358\/revisions\/15360"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/media\/15361"}],"wp:attachment":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/media?parent=15358"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/categories?post=15358"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/tags?post=15358"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/ppma_author?post=15358"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}