{"id":1934,"date":"2023-10-27T15:28:32","date_gmt":"2023-10-27T15:28:32","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/secundaire-as\/"},"modified":"2023-12-06T05:51:50","modified_gmt":"2023-12-06T05:51:50","slug":"secundaire-as","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/secundaire-as\/","title":{"rendered":"Hoe voeg ik een secundaire as toe in excel-grafieken?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-3293133702\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>De eerste stap bij het maken van <a href=\"https:\/\/exceladvisor.org\/nl\/geavanceerde-grafische-afbeeldingen\/\">geavanceerde Excel-diagrammen<\/a> is leren hoe u een secundaire as aan een diagram toevoegt. Als je naar de twee onderstaande diagrammen kijkt, heb je in het eerste diagram twee verschillende sets gegevenskolommen, maar de as is hetzelfde. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-ajouter-un-graphique-excel-a-axe-secondaire-1.png\" sizes=\"\" srcset=\"\" alt=\"hoe u een Excel-diagram met een secundaire as toevoegt\"><\/figure><\/div><p> Het probleem met de eerste grafiek is dat de twee reeksen een verschillend gegevensbereik hebben, maar dezelfde as. Maar in het tweede diagram heb je een andere as voor de twee gegevensreeksen, waardoor het gemakkelijker te begrijpen is.<\/p><h2 class=\"wp-block-heading\"> Stappen om een secundaire as aan uw diagram toe te voegen<\/h2><p> Hier volgen de eenvoudige stappen die u moet volgen om een dubbele as te maken.<\/p><ul><li> Selecteer de gegevensreeks waarvoor u een secundaire as wilt toevoegen. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionner-la-serie-de-donnees-pour-creer-un-axe-secondaire-1.png\" sizes=\"\" srcset=\"\" alt=\"selecteer de gegevensreeks om een secundaire as te maken\"><\/figure><\/div><ul><li> Klik er met de rechtermuisknop op en ga naar Gegevensreeksen formatteren \u279c Reeksoptie \u279c Secundaire as inschakelen. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionner-laxe-secondaire-a-ajouter-a-un-graphique-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><ul><li> Nu heb je twee schalen in je diagram. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/votre-graphique-excel-final-avec-axe-secondaire-1.png\" sizes=\"\" srcset=\"\" alt=\"uw definitieve Excel-grafiek met secundaire as\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Alternatieve methode<\/h2><ul><li> Selecteer de gegevensreeks waarvoor u een secundaire as wilt toevoegen.<\/li><li> Ga naar het tabblad Opmaak \u279c Huidige selectie \u279c Opmaakselectie \u279c Gegevensreeksindeling \u279c Reeksoptie \u279c Secundaire as inschakelen. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cliquez-sur-la-selection-de-format-pour-ajouter-un-axe-secondaire-a-un-graphique-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"klik op de formaatselectie om een secundaire as aan een Excel-diagram toe te voegen\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Meer informatie over grafieken<\/h2><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/interactieve-afbeeldingen\/\">Interactieve grafieken in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/voeg-een-horizontale-lijn-toe\/\">Voeg een horizontale lijn toe aan een diagram in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/voeg-een-verticale-lijn-toe\/\">Voeg een verticale lijn toe aan een diagram in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/dynamisch-kaartbereik\/\">Dynamisch grafiekbereik in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/kopieer-het-kaartformaat\/\">Kopieer de diagramopmaak naar een ander diagram in Excel<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1934","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Hoe voeg ik een secundaire as toe in Excel-grafieken?<\/title>\n<meta name=\"description\" content=\"Volg deze eenvoudige stappen om een secundaire as aan Excel-diagrammen toe te voegen.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/nl\/secundaire-as\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe voeg ik een secundaire as toe in Excel-grafieken?\" \/>\n<meta property=\"og:description\" content=\"Volg deze eenvoudige stappen om een secundaire as aan Excel-diagrammen toe te voegen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/secundaire-as\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:51:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-ajouter-un-graphique-excel-a-axe-secondaire-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/secundaire-as\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/secundaire-as\/\",\"name\":\"Hoe voeg ik een secundaire as toe in Excel-grafieken?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/secundaire-as\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/secundaire-as\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-ajouter-un-graphique-excel-a-axe-secondaire-1.png\",\"datePublished\":\"2023-10-27T15:28:32+00:00\",\"dateModified\":\"2023-12-06T05:51:50+00:00\",\"description\":\"Volg deze eenvoudige stappen om een secundaire as aan Excel-diagrammen toe te voegen.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/secundaire-as\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/secundaire-as\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/secundaire-as\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-ajouter-un-graphique-excel-a-axe-secondaire-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-ajouter-un-graphique-excel-a-axe-secondaire-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/secundaire-as\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe voeg ik een secundaire as toe in excel-grafieken?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hoe voeg ik een secundaire as toe in Excel-grafieken?","description":"Volg deze eenvoudige stappen om een secundaire as aan Excel-diagrammen toe te voegen.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/nl\/secundaire-as\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe voeg ik een secundaire as toe in Excel-grafieken?","og_description":"Volg deze eenvoudige stappen om een secundaire as aan Excel-diagrammen toe te voegen.","og_url":"https:\/\/exceladvisor.org\/nl\/secundaire-as\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:51:50+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-ajouter-un-graphique-excel-a-axe-secondaire-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"1 minuut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/secundaire-as\/","url":"https:\/\/exceladvisor.org\/nl\/secundaire-as\/","name":"Hoe voeg ik een secundaire as toe in Excel-grafieken?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/secundaire-as\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/secundaire-as\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-ajouter-un-graphique-excel-a-axe-secondaire-1.png","datePublished":"2023-10-27T15:28:32+00:00","dateModified":"2023-12-06T05:51:50+00:00","description":"Volg deze eenvoudige stappen om een secundaire as aan Excel-diagrammen toe te voegen.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/secundaire-as\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/secundaire-as\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/secundaire-as\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-ajouter-un-graphique-excel-a-axe-secondaire-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-ajouter-un-graphique-excel-a-axe-secondaire-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/secundaire-as\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe voeg ik een secundaire as toe in excel-grafieken?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1934","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=1934"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1934\/revisions"}],"predecessor-version":[{"id":2863,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1934\/revisions\/2863"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1934"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}