{"id":45238,"date":"2014-02-28T20:36:08","date_gmt":"2014-02-28T19:36:08","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=45238"},"modified":"2021-06-29T17:10:18","modified_gmt":"2021-06-29T16:10:18","slug":"histogrammen-maken-met-draaitabel","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/histogrammen-maken-met-draaitabel\/","title":{"rendered":"Histogrammen maken met draaitabel"},"content":{"rendered":"<p>Er zijn verschillende manieren om een histogram te maken in Excel:<\/p>\n<ul>\n<li>Histogram van Analysis Toolpak<br \/>\nZie: Uw gegevens presenteren in een histogram &#8211; <a href=\"http:\/\/office.microsoft.com\/nl-be\/excel-help\/uw-gegevens-presenteren-in-een-histogram-HA010238252.aspx\">http:\/\/office.microsoft.com\/nl-be\/excel-help\/uw-gegevens-presenteren-in-een-histogram-HA010238252.aspx<\/a>\u00c2\u00a0\/ Het hulpprogramma Histogram gebruiken in Excel &#8211; <a href=\"http:\/\/support.microsoft.com\/kb\/214269\/nl\">http:\/\/support.microsoft.com\/kb\/214269\/nl<\/a><br \/>\nZie ook: <a href=\"http:\/\/hlrnet.com\/technoblog\/analysis-toolpak-niet-opgelijst-in-excel\/\">eerdere post<\/a><\/li>\n<li>de functie INTERVAL (nl) of FREQUENCY (en)<br \/>\nZie ook: <a href=\"http:\/\/hlrnet.com\/technoblog\/histogrammen-in-excel-en-openoffice\/\">eerdere post<\/a><\/li>\n<li>afronden met INTEGER, dan tellen met AANTAL.ALS<\/li>\n<\/ul>\n<p>Maar het kan een pak eenvoudiger met een draaitabel. Stap voor stap:<\/p>\n<ul>\n<li>Plaats de gegevens in een kolom met bovenaan de titel van het soort gegeven (een label)<br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/02\/xlhistogrampivotgetallen1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/02\/xlhistogrampivotgetallen1-86x300.png\" alt=\"xlhistogrampivotgetallen1\" width=\"86\" height=\"300\" \/><\/a><a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/02\/xlhistogrampivotstrings1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/02\/xlhistogrampivotstrings1-106x300.png\" alt=\"xlhistogrampivotstrings1\" width=\"106\" height=\"300\" \/><\/a><\/li>\n<li>Voeg een draaitabel in (Invoegen, Draaitabel)<\/li>\n<li>Plaats in de rijen het gegeven waarvan je een histogram wil maken, en bij gegevens datzelfde gegeven.<br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/02\/xlhistogrampivotgetallen2.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/02\/xlhistogrampivotgetallen2-300x161.png\" alt=\"xlhistogrampivotgetallen2\" width=\"300\" height=\"161\" \/><\/a><br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/02\/xlhistogrampivotstrings2.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/02\/xlhistogrampivotstrings2-300x161.png\" alt=\"xlhistogrampivotstrings2\" width=\"300\" height=\"161\" \/><\/a><\/li>\n<li>Wijzig desnoods het soort gegeven in AANTAL (COUNT)<br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/02\/xlhistogrampivotgetallen3.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/02\/xlhistogrampivotgetallen3-300x251.png\" alt=\"xlhistogrampivotgetallen3\" width=\"300\" height=\"251\" \/><\/a><\/li>\n<li>Nadien kan je desgewenst groeperen.<br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/02\/xlhistogrampivotgetallen4.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/02\/xlhistogrampivotgetallen4.png\" alt=\"xlhistogrampivotgetallen4\" width=\"225\" height=\"177\" \/><\/a><\/li>\n<li>Zie je overlappingen (0-10, 10-20)? Dan is dat omdat je gegevens continu zijn. Als je bv. gehele getallen hebt, wordt het 0-9, 10-19 enz<br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/02\/xlhistogrampivotgetallen5.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2014\/02\/xlhistogrampivotgetallen5-300x161.png\" alt=\"xlhistogrampivotgetallen5\" width=\"300\" height=\"161\" \/><\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Er zijn verschillende manieren om een histogram te maken in Excel: Histogram van Analysis Toolpak Zie: Uw gegevens presenteren in een histogram &#8211; http:\/\/office.microsoft.com\/nl-be\/excel-help\/uw-gegevens-presenteren-in-een-histogram-HA010238252.aspx\u00c2\u00a0\/ Het hulpprogramma Histogram gebruiken in Excel &#8211; http:\/\/support.microsoft.com\/kb\/214269\/nl Zie ook: eerdere post de functie INTERVAL (nl) of FREQUENCY (en) Zie ook: eerdere post afronden met INTEGER,<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":175,"footnotes":""},"categories":[375,79,246,391,572],"tags":[],"class_list":["post-45238","post","type-post","status-publish","format-standard","hentry","category-excel-office-2010","category-odisee","category-office-2010","category-office-2013","category-puntenboek"],"publishpress_future_action":{"enabled":false,"date":"2026-05-01 10:02:10","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\/45238","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=45238"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/45238\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=45238"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=45238"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=45238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}