{"id":461,"date":"2023-10-27T15:28:32","date_gmt":"2023-10-27T15:28:32","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/eje-secundario\/"},"modified":"2023-12-25T10:22:59","modified_gmt":"2023-12-25T10:22:59","slug":"eje-secundario","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/eje-secundario\/","title":{"rendered":"\u00bfc\u00f3mo agregar un eje secundario en los gr\u00e1ficos de excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-3756186665\"><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>El primer paso para crear <a href=\"https:\/\/exceladvisor.org\/es\/graficos-avanzados\/\">gr\u00e1ficos avanzados de Excel<\/a> es aprender a agregar un eje secundario en un gr\u00e1fico. Si observa los dos gr\u00e1ficos siguientes, en el primer gr\u00e1fico tiene dos conjuntos diferentes de columnas de datos, pero el eje es el mismo. <\/p>\n<div class=\"wp-block-image\">\n<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=\"c\u00f3mo agregar un gr\u00e1fico de Excel de eje secundario\"><\/figure>\n<\/div>\n<p> El problema con el primer gr\u00e1fico es que las dos series tienen un rango de datos diferente pero el mismo eje. Pero en el segundo gr\u00e1fico tienes un eje diferente para las dos series de datos, lo que hace que sea m\u00e1s f\u00e1cil de entender.<\/p>\n<h2 class=\"wp-block-heading\"> Pasos para agregar un eje secundario en su gr\u00e1fico<\/h2>\n<p> Estos son los sencillos pasos que debe seguir para crear un eje dual.<\/p>\n<ul>\n<li> Seleccione la serie de datos para la que desea agregar un eje secundario. <\/li>\n<\/ul>\n<div class=\"wp-block-image\">\n<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=\"seleccione la serie de datos para crear un eje secundario\"><\/figure>\n<\/div>\n<ul>\n<li> Haga clic derecho sobre \u00e9l y vaya a Formatear serie de datos \u279c Opci\u00f3n de serie \u279c Habilitar eje secundario. <\/li>\n<\/ul>\n<div class=\"wp-block-image\">\n<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>\n<\/div>\n<ul>\n<li> Ahora tienes dos escalas en tu gr\u00e1fico. <\/li>\n<\/ul>\n<div class=\"wp-block-image\">\n<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=\"su gr\u00e1fico final de Excel con eje secundario\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> M\u00e9todo alternativo<\/h2>\n<ul>\n<li> Seleccione la serie de datos para la que desea agregar un eje secundario.<\/li>\n<li> Vaya a la pesta\u00f1a Formato \u279c Selecci\u00f3n actual \u279c Selecci\u00f3n de formato \u279c Formato de serie de datos \u279c Opci\u00f3n de serie \u279c Habilitar eje secundario. <\/li>\n<\/ul>\n<div class=\"wp-block-image\">\n<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=\"haga clic en la selecci\u00f3n de formato para agregar un eje secundario a un gr\u00e1fico de Excel\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> M\u00e1s informaci\u00f3n sobre gr\u00e1ficos<\/h2>\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/graficos-interactivos\/\">Gr\u00e1ficos interactivos en Excel.<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/agregar-una-linea-horizontal\/\">Agregar una l\u00ednea horizontal a un gr\u00e1fico en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/agregar-una-linea-vertical\/\">Agregar una l\u00ednea vertical a un gr\u00e1fico en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/rango-de-grafico-dinamico\/\">Rango de gr\u00e1fico din\u00e1mico en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/copiar-formato-de-grafico\/\">Copie el formato del gr\u00e1fico a otro gr\u00e1fico en Excel<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>El primer paso para crear gr\u00e1ficos avanzados de Excel es aprender a agregar un eje secundario en un gr\u00e1fico. Si observa los dos gr\u00e1ficos siguientes, en el primer gr\u00e1fico tiene dos conjuntos diferentes de columnas de datos, pero el eje es el mismo. El problema con el primer gr\u00e1fico es que las dos series tienen [&hellip;]<\/p>\n","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-461","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>\u00bfc\u00f3mo agregar un eje secundario en los gr\u00e1ficos de excel?<\/title>\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\/es\/eje-secundario\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo agregar un eje secundario en los gr\u00e1ficos de excel?\" \/>\n<meta property=\"og:description\" content=\"El primer paso para crear gr\u00e1ficos avanzados de Excel es aprender a agregar un eje secundario en un gr\u00e1fico. Si observa los dos gr\u00e1ficos siguientes, en el primer gr\u00e1fico tiene dos conjuntos diferentes de columnas de datos, pero el eje es el mismo. El problema con el primer gr\u00e1fico es que las dos series tienen [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/eje-secundario\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:22:59+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=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/eje-secundario\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/eje-secundario\/\",\"name\":\"\u00bfc\u00f3mo agregar un eje secundario en los gr\u00e1ficos de excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/eje-secundario\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/eje-secundario\/#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-25T10:22:59+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/eje-secundario\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/eje-secundario\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/eje-secundario\/#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\/es\/eje-secundario\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo agregar un eje secundario en los gr\u00e1ficos de excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo agregar un eje secundario en los gr\u00e1ficos de excel?","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\/es\/eje-secundario\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo agregar un eje secundario en los gr\u00e1ficos de excel?","og_description":"El primer paso para crear gr\u00e1ficos avanzados de Excel es aprender a agregar un eje secundario en un gr\u00e1fico. Si observa los dos gr\u00e1ficos siguientes, en el primer gr\u00e1fico tiene dos conjuntos diferentes de columnas de datos, pero el eje es el mismo. El problema con el primer gr\u00e1fico es que las dos series tienen [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/eje-secundario\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:22:59+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":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/eje-secundario\/","url":"https:\/\/exceladvisor.org\/es\/eje-secundario\/","name":"\u00bfc\u00f3mo agregar un eje secundario en los gr\u00e1ficos de excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/eje-secundario\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/eje-secundario\/#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-25T10:22:59+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/eje-secundario\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/eje-secundario\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/eje-secundario\/#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\/es\/eje-secundario\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo agregar un eje secundario en los gr\u00e1ficos de excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/461","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=461"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/461\/revisions"}],"predecessor-version":[{"id":807,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/461\/revisions\/807"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}