{"id":541,"date":"2019-04-16T18:17:36","date_gmt":"2019-04-16T15:17:36","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=541"},"modified":"2019-05-06T12:48:26","modified_gmt":"2019-05-06T09:48:26","slug":"creating-pivot-charts-in-excel","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/creating-pivot-charts-in-excel\/","title":{"rendered":"Creating Pivot Charts in Excel"},"content":{"rendered":"\n<p>Pivot charts in Excel are the visual representation of <strong><a href=\"https:\/\/www.test4u.eu\/excelpedia\/learning-about-pivot-tables\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"pivot tables (opens in a new tab)\">pivot tables<\/a><\/strong>. They are connected to each other and every change on the table affects the chart and vice versa.<\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe class=\"youtube-player\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/0Acsmckgnfg?version=3&#038;rel=0&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=en-US&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span>\n<\/div><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-large-font-size\"><strong>Practice File:<\/strong><\/p>\n\n\n\n<div class=\"wp-block-file\"><a href=\"https:\/\/www.test4u.eu\/excelpedia\/wp-content\/uploads\/2019\/04\/pivot-charts.xlsx\">pivot charts<\/a><a href=\"https:\/\/www.test4u.eu\/excelpedia\/wp-content\/uploads\/2019\/04\/pivot-charts.xlsx\" class=\"wp-block-file__button\" download>Download<\/a><\/div>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-medium-font-size\"><strong>Transcript<\/strong><\/p>\n\n\n\n<p>They have all the\nbasic functionality of a standard excel chart plus some extra features.<\/p>\n\n\n\n<p>There are two ways to\ncreate a Pivot chart. The first is to create a Pivot Table and then Insert a\nPivot chart based on that table, and the other is to insert them together. To\naccess both ways we have to click on the insert tab of the ribbon and from the\npivot Chart dropdown menu select one or the other.<\/p>\n\n\n\n<p>We select to insert\nboth to save us some time. <\/p>\n\n\n\n<p>We either choose a\ncell to insert them or insert them into a new sheet.<\/p>\n\n\n\n<p>Then we set the\nProduct field as column, the Salesman as Row and the Sum of quantity as values.<\/p>\n\n\n\n<p>If we have the chart\nselected instead of columns and rows we drag the fields to the Legend and\nCategory areas respectively.<\/p>\n\n\n\n<p>The visual differences\nfrom a regular chart are these 3 grayed fields on the chart. We can use the\nProduct and Salesman fields to filter the results of the pivot table and the\nchart, and the sum of Quantity field to change its properties.<\/p>\n\n\n\n<p>For example, let\u2019s\nchange the value field to depict the count of sales instead of the sum. We\nright click on the field and select properties and then count.<\/p>\n\n\n\n<p>Both the chart and the\ntable have changed to reflect our new setting.<\/p>\n\n\n\n<p>Let\u2019s filter the chart\nnow to not show Mr. Simpson and the sales for shirts.<\/p>\n\n\n\n<p>Again the chart and\nthe table change together. The same filters can be applied to the table and be\ndepicted on the chart instantly. Let\u2019s return our chart to its original state\nusing the pivot table filters and options.<\/p>\n\n\n\n<p>First remove the\nfilters. And then change back to showing the sum instead of the count of\nquantities.<\/p>\n\n\n\n<p>Every functionality that exists on a regular chart is present here as well. We can change the type of the chart, the style, the colors and pretty much anything we like on the design of the chart. <\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Pivot charts in Excel are the visual representation of pivot tables. They are connected to each other and every change on the table affects the chart and vice versa.<\/p>\n","protected":false},"author":2,"featured_media":542,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[3],"tags":[38,41,11,37],"class_list":["post-541","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-analysis","tag-charts","tag-data","tag-pivot-tables"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.test4u.eu\/excelpedia\/wp-content\/uploads\/2019\/04\/pivotcharts.jpg","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paRnIz-8J","_links":{"self":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts\/541","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/comments?post=541"}],"version-history":[{"count":0,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts\/541\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/media\/542"}],"wp:attachment":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/media?parent=541"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/categories?post=541"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/tags?post=541"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}