{"id":11183,"date":"2019-02-12T12:12:05","date_gmt":"2019-02-12T11:12:05","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=11183"},"modified":"2024-02-06T15:47:42","modified_gmt":"2024-02-06T14:47:42","slug":"expand-and-collapse-fields-in-pivot-chart-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/expand-and-collapse-fields-in-pivot-chart-in-excel\/","title":{"rendered":"Expand and Collapse Fields in Pivot Chart in Excel"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/pivot-charts\/\" target=\"_blank\">Pivot Charts<\/a> are really cool to use, as it gives you a great visual representation of your Pivot Table data. Did you know that you can actually <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/expand-and-collapse-buttons\/\" target=\"_blank\" rel=\"noopener\">Expand and Collapse Fields in<\/a> your Pivot Chart? So that you can control the amount of detail to show in your Chart?<\/p>\n<p>This is our source data.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Expand and Collapse Fields in Pivot Chart in Excel\"  class=\"aligncenter size-full wp-image-11187\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-00.png\" alt=\"Expand and Collapse Fields in Pivot Chart in Excel\" width=\"703\" height=\"314\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-00.png 703w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-00-300x134.png 300w\" sizes=\"(max-width: 703px) 100vw, 703px\" \/><\/p>\n<p>This is our <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Table\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a> and Pivot Chart.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Expand and Collapse Fields in Pivot Chart in Excel\"  class=\"aligncenter size-full wp-image-11188\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-01.png\" alt=\"Expand and Collapse Fields in Pivot Chart in Excel\" width=\"912\" height=\"330\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-01.png 912w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-01-300x109.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-01-768x278.png 768w\" sizes=\"(max-width: 912px) 100vw, 912px\" \/><\/p>\n<p>It is very simple to do so and we will show you how!<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/hVqVNrpUl4s?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart.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\">Expand-and-Collapse-fields-in-Pivot-Chart.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span>\u00a0To expand your field, right click on a part of the chart, and go to <em><strong>Expand\/Collapse &gt; Expand Entire Field<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Expand and Collapse Fields in Pivot Chart in Excel\"  class=\"aligncenter size-full wp-image-11189\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-02.png\" alt=\"Expand and Collapse Fields in Pivot Chart in Excel\" width=\"1042\" height=\"428\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-02.png 1042w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-02-300x123.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-02-1024x421.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-02-768x315.png 768w\" sizes=\"(max-width: 1042px) 100vw, 1042px\" \/><\/p>\n<p>With just that, your Pivot Chart has now expanded to the Sales Figures per Customer!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Expand and Collapse Fields in Pivot Chart in Excel\"  class=\"aligncenter size-full wp-image-11190\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-03.png\" alt=\"Expand and Collapse Fields in Pivot Chart in Excel\" width=\"909\" height=\"328\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-03.png 909w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-03-300x108.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-03-768x277.png 768w\" sizes=\"(max-width: 909px) 100vw, 909px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> \u00a0Now let us collapse this back, right click on a part of the chart, and go to <em><strong>Expand\/Collapse &gt; Collapse Entire Field<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Expand and Collapse Fields in Pivot Chart in Excel\"  class=\"aligncenter size-full wp-image-11191\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-04.png\" alt=\"Expand and Collapse Fields in Pivot Chart in Excel\" width=\"1077\" height=\"416\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-04.png 1077w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-04-300x116.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-04-1024x396.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-04-768x297.png 768w\" sizes=\"(max-width: 1077px) 100vw, 1077px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Now your Pivot Chart has gone back to showing the Sales Figures by Region!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Expand and Collapse Fields in Pivot Chart in Excel\"  class=\"aligncenter size-full wp-image-11192\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-05.png\" alt=\"Expand and Collapse Fields in Pivot Chart in Excel\" width=\"917\" height=\"322\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-05.png 917w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-05-300x105.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/02\/Expand-and-Collapse-fields-in-Pivot-Chart-05-768x270.png 768w\" sizes=\"(max-width: 917px) 100vw, 917px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff;\"><b>How to Expand and Collapse Fields in Pivot Charts in Excel<\/b><\/span><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pivot Charts are really cool to use, as it gives you a great visual representation of your Pivot Table data. Did you know that you can actually Expand and Collapse Fields in your Pivot Chart? So that you can control the amount of detail to show in your Chart? This is our source data. This [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17740,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Expand and Collapse Fields in Pivot Chart in Excel","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[4,24],"tags":[586,585,459,139],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/11183"}],"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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=11183"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/11183\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17740"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=11183"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=11183"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=11183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}