{"id":55874,"date":"2020-03-10T10:30:40","date_gmt":"2020-03-10T09:30:40","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/?p=55874"},"modified":"2022-04-29T11:13:20","modified_gmt":"2022-04-29T10:13:20","slug":"een-geografische-grafiek-maken-in-excel","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/een-geografische-grafiek-maken-in-excel\/","title":{"rendered":"Een geografische grafiek maken in Excel"},"content":{"rendered":"<p>Wist je dat je een geografische grafiek kan maken in Excel? Zo werkt het:<\/p>\n<ul>\n<li>Zet de geografische namen (landen, deelstaten, provincies, steden) in de eerste kolom<\/li>\n<li><em>Insert, Charts, Maps<\/em><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-55875\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/03\/geograph.png\" alt=\"\" width=\"1920\" height=\"1051\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/03\/geograph.png 1920w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/03\/geograph-300x164.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/03\/geograph-1024x561.png 1024w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/03\/geograph-768x420.png 768w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2020\/03\/geograph-1536x841.png 1536w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/p>\n<p>(Voorbeeld gebaseerd op de gegevens van COVID-19 besmettingen in Afrika op 9 maart &#8211; gegevens van <a href=\"https:\/\/www.ecdc.europa.eu\/en\/geographical-distribution-2019-ncov-cases\" rel=\"nofollow\">https:\/\/www.ecdc.europa.eu\/en\/geographical-distribution-2019-ncov-cases<\/a>)<\/p>\n<p>Enkele aandachtspunten:<\/p>\n<ul>\n<li>Excel zet de gegevens uit op de schaal die jij opgeeft. Er wordt geen rekening gehouden met bv. densiteit (aantal gevallen per km\u00c2\u00b2 oppervlakte of per hoofd van de bevolking, bv.) tenzij jij die berekent en je grafiek daarop baseert.<\/li>\n<li>Zorg ervoor dat de geografische naam dezelfde schaal hebben (bv. allemaal steden of allemaal landen), en in dezelfde taal geschreven zijn.<\/li>\n<li>Je kan ook een 3D grafiek maken.<\/li>\n<\/ul>\n<p>Meer info nodig? bekijk bv.<\/p>\n<ul>\n<li><a href=\"https:\/\/thinknook.com\/4-ways-to-visualize-geographical-location-data-in-excel-2013-2013-05-31\/\">4 Ways to Visualize Geographical (Location) Data in Excel 2013 | Thinknook<\/a><\/li>\n<li>Create a Map chart in Excel &#8211; Office Support<br \/>\n<a href=\"https:\/\/support.office.com\/en-us\/article\/Create-a-Map-chart-in-Excel-f2cfed55-d622-42cd-8ec9-ec8a358b593b\" rel=\"nofollow\">https:\/\/support.office.com\/en-us\/article\/Create-a-Map-chart-in-Excel-f2cfed55-d622-42cd-8ec9-ec8a358b593b<\/a><\/li>\n<li>Visualize your data in 3D Maps &#8211; Excel<br \/>\n<a href=\"https:\/\/support.office.com\/en-us\/article\/Visualize-your-data-in-3D-Maps-ce6b1d5c-4602-4dae-b487-91ec0268e75d\" rel=\"nofollow\">https:\/\/support.office.com\/en-us\/article\/Visualize-your-data-in-3D-Maps-ce6b1d5c-4602-4dae-b487-91ec0268e75d<\/a><\/li>\n<li>Create a region chart in 3D Maps &#8211; Excel<br \/>\n<a href=\"https:\/\/support.office.com\/en-us\/article\/Create-a-region-chart-in-3D-Maps-ce15c2c9-e9b1-47ab-ae53-37489cb67726\" rel=\"nofollow\">https:\/\/support.office.com\/en-us\/article\/Create-a-region-chart-in-3D-Maps-ce15c2c9-e9b1-47ab-ae53-37489cb67726<\/a><\/li>\n<li>Format a Map Chart &#8211; Office Support<br \/>\n<a href=\"https:\/\/support.office.com\/en-us\/article\/Format-a-Map-Chart-2c744937-a1cc-48f7-bc5e-776497343a29\" rel=\"nofollow\">https:\/\/support.office.com\/en-us\/article\/Format-a-Map-Chart-2c744937-a1cc-48f7-bc5e-776497343a29<\/a><\/li>\n<\/ul>\n<p>Doet Excel niet wat je verwacht? Bekijk dan bv. ook eens<\/p>\n<ul>\n<li>BI<br \/>\n<a href=\"https:\/\/www.sqlshack.com\/how-to-create-geographic-maps-using-power-bi-filled-and-bubble-maps\/\">How to create geographic maps using Power BI &#8211; Filled and bubble maps<\/a><\/li>\n<li>Tableau<br \/>\n<a href=\"https:\/\/help.tableau.com\/current\/pro\/desktop\/en-us\/maps_geographicroles.htm\">Format Geographic Fields in Tableau &#8211; Tableau<\/a><\/li>\n<li>Displayr<br \/>\n<a href=\"https:\/\/www.displayr.com\/create-a-geographic-map\/\">Free Geographic Map Maker | Create a Geographic Map with Displayr for Free<\/a><\/li>\n<li><a href=\"https:\/\/mapmaker.nationalgeographic.org\/\">National Geographic Mapmaker<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Wist je dat je een geografische grafiek kan maken in Excel? Zo werkt het: Zet de geografische namen (landen, deelstaten, provincies, steden) in de eerste kolom Insert, Charts, Maps (Voorbeeld gebaseerd op de gegevens van COVID-19 besmettingen in Afrika op 9 maart &#8211; gegevens van https:\/\/www.ecdc.europa.eu\/en\/geographical-distribution-2019-ncov-cases) Enkele aandachtspunten: Excel zet<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":35,"footnotes":""},"categories":[464,54,375,366,79,10,551],"tags":[],"class_list":["post-55874","post","type-post","status-publish","format-standard","hentry","category-ebp","category-excel","category-excel-office-2010","category-grafieken","category-odisee","category-office","category-office-2019"],"publishpress_future_action":{"enabled":false,"date":"2026-05-02 12:11:25","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\/55874","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=55874"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/55874\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=55874"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=55874"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=55874"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}