{"id":51026,"date":"2017-03-09T20:48:42","date_gmt":"2017-03-09T19:48:42","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=51026"},"modified":"2024-04-28T17:47:21","modified_gmt":"2024-04-28T16:47:21","slug":"antwoorden-op-enquetes-omzetten-in-cijfers-en-grafieken","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/antwoorden-op-enquetes-omzetten-in-cijfers-en-grafieken\/","title":{"rendered":"Antwoorden op enqu\u00eates omzetten in cijfers en grafieken"},"content":{"rendered":"<p>V. Ik heb een aantal antwoorden op een set van vragen. Hoe krijg ik daar grafieken uit?<\/p>\n<p>A. Zo kan je dat doen:<\/p>\n<ul>\n<li>Zorg dat je weet wat je wil kunnen afleiden uit je gegevens.<\/li>\n<li>Organiseer je gegevens in kolommen (vragen in kolommen, antwoorden in rijen).<br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51031\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq1-300x254.png\" alt=\"\" width=\"300\" height=\"254\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq1-300x254.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq1.png 357w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><br \/>\nEr mogen geen lege rijen of kolommen zijn.<\/li>\n<li>Ga ergens in de gegevens staan, en doe Invoegen, Draaitabel.<br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51030\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq2-215x300.png\" alt=\"\" width=\"215\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq2-215x300.png 215w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq2.png 401w\" sizes=\"auto, (max-width: 215px) 100vw, 215px\" \/>\u00a0<\/a> <a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51029\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq3-300x141.png\" alt=\"\" width=\"300\" height=\"141\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq3-300x141.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq3-768x361.png 768w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq3.png 986w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/li>\n<li>Je krijgt een nieuw blad waarop je de velden te zien krijgt (de kolomkoppen van je eerste blad). Je kan die organiseren in de rijen, kolommen en velden van dit nieuwe blad.<br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51028\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq4-100x300.png\" alt=\"\" width=\"100\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq4-100x300.png 100w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq4.png 275w\" sizes=\"auto, (max-width: 100px) 100vw, 100px\" \/><\/a><\/li>\n<li>Bijvoorbeeld: <em>vraag 1<\/em> van het voorbeeld gecombineerd met <em>vraag 2<\/em>.<br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51027\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq5-300x164.png\" alt=\"\" width=\"300\" height=\"164\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq5-300x164.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq5-768x419.png 768w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq5-1024x559.png 1024w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/03\/xl-enq5.png 1920w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/li>\n<li>Meer over draaitabellen op <a href=\"https:\/\/support.office.com\/nl-nl\/article\/Een-draaitabel-maken-om-werkbladgegevens-te-analyseren-a9a84538-bfe9-40a9-a8e9-f99134456576\" rel=\"nofollow\">https:\/\/support.office.com\/nl-nl\/article\/Een-draaitabel-maken-om-werkbladgegevens-te-analyseren-a9a84538-bfe9-40a9-a8e9-f99134456576<\/a><\/li>\n<li>Heb je zowel in de eerste als in de tweede reeks getallen? Probeer misschien eens <a href=\"https:\/\/hlrnet.com\/technoblog\/inicio\/enquetegegevens-grafisch-voorstellen-met-een-spreidingsgrafiek\/\">een spreidingsgrafiek<\/a>.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>V. Ik heb een aantal antwoorden op een set van vragen. Hoe krijg ik daar grafieken uit? A. Zo kan je dat doen: Zorg dat je weet wat je wil kunnen afleiden uit je gegevens. Organiseer je gegevens in kolommen (vragen in kolommen, antwoorden in rijen). Er mogen geen lege<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":473,"footnotes":""},"categories":[448,464,538,54,366,10],"tags":[],"class_list":["post-51026","post","type-post","status-publish","format-standard","hentry","category-draaitabel","category-ebp","category-enquetes","category-excel","category-grafieken","category-office"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 05:49:40","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\/51026","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=51026"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/51026\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=51026"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=51026"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=51026"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}