{"id":304,"date":"2014-09-25T00:15:54","date_gmt":"2014-09-24T22:15:54","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=304"},"modified":"2024-06-12T20:26:50","modified_gmt":"2024-06-12T18:26:50","slug":"pivot-charts-slicers","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/pivot-charts-slicers\/","title":{"rendered":"Pivot Charts &#038; Slicers"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/pivot-charts-slicers\/#Pivot_Charts_Slicers\" title=\"Pivot Charts &amp; Slicers\">Pivot Charts &amp; Slicers<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Pivot_Charts_Slicers\"><\/span>Pivot Charts &amp; Slicers<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In a previous post I showed you how to <span style=\"color: #0000ff;\"><strong><a title=\"Insert a Pivot Chart\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/insert-a-pivot-chart\/\" target=\"_blank\" rel=\"noopener noreferrer\"><span style=\"color: #0000ff;\">Insert a Pivot Chart<\/span><\/a><\/strong><\/span>.\u00a0 Now we will take this concept once step further and insert a Slicer.\u00a0 The cool thing about this is that the Slicer will control both the <a class=\"wpil_keyword_link\" title=\"Pivot Table\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a> and the Pivot Chart.<\/p>\n<p>See how you can start creating some awesome interactive analytical reports in just a couple of steps.<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Pivot-Charts-Slicers.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Pivot-Charts-Slicers.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Pivot-Charts-Slicers.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p>Here we have our Pivot Table and Pivot Chart ready:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/16-Pivot-chart-slicers-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6806\" title=\"Pivot Charts &amp; Slicers\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/16-Pivot-chart-slicers-01.jpg\" alt=\"Pivot Charts &amp; Slicers\" width=\"615\" height=\"487\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/16-Pivot-chart-slicers-01.jpg 615w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/16-Pivot-chart-slicers-01-300x238.jpg 300w\" sizes=\"(max-width: 615px) 100vw, 615px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong>\u00a0<\/span>Click in\u00a0your Pivot Table\u00a0and go to\u00a0<em><strong>Options &gt; Insert Slicer<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/16-Pivot-chart-slicers-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6807\" title=\"Pivot Charts &amp; Slicers\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/16-Pivot-chart-slicers-02.jpg\" alt=\"Pivot Charts &amp; Slicers\" width=\"631\" height=\"133\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/16-Pivot-chart-slicers-02.jpg 631w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/16-Pivot-chart-slicers-02-300x63.jpg 300w\" sizes=\"(max-width: 631px) 100vw, 631px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong>\u00a0<\/span>Select\u00a0<strong>Region\u00a0<\/strong>and\u00a0<strong>Year.\u00a0<\/strong>Click\u00a0<strong>OK<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/16-Pivot-chart-slicers-03.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6808\" title=\"Pivot Charts &amp; Slicers\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/16-Pivot-chart-slicers-03.jpg\" alt=\"Pivot Charts &amp; Slicers\" width=\"260\" height=\"459\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/16-Pivot-chart-slicers-03.jpg 260w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/16-Pivot-chart-slicers-03-170x300.jpg 170w\" sizes=\"(max-width: 260px) 100vw, 260px\" \/><\/a><\/p>\n<p>You now have your Slicer and you can play around with it! It will affect both the Pivot Table and Pivot Chart!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/16-Pivot-chart-slicers-04.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6809\" title=\"Pivot Charts &amp; Slicers\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/16-Pivot-chart-slicers-04.jpg\" alt=\"Pivot Charts &amp; Slicers\" width=\"857\" height=\"545\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/16-Pivot-chart-slicers-04.jpg 857w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/16-Pivot-chart-slicers-04-300x191.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/16-Pivot-chart-slicers-04-768x488.jpg 768w\" sizes=\"(max-width: 857px) 100vw, 857px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pivot Charts &amp; Slicers In a previous post I showed you how to Insert a Pivot Chart.\u00a0 Now we will take this concept once step further and insert a Slicer.\u00a0 The cool thing about this is that the Slicer will control both the Pivot Table and the Pivot Chart. See how you can start creating [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17373,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Pivot Charts & Slicers","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[24,4],"tags":[93,86,92],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/304"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=304"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/304\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17373"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=304"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=304"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=304"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}