{"id":50762,"date":"2017-01-18T10:33:33","date_gmt":"2017-01-18T09:33:33","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=50762"},"modified":"2017-01-18T10:33:33","modified_gmt":"2017-01-18T09:33:33","slug":"grafiek-maken-voor-zwartwit-afdrukken","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/grafiek-maken-voor-zwartwit-afdrukken\/","title":{"rendered":"Grafiek maken voor zwart\/wit afdrukken"},"content":{"rendered":"<p>V. Ik heb grafieken in een tekst opgenomen die gekopieerd is, maar die grafieken zijn niet te te lezen. Is dat op te lossen?<\/p>\n<p>A. Je kan een grafiek voorbereiden voor gebruik in zwart\/wit afdrukken.<\/p>\n<p>Het was eenvoudiger in Excel 2010. Zie <a href=\"https:\/\/www.ablebits.com\/office-addins-blog\/2012\/03\/28\/excel-charts-tips\/\" rel=\"nofollow\">https:\/\/www.ablebits.com\/office-addins-blog\/2012\/03\/28\/excel-charts-tips\/<\/a><\/p>\n<p><a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/excel-chart-patternfill.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50767\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/excel-chart-patternfill-300x219.png\" alt=\"\" width=\"300\" height=\"219\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/excel-chart-patternfill-300x219.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/excel-chart-patternfill.png 637w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>In Excel 2013 en 2016 doe je dat zo.<\/p>\n<ul>\n<li>Maak de grafiek<\/li>\n<li>Rechtsklik op een regio \/ segment en kies <em>Opvulling, Bitmappatronen, Meer bitmappatronen<\/em>. Kies rechts voor <em>Patroonopvulling<br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-zw-grafiek1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50765\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-zw-grafiek1-300x284.png\" alt=\"\" width=\"300\" height=\"284\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-zw-grafiek1-300x284.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-zw-grafiek1-768x727.png 768w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-zw-grafiek1.png 836w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a>\u00c2\u00a0<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-zw-grafiek2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50766\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-zw-grafiek2-110x300.png\" alt=\"\" width=\"110\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-zw-grafiek2-110x300.png 110w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-zw-grafiek2.png 289w\" sizes=\"auto, (max-width: 110px) 100vw, 110px\" \/><\/a><\/em><\/li>\n<li>TIP. In het geval van cirkelgrafieken, zorg ervoor dat de labels duidelijk vermeld zijn. Voeg <em>Gegevenslabels<\/em> toe (via +), kies rechts voor <em>Categorienaam<\/em> en <em>Labellijnen toevoegen<br \/>\n<\/em><a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-zw-grafiek3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50764\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-zw-grafiek3.png\" alt=\"\" width=\"295\" height=\"125\" \/><\/a><br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-zw-grafiek4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50763\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-zw-grafiek4-151x300.png\" alt=\"\" width=\"151\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-zw-grafiek4-151x300.png 151w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-zw-grafiek4.png 300w\" sizes=\"auto, (max-width: 151px) 100vw, 151px\" \/><\/a><\/li>\n<\/ul>\n<p><a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-zw-grafiek2.png\">\u00c2\u00a0<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Ik heb grafieken in een tekst opgenomen die gekopieerd is, maar die grafieken zijn niet te te lezen. Is dat op te lossen? A. Je kan een grafiek voorbereiden voor gebruik in zwart\/wit afdrukken. Het was eenvoudiger in Excel 2010. Zie https:\/\/www.ablebits.com\/office-addins-blog\/2012\/03\/28\/excel-charts-tips\/ In Excel 2013 en 2016 doe je<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":10,"footnotes":""},"categories":[464,54,375,366,79,10,246,391,455],"tags":[],"class_list":["post-50762","post","type-post","status-publish","format-standard","hentry","category-ebp","category-excel","category-excel-office-2010","category-grafieken","category-odisee","category-office","category-office-2010","category-office-2013","category-office-2016"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 14:10:34","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\/50762","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=50762"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/50762\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=50762"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=50762"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=50762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}