{"id":3426,"date":"2023-10-27T15:28:32","date_gmt":"2023-10-27T15:28:32","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/sekundarachse\/"},"modified":"2023-12-03T11:21:07","modified_gmt":"2023-12-03T11:21:07","slug":"sekundarachse","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/sekundarachse\/","title":{"rendered":"Wie f\u00fcge ich in excel-diagrammen eine sekund\u00e4re achse hinzu?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-591145429\"><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>Der erste Schritt zum Erstellen <a href=\"https:\/\/exceladvisor.org\/de\/erweiterte-grafik\/\">erweiterter Excel-Diagramme<\/a> besteht darin, zu lernen, wie man einem Diagramm eine sekund\u00e4re Achse hinzuf\u00fcgt. Wenn Sie sich die beiden Diagramme unten ansehen, sehen Sie im ersten Diagramm zwei unterschiedliche S\u00e4tze von Datenspalten, aber die Achse ist dieselbe. <\/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=\"So f\u00fcgen Sie ein Excel-Diagramm mit sekund\u00e4rer Achse hinzu\"><\/figure><\/div><p> Das Problem beim ersten Diagramm besteht darin, dass die beiden Reihen einen unterschiedlichen Datenbereich, aber dieselbe Achse haben. Im zweiten Diagramm haben Sie jedoch eine andere Achse f\u00fcr die beiden Datenreihen, was das Verst\u00e4ndnis erleichtert.<\/p><h2 class=\"wp-block-heading\"> Schritte zum Hinzuf\u00fcgen einer sekund\u00e4ren Achse in Ihrem Diagramm<\/h2><p> Hier sind die einfachen Schritte, die Sie befolgen m\u00fcssen, um eine Doppelachse zu erstellen.<\/p><ul><li> W\u00e4hlen Sie die Datenreihe aus, f\u00fcr die Sie eine Sekund\u00e4rachse hinzuf\u00fcgen m\u00f6chten. <\/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=\"W\u00e4hlen Sie die Datenreihe aus, um eine sekund\u00e4re Achse zu erstellen\"><\/figure><\/div><ul><li> Klicken Sie mit der rechten Maustaste darauf und gehen Sie zu \u201eDatenreihen formatieren\u201c \u279c \u201eSerienoption\u201c \u279c \u201eSekund\u00e4re Achse aktivieren\u201c. <\/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> Jetzt haben Sie zwei Skalen in Ihrem Diagramm. <\/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=\"Ihr endg\u00fcltiges Excel-Diagramm mit Sekund\u00e4rachse\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Alternative Methode<\/h2><ul><li> W\u00e4hlen Sie die Datenreihe aus, f\u00fcr die Sie eine Sekund\u00e4rachse hinzuf\u00fcgen m\u00f6chten.<\/li><li> Gehen Sie zur Registerkarte \u201eFormat\u201c \u279c Aktuelle Auswahl \u279c Formatauswahl \u279c Datenreihenformat \u279c Serienoption \u279c Sekund\u00e4rachse aktivieren. <\/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=\"Klicken Sie auf die Formatauswahl, um einem Excel-Diagramm eine sekund\u00e4re Achse hinzuzuf\u00fcgen\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Erfahren Sie mehr \u00fcber Diagramme<\/h2><ul><li> <a href=\"https:\/\/exceladvisor.org\/de\/interaktive-grafiken\/\">Interaktive Diagramme in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/fugen-sie-eine-horizontale-linie-hinzu\/\">F\u00fcgen Sie einem Diagramm in Excel eine horizontale Linie hinzu<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/fugen-sie-eine-vertikale-linie-hinzu\/\">F\u00fcgen Sie einem Diagramm in Excel eine vertikale Linie hinzu<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/dynamischer-diagrammbereich\/\">Dynamischer Diagrammbereich in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/diagrammformat-kopieren\/\">Diagrammformatierung in ein anderes Diagramm in Excel kopieren<\/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-3426","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>Wie f\u00fcge ich in Excel-Diagrammen eine sekund\u00e4re Achse hinzu?<\/title>\n<meta name=\"description\" content=\"Um eine sekund\u00e4re Achse in Excel-Diagrammen hinzuzuf\u00fcgen, befolgen Sie einfach diese einfachen Schritte.\" \/>\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\/de\/sekundarachse\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wie f\u00fcge ich in Excel-Diagrammen eine sekund\u00e4re Achse hinzu?\" \/>\n<meta property=\"og:description\" content=\"Um eine sekund\u00e4re Achse in Excel-Diagrammen hinzuzuf\u00fcgen, befolgen Sie einfach diese einfachen Schritte.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/sekundarachse\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T11:21:07+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=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\u00a0Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/de\/sekundarachse\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/sekundarachse\/\",\"name\":\"Wie f\u00fcge ich in Excel-Diagrammen eine sekund\u00e4re Achse hinzu?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/sekundarachse\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/sekundarachse\/#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-03T11:21:07+00:00\",\"description\":\"Um eine sekund\u00e4re Achse in Excel-Diagrammen hinzuzuf\u00fcgen, befolgen Sie einfach diese einfachen Schritte.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/sekundarachse\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/sekundarachse\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/sekundarachse\/#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\/de\/sekundarachse\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie f\u00fcge ich in excel-diagrammen eine sekund\u00e4re achse hinzu?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"name\":\"Excel Advisor\",\"description\":\"Ihr Leitfaden zur Datendominanz\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Wie f\u00fcge ich in Excel-Diagrammen eine sekund\u00e4re Achse hinzu?","description":"Um eine sekund\u00e4re Achse in Excel-Diagrammen hinzuzuf\u00fcgen, befolgen Sie einfach diese einfachen Schritte.","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\/de\/sekundarachse\/","og_locale":"de_DE","og_type":"article","og_title":"Wie f\u00fcge ich in Excel-Diagrammen eine sekund\u00e4re Achse hinzu?","og_description":"Um eine sekund\u00e4re Achse in Excel-Diagrammen hinzuzuf\u00fcgen, befolgen Sie einfach diese einfachen Schritte.","og_url":"https:\/\/exceladvisor.org\/de\/sekundarachse\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T11:21:07+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":{"Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/de\/sekundarachse\/","url":"https:\/\/exceladvisor.org\/de\/sekundarachse\/","name":"Wie f\u00fcge ich in Excel-Diagrammen eine sekund\u00e4re Achse hinzu?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/sekundarachse\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/sekundarachse\/#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-03T11:21:07+00:00","description":"Um eine sekund\u00e4re Achse in Excel-Diagrammen hinzuzuf\u00fcgen, befolgen Sie einfach diese einfachen Schritte.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/sekundarachse\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/sekundarachse\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/sekundarachse\/#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\/de\/sekundarachse\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie f\u00fcge ich in excel-diagrammen eine sekund\u00e4re achse hinzu?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/de\/#website","url":"https:\/\/exceladvisor.org\/de\/","name":"Excel Advisor","description":"Ihr Leitfaden zur Datendominanz","publisher":{"@id":"https:\/\/exceladvisor.org\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/de\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3426","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/comments?post=3426"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3426\/revisions"}],"predecessor-version":[{"id":4046,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3426\/revisions\/4046"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3426"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}