{"id":1935,"date":"2023-10-27T15:28:32","date_gmt":"2023-10-27T15:28:32","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/sumbu-sekunder\/"},"modified":"2023-12-06T06:15:48","modified_gmt":"2023-12-06T06:15:48","slug":"sumbu-sekunder","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/sumbu-sekunder\/","title":{"rendered":"Bagaimana cara menambahkan sumbu sekunder di grafik excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2351179226\"><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>Langkah pertama untuk membuat <a href=\"https:\/\/exceladvisor.org\/id\/grafis-tingkat-lanjut\/\">bagan Excel tingkat lanjut<\/a> adalah mempelajari cara menambahkan sumbu sekunder dalam bagan. Jika Anda melihat dua bagan di bawah, pada bagan pertama Anda memiliki dua kumpulan kolom data yang berbeda, tetapi sumbunya sama. <\/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=\"cara menambahkan grafik excel sumbu sekunder\"><\/figure><\/div><p> Masalah pada grafik pertama adalah kedua seri tersebut memiliki rentang data yang berbeda tetapi sumbunya sama. Namun pada diagram kedua Anda memiliki sumbu yang berbeda untuk kedua seri data tersebut, sehingga lebih mudah untuk dipahami.<\/p><h2 class=\"wp-block-heading\"> Langkah-langkah untuk menambahkan sumbu sekunder di bagan Anda<\/h2><p> Berikut langkah sederhana yang perlu Anda ikuti untuk membuat sumbu ganda.<\/p><ul><li> Pilih seri data yang ingin Anda tambahkan sumbu sekundernya. <\/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=\"pilih seri data untuk membuat sumbu sekunder\"><\/figure><\/div><ul><li> Klik kanan padanya dan buka Format Seri Data \u279c Opsi Seri \u279c Aktifkan Sumbu Sekunder. <\/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> Sekarang Anda memiliki dua skala di bagan Anda. <\/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=\"bagan excel akhir Anda dengan sumbu sekunder\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Metode alternatif<\/h2><ul><li> Pilih seri data yang ingin Anda tambahkan sumbu sekundernya.<\/li><li> Buka tab Format \u279c Pilihan Saat Ini \u279c Pilihan Format \u279c Format Seri Data \u279c Opsi Seri \u279c Aktifkan Sumbu Sekunder. <\/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 pada pilihan format untuk menambahkan sumbu sekunder ke bagan excel\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Pelajari lebih lanjut tentang grafik<\/h2><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/grafik-interaktif\/\">Bagan interaktif di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-garis-horizontal\/\">Tambahkan garis horizontal ke bagan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-garis-vertikal\/\">Tambahkan garis vertikal ke bagan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/rentang-grafik-dinamis\/\">Rentang grafik dinamis di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/salin-format-bagan\/\">Salin pemformatan bagan ke bagan lain di 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-1935","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>Bagaimana cara menambahkan sumbu sekunder di grafik Excel?<\/title>\n<meta name=\"description\" content=\"Untuk menambahkan sumbu sekunder di bagan Excel, cukup ikuti langkah-langkah sederhana berikut.\" \/>\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\/id\/sumbu-sekunder\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menambahkan sumbu sekunder di grafik Excel?\" \/>\n<meta property=\"og:description\" content=\"Untuk menambahkan sumbu sekunder di bagan Excel, cukup ikuti langkah-langkah sederhana berikut.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/sumbu-sekunder\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:48+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=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/sumbu-sekunder\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/sumbu-sekunder\/\",\"name\":\"Bagaimana cara menambahkan sumbu sekunder di grafik Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/sumbu-sekunder\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/sumbu-sekunder\/#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-06T06:15:48+00:00\",\"description\":\"Untuk menambahkan sumbu sekunder di bagan Excel, cukup ikuti langkah-langkah sederhana berikut.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/sumbu-sekunder\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/sumbu-sekunder\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/sumbu-sekunder\/#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\/id\/sumbu-sekunder\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menambahkan sumbu sekunder di grafik excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara menambahkan sumbu sekunder di grafik Excel?","description":"Untuk menambahkan sumbu sekunder di bagan Excel, cukup ikuti langkah-langkah sederhana berikut.","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\/id\/sumbu-sekunder\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menambahkan sumbu sekunder di grafik Excel?","og_description":"Untuk menambahkan sumbu sekunder di bagan Excel, cukup ikuti langkah-langkah sederhana berikut.","og_url":"https:\/\/exceladvisor.org\/id\/sumbu-sekunder\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:48+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":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/sumbu-sekunder\/","url":"https:\/\/exceladvisor.org\/id\/sumbu-sekunder\/","name":"Bagaimana cara menambahkan sumbu sekunder di grafik Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/sumbu-sekunder\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/sumbu-sekunder\/#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-06T06:15:48+00:00","description":"Untuk menambahkan sumbu sekunder di bagan Excel, cukup ikuti langkah-langkah sederhana berikut.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/sumbu-sekunder\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/sumbu-sekunder\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/sumbu-sekunder\/#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\/id\/sumbu-sekunder\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menambahkan sumbu sekunder di grafik excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1935","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1935"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1935\/revisions"}],"predecessor-version":[{"id":2454,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1935\/revisions\/2454"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1935"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}