{"id":53646,"date":"2018-12-14T12:56:46","date_gmt":"2018-12-14T11:56:46","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/?p=53646"},"modified":"2019-11-22T12:35:35","modified_gmt":"2019-11-22T11:35:35","slug":"metingen-gegroepeerd-analyseren-en-uitzetten-in-een-grafiek","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/metingen-gegroepeerd-analyseren-en-uitzetten-in-een-grafiek\/","title":{"rendered":"Metingen gegroepeerd analyseren en uitzetten in een grafiek"},"content":{"rendered":"<p>V. Hoe kan ik metingen gegroepeerd uitzetten in een grafiek?<\/p>\n<p>A.<\/p>\n<ol>\n<li>De eerste stap is om de metingen te nummeren in een aparte kolom.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-53652\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/12\/metingengroeperen1-264x300.png\" alt=\"\" width=\"264\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/12\/metingengroeperen1-264x300.png 264w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/12\/metingengroeperen1.png 386w\" sizes=\"auto, (max-width: 264px) 100vw, 264px\" \/><\/li>\n<li>Maak een draaitabel. Zet het nummer van de meting in rijen &#8230;<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-53651\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/12\/metingengroeperen2-105x300.png\" alt=\"\" width=\"105\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/12\/metingengroeperen2-105x300.png 105w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/12\/metingengroeperen2.png 295w\" sizes=\"auto, (max-width: 105px) 100vw, 105px\" \/><\/li>\n<li>&#8230; en voeg de metingen toe. In dit voorbeeld hebben we de metingen driemaal toegevoegd.<\/li>\n<li>Dan wijzigen we SOM in wat we nodig hebben &#8211; in dit voorbeeld minimum, gemiddelde en maximum<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-53650\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/12\/metingengroeperen3-173x300.png\" alt=\"\" width=\"173\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/12\/metingengroeperen3-173x300.png 173w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/12\/metingengroeperen3.png 281w\" sizes=\"auto, (max-width: 173px) 100vw, 173px\" \/><\/li>\n<li>Het resultaat zijn drie kolommen:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-53649\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/12\/metingengroeperen4-300x106.png\" alt=\"\" width=\"300\" height=\"106\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/12\/metingengroeperen4-300x106.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/12\/metingengroeperen4.png 754w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/li>\n<li>Nu rechtsklikken we op \u00e9\u00e9n van die metingnummers en vragen Excel om te groeperen.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-53648\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/12\/metingengroeperen5-250x300.png\" alt=\"\" width=\"250\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/12\/metingengroeperen5-250x300.png 250w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/12\/metingengroeperen5.png 372w\" sizes=\"auto, (max-width: 250px) 100vw, 250px\" \/><\/li>\n<li>Dit is het resultaat:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-53647\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/12\/metingengroeperen6-300x115.png\" alt=\"\" width=\"300\" height=\"115\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/12\/metingengroeperen6-300x115.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/12\/metingengroeperen6.png 709w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/li>\n<li>Niet voldoende? Dan kan je een aparte kolom groep maken in stap 1, en die groep berekenen of manueel invoeren.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2018\/12\/metingen-groeperen.xlsx\">Een uitgewerkt voorbeeld in Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Hoe kan ik metingen gegroepeerd uitzetten in een grafiek? A. De eerste stap is om de metingen te nummeren in een aparte kolom. Maak een draaitabel. Zet het nummer van de meting in rijen &#8230; &#8230; en voeg de metingen toe. In dit voorbeeld hebben we de metingen driemaal<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":11,"footnotes":""},"categories":[539,54,375,366,558,79,10],"tags":[],"class_list":["post-53646","post","type-post","status-publish","format-standard","hentry","category-berekeningen","category-excel","category-excel-office-2010","category-grafieken","category-metingen","category-odisee","category-office"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 16:49:56","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\/53646","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=53646"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/53646\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=53646"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=53646"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=53646"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}