{"id":55952,"date":"2020-03-28T16:24:45","date_gmt":"2020-03-28T15:24:45","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/?p=55952"},"modified":"2020-03-28T16:25:10","modified_gmt":"2020-03-28T15:25:10","slug":"55952-2","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/55952-2\/","title":{"rendered":"Een rechthoekgrafiek maken in Excel"},"content":{"rendered":"<p>V. Ik zag laatst een soort rechthoekgrafiek &#8211; rechthoeken die samen ook een rechthoek vormen, met deelrubrieken. Kan ik dat maken in Excel?<\/p>\n<p>A. Ja: het heet Treemap.<\/p>\n<ul>\n<li>Maak je gegevenstabel in Excel. Zet telkens de overkoepelden grafiek boven een reeks deelrubrieken, zonder de totalen.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-trevillethumbnailsmall wp-image-55957\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/03\/rechthoekgrafiek1.png\" alt=\"\" width=\"265\" height=\"503\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/03\/rechthoekgrafiek1.png 265w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/03\/rechthoekgrafiek1-158x300.png 158w\" sizes=\"auto, (max-width: 265px) 100vw, 265px\" \/><\/li>\n<li>Voeg een Treemap toe.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-trevillethumbnailsmall wp-image-55956\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/03\/rechthoekgrafiek2.png\" alt=\"\" width=\"442\" height=\"306\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/03\/rechthoekgrafiek2.png 442w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/03\/rechthoekgrafiek2-300x208.png 300w\" sizes=\"auto, (max-width: 442px) 100vw, 442px\" \/><\/li>\n<li>Voorlopig zie je:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-trevillethumbnailsmall wp-image-55955\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/03\/rechthoekgrafiek3.png\" alt=\"\" width=\"480\" height=\"289\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/03\/rechthoekgrafiek3.png 480w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/03\/rechthoekgrafiek3-300x181.png 300w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\" \/><\/li>\n<li>Werk bij: titel toevoegen, legendes verwijderen<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-trevillethumbnailsmall wp-image-55954\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/03\/rechthoekgrafiek4.png\" alt=\"\" width=\"480\" height=\"278\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/03\/rechthoekgrafiek4.png 480w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/03\/rechthoekgrafiek4-300x174.png 300w\" sizes=\"auto, (max-width: 480px) 100vw, 480px\" \/><\/li>\n<li>Dit is een voorbeeld in Excel: <a href=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/03\/rechthoekgrafieken.xlsx\">rechthoekgrafieken<\/a><\/li>\n<li>Meer informatie nodig?\n<ul>\n<li>Een Treemap-grafiek maken in Office &#8211; Office-ondersteuning<br \/>\n<a href=\"https:\/\/support.microsoft.com\/nl-nl\/office\/een-treemap-grafiek-maken-in-office-dfe86d28-a610-4ef5-9b30-362d5c624b68?ui=nl-nl&#038;rs=nl-nl&#038;ad=nl\" rel=\"nofollow\">https:\/\/support.microsoft.com\/nl-nl\/office\/een-treemap-grafiek-maken-in-office-dfe86d28-a610-4ef5-9b30-362d5c624b68?ui=nl-nl&#038;rs=nl-nl&#038;ad=nl<\/a><\/li>\n<li>Treemap Excel Charts: The Perfect Tool for Displaying Hierarchical Data<br \/>\n<a href=\"https:\/\/www.spreadsheetweb.com\/treemap-excel-charts-hierarchical-data\/\" rel=\"nofollow\">https:\/\/www.spreadsheetweb.com\/treemap-excel-charts-hierarchical-data\/<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>V. Ik zag laatst een soort rechthoekgrafiek &#8211; rechthoeken die samen ook een rechthoek vormen, met deelrubrieken. Kan ik dat maken in Excel? A. Ja: het heet Treemap. Maak je gegevenstabel in Excel. Zet telkens de overkoepelden grafiek boven een reeks deelrubrieken, zonder de totalen. Voeg een Treemap toe. Voorlopig<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":6,"footnotes":""},"categories":[464,54,366,79,10],"tags":[],"class_list":["post-55952","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-03 10:56:43","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\/55952","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=55952"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/55952\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=55952"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=55952"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=55952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}