{"id":4661,"date":"2016-04-02T13:27:48","date_gmt":"2016-04-02T11:27:48","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=4661"},"modified":"2020-09-04T09:36:50","modified_gmt":"2020-09-04T07:36:50","slug":"48-videonavod-jak-na-kontingencky-kontingencni-graf","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/48-videonavod-jak-na-kontingencky-kontingencni-graf\/","title":{"rendered":"48. Videotutorial &#8211; Deal with Pivot Tables 8 &#8211; Pivot chart"},"content":{"rendered":"<p><\/p>\n<p style=\"text-align: justify;\">Another episode of tutorials\u00a0<a href=\"https:\/\/www.itlektor.cz\/en\/pivot-tables\/\">Deal with Pivot Tables<\/a>\u00a0continues with the creation and capabilities of <strong>PivotChart<\/strong>. You&#8217;ll learn a few handy tricks\u00a0and you will see a pie chart of pie.\u00a0\u00a0If this guide has helped you, become a fan on <a href=\"http:\/\/www.facebook.com\/itlektorcz\" target=\"_blank\" rel=\"noopener\">Facebook<\/a> and recommend this site to your friends, it\u00a0can be useful for them too.<\/p>\n<p style=\"text-align: justify;\"><em>Please note that this tutorial is presented in czech language, with english subtitles.<\/em><\/p>\n<div class=\"potter-video\"><iframe width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/7IzMa5dIq_U?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/div>\n<p>Source file can be downloaded\u00a0<a href=\"https:\/\/www.itlektor.cz\/soubory\/kontingencky\/cesty.xlsx\">here<\/a>.<\/p>\n<p style=\"text-align: justify;\">Major options of Pivot Tables, we have already demonstrated in the previous seven parts, now we will try to make a Pivot chart. To visualize data from a Pivot table just use the option on the Analysis tab &gt; PivotChart, or faster pressing ALT + F1.<\/p>\n<p style=\"text-align: justify;\">Usual basic chart differs mainly in that it is created from the Pivot table, and they are still connected. Whenever you make adjustments in the Pivot table, it will also affect the chart and vice versa. In the Pivot chart we have a filter buttons and all four sections of fields. To hide the buttons e.g. because of printing use the Analyze tab and disable the Field buttons.<\/p>\n<p style=\"text-align: justify;\">On the Design tab now change the chart type to pie and pick a nice style. Activate value labels \u200b\u200bfor each of the sectors, and change the view to percent.<\/p>\n<p style=\"text-align: justify;\">I change the type of chart again, this time on a Pie of pie. Right mouse click on one of the slices, choose Format Data Point. Set the pie so that the series is divided according to the percentage values \u200b\u200band set values \u200b\u200bless than 10%.<\/p>\n<p style=\"text-align: justify;\">We change the title of the chart to Comparison of travel expenditures, legend placed below the chart, change the color settings, move it close to table and change chart the size.<\/p>\n<p style=\"text-align: justify;\">Besides the chart we put Slicer, introduced in previous episode, click the Analyze tab, and select Insert Slicer, select Country field for simple filtering. After selecting some countries, we see that changes the chart and pivot table.<\/p>\n<p style=\"text-align: justify;\">If we want to delete a chart, select it over the edge and press the Delete key.<\/p>\n<p style=\"text-align: justify;\">Next time we will look for a way to merge multiple tables into a single pivot, so be sure to watch.<\/p>\n<p><\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>Another episode of tutorials\u00a0Deal with Pivot Tables\u00a0continues with the creation and capabilities of PivotChart. You&#8217;ll learn a few handy tricks\u00a0and you will see a pie chart of pie.\u00a0\u00a0If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it\u00a0can be useful for them too. Please note that this [&hellip;]<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":4662,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[3,56],"tags":[10,70,58,50],"_links":{"self":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/4661"}],"collection":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/comments?post=4661"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/4661\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media\/4662"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=4661"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=4661"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=4661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}