{"id":51904,"date":"2017-10-18T21:05:54","date_gmt":"2017-10-18T20:05:54","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=51904"},"modified":"2017-10-18T21:05:54","modified_gmt":"2017-10-18T20:05:54","slug":"percentages-bij-gecumuleerde-kolomgrafiek","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/percentages-bij-gecumuleerde-kolomgrafiek\/","title":{"rendered":"Percentages bij gecumuleerde kolomgrafiek"},"content":{"rendered":"<p>V. Kan ik procentuele waarden zetten bij een 100 %-gecumuleerde grafiek in Excel?<\/p>\n<p>A. Neen &#8211; als je gegevenslabels toevoegt, geeft Excel de waarden.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51908\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/pctbijgecumuleerde-300x112.png\" alt=\"\" width=\"300\" height=\"112\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/pctbijgecumuleerde-300x112.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/pctbijgecumuleerde-768x286.png 768w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/pctbijgecumuleerde.png 904w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>Wat je wel kan doen, is het procentueel aandeel van elk deeltje berekenen<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51906\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/pctbijgecumuleerde2-138x300.png\" alt=\"\" width=\"138\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/pctbijgecumuleerde2-138x300.png 138w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/pctbijgecumuleerde2.png 258w\" sizes=\"auto, (max-width: 138px) 100vw, 138px\" \/><\/p>\n<p>en daar een grafiek van maken.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51907\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/pctbijgecumuleerde3-300x131.png\" alt=\"\" width=\"300\" height=\"131\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/pctbijgecumuleerde3-300x131.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/pctbijgecumuleerde3-768x335.png 768w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/pctbijgecumuleerde3.png 779w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>Lastig? bekijk mijn <a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/pct-bij-cumulatieve-grafiek.xlsx\">voorbeeld<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Kan ik procentuele waarden zetten bij een 100 %-gecumuleerde grafiek in Excel? A. Neen &#8211; als je gegevenslabels toevoegt, geeft Excel de waarden. Wat je wel kan doen, is het procentueel aandeel van elk deeltje berekenen en daar een grafiek van maken. Lastig? bekijk mijn voorbeeld<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":20,"footnotes":""},"categories":[464,54,366,79,10],"tags":[],"class_list":["post-51904","post","type-post","status-publish","format-standard","hentry","category-ebp","category-excel","category-grafieken","category-odisee","category-office"],"publishpress_future_action":{"enabled":false,"date":"2026-05-01 06:20:58","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/51904","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=51904"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/51904\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=51904"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=51904"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=51904"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}