{"id":147,"date":"2021-03-27T21:29:03","date_gmt":"2021-03-27T20:29:03","guid":{"rendered":"https:\/\/www.netexpertise.eu\/es\/?p=147"},"modified":"2022-01-03T23:14:56","modified_gmt":"2022-01-03T22:14:56","slug":"diagramas-de-gantt-por-horas-con-sparkline","status":"publish","type":"post","link":"http:\/\/www.netexpertise.eu\/es\/diverso\/diagramas-de-gantt-por-horas-con-sparkline.html","title":{"rendered":"Diagramas de Gantt por Horas"},"content":{"rendered":"\n<p>Quer\u00eda mostrar los tiempos de ejecuci\u00f3n de tareas de un plan de recuperaci\u00f3n en un desastre en un diagrama de Gantt para que se vea mejor que una aburrida lista de horas de inicio y finalizaci\u00f3n, pero no encontr\u00e9 ninguna herramienta que gestione las horas de un d\u00eda \/ 24 horas.<\/p>\n\n\n\n<p>Los softs de Gantt ofrecen demasiadas funciones que no necesito para un informe simple. As\u00ed que opt\u00e9 por la funci\u00f3n Sparkline en&nbsp;Google Sheets: es gratis y sigue siendo bastante f\u00e1cil incluso si tienes que trabajar un poco para que funcione con horas. Tambi\u00e9n est\u00e1 disponible en Excel, por supuesto.<\/p>\n\n\n\n<p>\u00bfQu\u00e9 es Sparkline? En resumen, Sparkline es un gr\u00e1fico en una celda de Excel (o equivalente como Google Sheets) destinado a dar una tendencia. Los gr\u00e1ficos de barras son excelentes para los diagramas de Gantt.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"\/uploads\/Google_sheet_gantt_timeline-1.png\"><img src=\"\/uploads\/Google_sheet_gantt_timeline-1.png\" alt=\"Diagrama de Gantt por Horas en Google Sheets\"\/><\/a><\/figure>\n\n\n\n<p><br>No hay m\u00ednimo, y el m\u00e1ximo solo funciona para n\u00fameros en gr\u00e1ficos de barras, es por eso que cre\u00e9 2 columnas Start Delay y Duration en minutos. F\u00f3rmulas b\u00e1sicas sobre las horas de inicio y finalizaci\u00f3n del proyecto y las tareas permiten completarlas autom\u00e1ticamente.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"powershell\" class=\"language-powershell\">=HORA(D5-$D$3)*60+MINUTO(D5-$D$3); Start delay\n=HORA(E5-D5)*60+MINUTO(E5-D5); Duration<\/code><\/pre>\n\n\n\n<p><br>Las celdas Sparkline se crean a partir de estos 2 valores; La primera barra es blanca para colocar la barra de color en el lugar correcto. El valor m\u00e1ximo es simplemente la duraci\u00f3n del proyecto..<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"powershell\" class=\"language-powershell\">=SPARKLINE(F5:G5,{\"charttype\",\"bar\"\\\"color1\",\"white\"\\\"color2\",\"#199698\"\\\"max\",$G$3})<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Quer\u00eda mostrar los tiempos de ejecuci\u00f3n de tareas de un plan de recuperaci\u00f3n en un desastre en un diagrama de Gantt para que se vea mejor que una aburrida lista de horas de inicio y finalizaci\u00f3n, pero no encontr\u00e9 ninguna herramienta que gestione las horas de un d\u00eda \/ 24 horas. Los softs de Gantt [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[41],"tags":[108,58,57,59],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.13 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Netexpertise - Diagramas de Gantt por Horas<\/title>\n<meta name=\"description\" content=\"Microsoft Excel o Google Sheet - Cree diagramas de Gantt en Horas con Sparklines\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.netexpertise.eu\/es\/diverso\/diagramas-de-gantt-por-horas-con-sparkline.html\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Netexpertise - Diagramas de Gantt por Horas\" \/>\n<meta property=\"og:description\" content=\"Microsoft Excel o Google Sheet - Cree diagramas de Gantt en Horas con Sparklines\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.netexpertise.eu\/es\/diverso\/diagramas-de-gantt-por-horas-con-sparkline.html\" \/>\n<meta property=\"og:site_name\" content=\"Netexpertise\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-27T20:29:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-01-03T22:14:56+00:00\" \/>\n<meta name=\"author\" content=\"dave\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@netexpertise\" \/>\n<meta name=\"twitter:site\" content=\"@netexpertise\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.netexpertise.eu\/es\/diverso\/diagramas-de-gantt-por-horas-con-sparkline.html\",\"url\":\"http:\/\/www.netexpertise.eu\/es\/diverso\/diagramas-de-gantt-por-horas-con-sparkline.html\",\"name\":\"Netexpertise - Diagramas de Gantt por Horas\",\"isPartOf\":{\"@id\":\"https:\/\/www.netexpertise.eu\/es\/#website\"},\"datePublished\":\"2021-03-27T20:29:03+00:00\",\"dateModified\":\"2022-01-03T22:14:56+00:00\",\"author\":{\"@id\":\"https:\/\/www.netexpertise.eu\/es\/#\/schema\/person\/27ec923be6625ac4b4bb86c8f0b12abf\"},\"description\":\"Microsoft Excel o Google Sheet - Cree diagramas de Gantt en Horas con Sparklines\",\"breadcrumb\":{\"@id\":\"http:\/\/www.netexpertise.eu\/es\/diverso\/diagramas-de-gantt-por-horas-con-sparkline.html#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.netexpertise.eu\/es\/diverso\/diagramas-de-gantt-por-horas-con-sparkline.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/www.netexpertise.eu\/es\/diverso\/diagramas-de-gantt-por-horas-con-sparkline.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/www.netexpertise.eu\/es\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Diagramas de Gantt por Horas\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.netexpertise.eu\/es\/#website\",\"url\":\"https:\/\/www.netexpertise.eu\/es\/\",\"name\":\"Netexpertise\",\"description\":\"Sistemas \/ Redes \/ DevOps\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.netexpertise.eu\/es\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.netexpertise.eu\/es\/#\/schema\/person\/27ec923be6625ac4b4bb86c8f0b12abf\",\"name\":\"dave\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.netexpertise.eu\/es\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/1.gravatar.com\/avatar\/1129916e1f4955bd632f27f836f64e55?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/1.gravatar.com\/avatar\/1129916e1f4955bd632f27f836f64e55?s=96&d=mm&r=g\",\"caption\":\"dave\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Netexpertise - Diagramas de Gantt por Horas","description":"Microsoft Excel o Google Sheet - Cree diagramas de Gantt en Horas con Sparklines","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":"http:\/\/www.netexpertise.eu\/es\/diverso\/diagramas-de-gantt-por-horas-con-sparkline.html","og_locale":"es_ES","og_type":"article","og_title":"Netexpertise - Diagramas de Gantt por Horas","og_description":"Microsoft Excel o Google Sheet - Cree diagramas de Gantt en Horas con Sparklines","og_url":"http:\/\/www.netexpertise.eu\/es\/diverso\/diagramas-de-gantt-por-horas-con-sparkline.html","og_site_name":"Netexpertise","article_published_time":"2021-03-27T20:29:03+00:00","article_modified_time":"2022-01-03T22:14:56+00:00","author":"dave","twitter_card":"summary_large_image","twitter_creator":"@netexpertise","twitter_site":"@netexpertise","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/www.netexpertise.eu\/es\/diverso\/diagramas-de-gantt-por-horas-con-sparkline.html","url":"http:\/\/www.netexpertise.eu\/es\/diverso\/diagramas-de-gantt-por-horas-con-sparkline.html","name":"Netexpertise - Diagramas de Gantt por Horas","isPartOf":{"@id":"https:\/\/www.netexpertise.eu\/es\/#website"},"datePublished":"2021-03-27T20:29:03+00:00","dateModified":"2022-01-03T22:14:56+00:00","author":{"@id":"https:\/\/www.netexpertise.eu\/es\/#\/schema\/person\/27ec923be6625ac4b4bb86c8f0b12abf"},"description":"Microsoft Excel o Google Sheet - Cree diagramas de Gantt en Horas con Sparklines","breadcrumb":{"@id":"http:\/\/www.netexpertise.eu\/es\/diverso\/diagramas-de-gantt-por-horas-con-sparkline.html#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.netexpertise.eu\/es\/diverso\/diagramas-de-gantt-por-horas-con-sparkline.html"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/www.netexpertise.eu\/es\/diverso\/diagramas-de-gantt-por-horas-con-sparkline.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.netexpertise.eu\/es"},{"@type":"ListItem","position":2,"name":"Diagramas de Gantt por Horas"}]},{"@type":"WebSite","@id":"https:\/\/www.netexpertise.eu\/es\/#website","url":"https:\/\/www.netexpertise.eu\/es\/","name":"Netexpertise","description":"Sistemas \/ Redes \/ DevOps","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.netexpertise.eu\/es\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/www.netexpertise.eu\/es\/#\/schema\/person\/27ec923be6625ac4b4bb86c8f0b12abf","name":"dave","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.netexpertise.eu\/es\/#\/schema\/person\/image\/","url":"http:\/\/1.gravatar.com\/avatar\/1129916e1f4955bd632f27f836f64e55?s=96&d=mm&r=g","contentUrl":"http:\/\/1.gravatar.com\/avatar\/1129916e1f4955bd632f27f836f64e55?s=96&d=mm&r=g","caption":"dave"}}]}},"_links":{"self":[{"href":"http:\/\/www.netexpertise.eu\/es\/wp-json\/wp\/v2\/posts\/147"}],"collection":[{"href":"http:\/\/www.netexpertise.eu\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.netexpertise.eu\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.netexpertise.eu\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.netexpertise.eu\/es\/wp-json\/wp\/v2\/comments?post=147"}],"version-history":[{"count":8,"href":"http:\/\/www.netexpertise.eu\/es\/wp-json\/wp\/v2\/posts\/147\/revisions"}],"predecessor-version":[{"id":538,"href":"http:\/\/www.netexpertise.eu\/es\/wp-json\/wp\/v2\/posts\/147\/revisions\/538"}],"wp:attachment":[{"href":"http:\/\/www.netexpertise.eu\/es\/wp-json\/wp\/v2\/media?parent=147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.netexpertise.eu\/es\/wp-json\/wp\/v2\/categories?post=147"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.netexpertise.eu\/es\/wp-json\/wp\/v2\/tags?post=147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}