{"id":7375,"date":"2018-04-12T14:24:00","date_gmt":"2018-04-12T12:24:00","guid":{"rendered":"https:\/\/www.espai.es\/blog\/?p=7375"},"modified":"2021-03-03T20:19:22","modified_gmt":"2021-03-03T18:19:22","slug":"como-hacer-minigraficos-en-excel","status":"publish","type":"post","link":"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/","title":{"rendered":"C\u00f3mo hacer minigr\u00e1ficos en Excel"},"content":{"rendered":"

Buenos d\u00edas y bienvenidos a un nuevo art\u00edculo de Espai, hoy vamos a hablar de una herramienta bastante desconocida: Los minigr\u00e1ficos en Excel. Es un tema muy importante, tanto\u00a0es as\u00ed que los que terminen de leerlo y comenten obtendr\u00e1n gratis un<\/p>\n

 <\/p>\n

\"espai
\nMaster en Seguridad nuclear\u00a0totalmente gratis! Solo hasta fin de mes<\/p>\n

 <\/p>\n

Bromas aparte, esta herramienta es muy \u00fatil en el an\u00e1lisis de datos. Si en tu trabajo tienes que trabajar (wow, que vocabulario) con grandes vol\u00famenes de datos, te permitir\u00e1 ver de un solo vistazo (en serio?)\u00a0la progresi\u00f3n de los mismos.<\/p>\n

Despues de esta l\u00ednea que puede encerrar una gran verdad, una tonter\u00eda o el misterio de los Illuminati<\/a>, vamos al l\u00edo.<\/p>\n

 <\/p>\n

\u00bfQu\u00e9 son los minigr\u00e1ficos en Excel?<\/h4>\n

 <\/p>\n

Son esto:<\/p>\n

\"excel-minigraficos-espai-1\"<\/p>\n

 <\/p>\n

como veis, es muy f\u00e1cil ver c\u00f3mo progresa el precio de los productos solamente de un vistazo. Cada minigr\u00e1fico ilustra la variaci\u00f3n mes a mes.<\/p>\n

 <\/p>\n

\u00bfC\u00f3mo se insertan?<\/h3>\n

 <\/p>\n

Bastante f\u00e1cil la verdad. Ah\u00ed va el paso a paso:<\/p>\n

 <\/p>\n

\"Excel<\/p>\n

En el ejemplo, nos ponemos en una casilla en blanco a la derecha de nuestros datos. Vamos a hacer una nueva columna para mostrar los minigr\u00e1ficos de cada fila.<\/p>\n

 <\/p>\n

 <\/p>\n

\"Excel<\/p>\n

Escribimos un nombre para la columna: \u00abGr\u00e1ficos\u00bb<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

\"Excel<\/p>\n

Al aceptar, se nos hace m\u00e1s grande la tabla que ten\u00edamos definida. Si no has hecho una tabla no te preocupes, no es\u00a0imprescindible, simplemente no se \u00abcolorear\u00e1\u00bb la nueva columna.<\/p>\n

 <\/p>\n

 <\/p>\n

\"Excel<\/p>\n

Vamos a la pesta\u00f1a \u00abinsertar\u00bb y desde ah\u00ed a la opci\u00f3n \u00abL\u00ednea\u00bb. Puedes probar tambi\u00e9n\u00a0con otros estilos, como \u00abcolumna\u00bb. El resultado ser\u00e1 el mismo pero se visualizar\u00e1 diferente.<\/p>\n

 <\/p>\n

 <\/p>\n

\"Excel<\/p>\n

Nos aparece un asistente que nos pregunta\u00a0qu\u00e9 datos va a utilizar el minigr\u00e1fico.<\/p>\n

 <\/p>\n

 <\/p>\n

\"Excel<\/p>\n

Seleccionamos con el rat\u00f3n (en el ejemplo) de la celda C4 a la H4. Cuando lo tengamos, pulsamos en \u00abaceptar\u00bb<\/p>\n

 <\/p>\n

 <\/p>\n

\"Excel<\/p>\n

Este es nuestro primer minigr\u00e1fico. Ahora, si cogemos el\u00a0controladir de relleno y arrastramos hasta la\u00a0fila 8, tendremos el resultado\u00a0para toda la tabla.<\/p>\n

\u00bfQu\u00e9 es el controlador de relleno? El punto de color m\u00e1s oscuro que hay a en la esquina abajo-derecha de la celda seleccionada.<\/p>\n

 <\/p>\n

 <\/p>\n

\"Excel<\/p>\n

Resultado de arrastrar el controlador de relleno hasta la fila 8. \u00a1Ya lo tenemos!<\/p>\n

 <\/p>\n

 <\/p>\n

Como veis es muy sencillo y aplicable en infinidad de casos: Contabilidad dom\u00e9stica, an\u00e1lisis de mercados financieros, ansiedad que acumulamos seg\u00fan se acerca el viernes… Cualquier cosa cuantificable!\u00a0Adem\u00e1s si ten\u00e9is curiosidad, en Internet hay estad\u00edsticas\u00a0de muchos temas diferentes… Algunos que dan que pensar.<\/p>\n

 <\/p>\n

\"Excel<\/p>\n

 <\/p>\n

Nos venden la moto, al estilo Groucho Marx: \u00abEstos son mis principios, si no le gustan tengo otros\u00bb. Bueno hasta aqu\u00ed el articulo de hoy, que esto ya no es Excel sino filosofar :S<\/p>\n

Que teng\u00e1is un buen d\u00eda!<\/p>\n","protected":false},"excerpt":{"rendered":"

Buenos d\u00edas y bienvenidos a un nuevo art\u00edculo de Espai, hoy vamos a hablar de una herramienta bastante desconocida: Los minigr\u00e1ficos en Excel. Es un tema muy importante, tanto\u00a0es as\u00ed que los que terminen de leerlo y comenten obtendr\u00e1n gratis un   Master en Seguridad…<\/p>\n","protected":false},"author":3,"featured_media":7460,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_ef_editorial_meta_date_first-draft-date":"","_ef_editorial_meta_paragraph_assignment":"","_ef_editorial_meta_checkbox_needs-photo":"","_ef_editorial_meta_number_word-count":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[771,379],"tags":[41,620,295,621],"class_list":["post-7375","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ofimatica","category-productividad","tag-espai","tag-estadisticas","tag-excel","tag-minigraficos"],"yoast_head":"\nMinigr\u00e1ficos en Excel, Espai Escuela de inform\u00e1tica<\/title>\n<meta name=\"description\" content=\"Minigr\u00e1ficos en Excel, Espai Escuela de inform\u00e1tica\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Minigr\u00e1ficos en Excel, Espai Escuela de inform\u00e1tica\" \/>\n<meta property=\"og:description\" content=\"Minigr\u00e1ficos en Excel, Espai Escuela de inform\u00e1tica\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog Escola Espai\" \/>\n<meta property=\"article:published_time\" content=\"2018-04-12T12:24:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-03T18:19:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2018\/04\/graficos-excel-e1526932082397.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"508\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Escobar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Escobar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/\"},\"author\":{\"name\":\"Escobar\",\"@id\":\"https:\/\/www.espai.es\/blog\/#\/schema\/person\/d2e265073982f28e16cb7edccbd16602\"},\"headline\":\"C\u00f3mo hacer minigr\u00e1ficos en Excel\",\"datePublished\":\"2018-04-12T12:24:00+00:00\",\"dateModified\":\"2021-03-03T18:19:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/\"},\"wordCount\":506,\"commentCount\":1,\"image\":{\"@id\":\"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2018\/04\/graficos-excel-e1526932082397.jpg\",\"keywords\":[\"Espai\",\"estadisticas\",\"excel\",\"minigraficos\"],\"articleSection\":[\"Ofim\u00e1tica\",\"Productividad\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/\",\"url\":\"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/\",\"name\":\"Minigr\u00e1ficos en Excel, Espai Escuela de inform\u00e1tica\",\"isPartOf\":{\"@id\":\"https:\/\/www.espai.es\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2018\/04\/graficos-excel-e1526932082397.jpg\",\"datePublished\":\"2018-04-12T12:24:00+00:00\",\"dateModified\":\"2021-03-03T18:19:22+00:00\",\"author\":{\"@id\":\"https:\/\/www.espai.es\/blog\/#\/schema\/person\/d2e265073982f28e16cb7edccbd16602\"},\"description\":\"Minigr\u00e1ficos en Excel, Espai Escuela de inform\u00e1tica\",\"breadcrumb\":{\"@id\":\"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/#primaryimage\",\"url\":\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2018\/04\/graficos-excel-e1526932082397.jpg\",\"contentUrl\":\"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2018\/04\/graficos-excel-e1526932082397.jpg\",\"width\":1024,\"height\":508},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/www.espai.es\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00f3mo hacer minigr\u00e1ficos en Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.espai.es\/blog\/#website\",\"url\":\"https:\/\/www.espai.es\/blog\/\",\"name\":\"Blog Escola Espai\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.espai.es\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.espai.es\/blog\/#\/schema\/person\/d2e265073982f28e16cb7edccbd16602\",\"name\":\"Escobar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.espai.es\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6fb517675f8bc757ee26d9143abae3c5eac58b13068bfcbc1485bbb092cef370?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6fb517675f8bc757ee26d9143abae3c5eac58b13068bfcbc1485bbb092cef370?s=96&d=mm&r=g\",\"caption\":\"Escobar\"},\"sameAs\":[\"http:\/\/www.espai.es\"],\"url\":\"https:\/\/www.espai.es\/blog\/author\/escobar\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Minigr\u00e1ficos en Excel, Espai Escuela de inform\u00e1tica","description":"Minigr\u00e1ficos en Excel, Espai Escuela de inform\u00e1tica","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:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"Minigr\u00e1ficos en Excel, Espai Escuela de inform\u00e1tica","og_description":"Minigr\u00e1ficos en Excel, Espai Escuela de inform\u00e1tica","og_url":"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/","og_site_name":"Blog Escola Espai","article_published_time":"2018-04-12T12:24:00+00:00","article_modified_time":"2021-03-03T18:19:22+00:00","og_image":[{"width":1024,"height":508,"url":"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2018\/04\/graficos-excel-e1526932082397.jpg","type":"image\/jpeg"}],"author":"Escobar","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Escobar","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/#article","isPartOf":{"@id":"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/"},"author":{"name":"Escobar","@id":"https:\/\/www.espai.es\/blog\/#\/schema\/person\/d2e265073982f28e16cb7edccbd16602"},"headline":"C\u00f3mo hacer minigr\u00e1ficos en Excel","datePublished":"2018-04-12T12:24:00+00:00","dateModified":"2021-03-03T18:19:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/"},"wordCount":506,"commentCount":1,"image":{"@id":"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2018\/04\/graficos-excel-e1526932082397.jpg","keywords":["Espai","estadisticas","excel","minigraficos"],"articleSection":["Ofim\u00e1tica","Productividad"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/","url":"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/","name":"Minigr\u00e1ficos en Excel, Espai Escuela de inform\u00e1tica","isPartOf":{"@id":"https:\/\/www.espai.es\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2018\/04\/graficos-excel-e1526932082397.jpg","datePublished":"2018-04-12T12:24:00+00:00","dateModified":"2021-03-03T18:19:22+00:00","author":{"@id":"https:\/\/www.espai.es\/blog\/#\/schema\/person\/d2e265073982f28e16cb7edccbd16602"},"description":"Minigr\u00e1ficos en Excel, Espai Escuela de inform\u00e1tica","breadcrumb":{"@id":"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/#primaryimage","url":"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2018\/04\/graficos-excel-e1526932082397.jpg","contentUrl":"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2018\/04\/graficos-excel-e1526932082397.jpg","width":1024,"height":508},{"@type":"BreadcrumbList","@id":"https:\/\/www.espai.es\/blog\/2018\/04\/como-hacer-minigraficos-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.espai.es\/blog\/"},{"@type":"ListItem","position":2,"name":"C\u00f3mo hacer minigr\u00e1ficos en Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.espai.es\/blog\/#website","url":"https:\/\/www.espai.es\/blog\/","name":"Blog Escola Espai","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.espai.es\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/www.espai.es\/blog\/#\/schema\/person\/d2e265073982f28e16cb7edccbd16602","name":"Escobar","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.espai.es\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6fb517675f8bc757ee26d9143abae3c5eac58b13068bfcbc1485bbb092cef370?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6fb517675f8bc757ee26d9143abae3c5eac58b13068bfcbc1485bbb092cef370?s=96&d=mm&r=g","caption":"Escobar"},"sameAs":["http:\/\/www.espai.es"],"url":"https:\/\/www.espai.es\/blog\/author\/escobar\/"}]}},"jetpack_featured_media_url":"https:\/\/www.espai.es\/blog\/wp-content\/uploads\/2018\/04\/graficos-excel-e1526932082397.jpg","jetpack_sharing_enabled":false,"_links":{"self":[{"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/posts\/7375","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/comments?post=7375"}],"version-history":[{"count":7,"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/posts\/7375\/revisions"}],"predecessor-version":[{"id":7461,"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/posts\/7375\/revisions\/7461"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/media\/7460"}],"wp:attachment":[{"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/media?parent=7375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/categories?post=7375"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.espai.es\/blog\/wp-json\/wp\/v2\/tags?post=7375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}