{"id":621,"date":"2018-02-09T03:32:09","date_gmt":"2018-02-09T03:32:09","guid":{"rendered":"http:\/\/www.fditf.com\/bi\/?p=621"},"modified":"2018-02-09T03:35:58","modified_gmt":"2018-02-09T03:35:58","slug":"el-grafico-treemap-en-googlecharts","status":"publish","type":"post","link":"https:\/\/www.fditf.com\/bi\/google-charts\/el-grafico-treemap-en-googlecharts\/","title":{"rendered":"El gr\u00e1fico #TreeMap en #GoogleCharts"},"content":{"rendered":"<p><script type=\"text\/javascript\" src=\"https:\/\/www.gstatic.com\/charts\/loader.js\"><\/script><br \/>\n<script type=\"text\/javascript\">\n      google.charts.load('current', {'packages':['treemap']});\n      google.charts.setOnLoadCallback(drawChart);\n      function drawChart() {\n        var data = google.visualization.arrayToDataTable([\n['Location', 'Parent', 'Number of formulas'],\n['Google Sheets Formulas',null,0],\n['Analizador','Google Sheets Formulas',6],\n['Base de datos','Google Sheets Formulas',12],\n['B\u00fasqueda','Google Sheets Formulas',15],\n['Estad\u00edstica','Google Sheets Formulas',24],\n['Estad\u00edsticas','Google Sheets Formulas',49],\n['Fecha','Google Sheets Formulas',23],\n['Filtro','Google Sheets Formulas',4],\n['Financiera','Google Sheets Formulas',9],\n['Finanzas','Google Sheets Formulas',35],\n['Google','Google Sheets Formulas',12],\n['Informaci\u00f3n','Google Sheets Formulas',12],\n['Ingenier\u00eda','Google Sheets Formulas',22],\n['L\u00f3gica','Google Sheets Formulas',1],\n['L\u00f3gicas','Google Sheets Formulas',6],\n['Matem\u00e1ticas','Google Sheets Formulas',60],\n['Matriz','Google Sheets Formulas',14],\n['Operador','Google Sheets Formulas',15],\n['Texto','Google Sheets Formulas',32],\n['CONVERTIR','Analizador',5],\n['TO_DATE','Analizador',5],\n['TO_DOLLARS','Analizador',5],\n['TO_PERCENT','Analizador',5],\n['TO_PURE_NUMBER','Analizador',5],\n['TO_TEXT','Analizador',5],\n['BDCONTAR','Base de datos',5],\n['BDCONTARA','Base de datos',25],\n['BDDESVEST','Base de datos',25],\n['BDDESVESTP','Base de datos',25],\n['BDEXTRAER','Base de datos',25],\n['BDMAX','Base de datos',25],\n['BDMIN','Base de datos',25],\n['BDPRODUCTO','Base de datos',25],\n['BDPROMEDIO','Base de datos',25],\n['BDSUMA','Base de datos',25],\n['BDVAR','Base de datos',25],\n['BDVARP','Base de datos',25],\n['BUSCAR','B\u00fasqueda',15],\n['BUSCARH','B\u00fasqueda',15],\n['BUSCARV','B\u00fasqueda',15],\n['COINCIDIR','B\u00fasqueda',15],\n['COLUMNA','B\u00fasqueda',15],\n['COLUMNAS','B\u00fasqueda',15],\n['DESREF','B\u00fasqueda',15],\n['DIRECCION','B\u00fasqueda',15],\n['ELEGIR','B\u00fasqueda',15],\n['FILA','B\u00fasqueda',15],\n['FILAS','B\u00fasqueda',15],\n['HIPERVINCULO','B\u00fasqueda',15],\n['IMPORTARDATOSDINAMICOS','B\u00fasqueda',15],\n['INDICE','B\u00fasqueda',15],\n['INDIRECTO','B\u00fasqueda',15],\n['CONTAR','Estad\u00edstica',45],\n['CONTARA','Estad\u00edstica',45],\n['DESVEST','Estad\u00edstica',45],\n['DESVESTA','Estad\u00edstica',45],\n['DESVESTP','Estad\u00edstica',45],\n['DESVESTPA','Estad\u00edstica',45],\n['DISTR.F','Estad\u00edstica',45],\n['DISTR.F.CD','Estad\u00edstica',45],\n['DISTR.F.N','Estad\u00edstica',45],\n['DISTR.T','Estad\u00edstica',45],\n['DISTR.T.INV','Estad\u00edstica',45],\n['INV.T','Estad\u00edstica',45],\n['INV.T.2C','Estad\u00edstica',45],\n['JERARQUIA.EQV','Estad\u00edstica',45],\n['JERARQUIA.MEDIA','Estad\u00edstica',45],\n['PROMEDIO.SI','Estad\u00edstica',45],\n['PROMEDIO.SI.CONJUNTO','Estad\u00edstica',45],\n['PRUEBA.T','Estad\u00edstica',45],\n['RANGO.PERCENTIL','Estad\u00edstica',45],\n['RANGO.PERCENTIL.EXC','Estad\u00edstica',45],\n['RANGO.PERCENTIL.INC','Estad\u00edstica',45],\n['VAR','Estad\u00edstica',45],\n['VARP','Estad\u00edstica',45],\n['VARPA','Estad\u00edstica',45],\n['BINOM.CRIT','Estad\u00edsticas',25],\n['COEF.DE.CORREL','Estad\u00edsticas',25],\n['COEFICIENTE.ASIMETRIA','Estad\u00edsticas',25],\n['COEFICIENTE.R2','Estad\u00edsticas',25],\n['COVAR','Estad\u00edsticas',25],\n['CUARTIL','Estad\u00edsticas',25],\n['CURTOSIS','Estad\u00edsticas',25],\n['DESVIA2','Estad\u00edsticas',25],\n['DESVPROM','Estad\u00edsticas',25],\n['DIST.WEIBULL','Estad\u00edsticas',25],\n['DISTR.BINOM','Estad\u00edsticas',25],\n['DISTR.EXP','Estad\u00edsticas',25],\n['DISTR.HIPERGEOM','Estad\u00edsticas',25],\n['DISTR.LOG.INV','Estad\u00edsticas',25],\n['DISTR.LOG.NORM','Estad\u00edsticas',25],\n['DISTR.NORM','Estad\u00edsticas',25],\n['DISTR.NORM.ESTAND','Estad\u00edsticas',25],\n['DISTR.NORM.ESTAND.INV','Estad\u00edsticas',25],\n['DISTR.NORM.INV','Estad\u00edsticas',25],\n['ERROR.TIPICO.XY','Estad\u00edsticas',25],\n['FISHER','Estad\u00edsticas',25],\n['INTERSECCION.EJE','Estad\u00edsticas',25],\n['INTERVALO.CONFIANZA','Estad\u00edsticas',25],\n['JERARQUIA','Estad\u00edsticas',25],\n['K.ESIMO.MAYOR','Estad\u00edsticas',25],\n['K.ESIMO.MENOR','Estad\u00edsticas',25],\n['MAX','Estad\u00edsticas',25],\n['MAXA','Estad\u00edsticas',25],\n['MEDIA.ACOTADA','Estad\u00edsticas',25],\n['MEDIA.ARMO','Estad\u00edsticas',25],\n['MEDIA.GEOM','Estad\u00edsticas',25],\n['MEDIANA','Estad\u00edsticas',25],\n['MIN','Estad\u00edsticas',25],\n['MINA','Estad\u00edsticas',25],\n['MODA','Estad\u00edsticas',25],\n['NEGBINOMDIST','Estad\u00edsticas',25],\n['NORMALIZACION','Estad\u00edsticas',25],\n['PEARSON','Estad\u00edsticas',25],\n['PENDIENTE','Estad\u00edsticas',25],\n['PERCENTIL','Estad\u00edsticas',25],\n['PERMUTACIONES','Estad\u00edsticas',25],\n['POISSON','Estad\u00edsticas',25],\n['PROBABILIDAD','Estad\u00edsticas',25],\n['PROMEDIO','Estad\u00edsticas',25],\n['PROMEDIOA','Estad\u00edsticas',25],\n['PRONOSTICO','Estad\u00edsticas',25],\n['PRUEBA.FISHER.INV','Estad\u00edsticas',25],\n['PRUEBA.Z','Estad\u00edsticas',25],\n['VARA','Estad\u00edsticas',25],\n['AHORA','Fecha',25],\n['A\u00d1O','Fecha',25],\n['DIA','Fecha',25],\n['DIA.LAB','Fecha',25],\n['DIAS.LAB','Fecha',25],\n['DIAS.LAB.INTL','Fecha',25],\n['DIAS360','Fecha',25],\n['DIASEM','Fecha',25],\n['FECHA','Fecha',25],\n['FECHA.MES','Fecha',25],\n['FECHANUMERO','Fecha',25],\n['FIN.MES','Fecha',25],\n['FRAC.A\u00d1O','Fecha',25],\n['HORA','Fecha',25],\n['HORANUMERO','Fecha',25],\n['HOY','Fecha',25],\n['ISO.NUM.DE.SEMANA','Fecha',25],\n['MES','Fecha',25],\n['MINUTO','Fecha',25],\n['NSHORA','Fecha',25],\n['NUM.DE.SEMANA','Fecha',25],\n['SEGUNDO','Fecha',25],\n['SIFECHA','Fecha',25],\n['FILTER','Filtro',25],\n['SORT','Filtro',25],\n['SORTN','Filtro',25],\n['UNIQUE','Filtro',25],\n['CANTIDAD.RECIBIDA','Financiera',25],\n['CUPON.DIAS','Financiera',25],\n['CUPON.DIAS.L2','Financiera',25],\n['CUPON.FECHA.L1','Financiera',25],\n['CUPON.FECHA.L2','Financiera',25],\n['DURACION','Financiera',25],\n['INT.ACUM','Financiera',25],\n['PRECIO.DESCUENTO','Financiera',25],\n['TASA.DESC','Financiera',25],\n['CUPON.DIAS.L1','Finanzas',25],\n['CUPON.NUM','Finanzas',25],\n['DB','Finanzas',25],\n['DDB','Finanzas',25],\n['DURACION.MODIF','Finanzas',25],\n['INT.ACUM.V','Finanzas',25],\n['INT.EFECTIVO','Finanzas',25],\n['LETRA.DE.TES.PRECIO','Finanzas',25],\n['LETRA.DE.TES.RENDTO','Finanzas',25],\n['LETRA.DE.TEST.EQV.A.BONO','Finanzas',25],\n['MONEDA.DEC','Finanzas',25],\n['MONEDA.FRAC','Finanzas',25],\n['NPER','Finanzas',25],\n['PAGO','Finanzas',25],\n['PAGO.INT.ENTRE','Finanzas',25],\n['PAGO.PRINC.ENTRE','Finanzas',25],\n['PAGOINT','Finanzas',25],\n['PAGOPRIN','Finanzas',25],\n['PRECIO','Finanzas',25],\n['PRECIO.VENCIMIENTO','Finanzas',25],\n['RENDTO','Finanzas',25],\n['RENDTO.DESC','Finanzas',25],\n['SLN','Finanzas',25],\n['SYD','Finanzas',25],\n['TASA','Finanzas',25],\n['TASA.INT','Finanzas',25],\n['TASA.NOMINAL','Finanzas',25],\n['TIR','Finanzas',25],\n['TIR.NO.PER','Finanzas',25],\n['TIRM','Finanzas',25],\n['VA','Finanzas',25],\n['VF','Finanzas',25],\n['VF.PLAN','Finanzas',25],\n['VNA','Finanzas',25],\n['VNA.NO.PER','Finanzas',25],\n['ARRAYFORMULA','Google',5],\n['DETECTLANGUAGE','Google',5],\n['GOOGLEFINANCE','Google',5],\n['GOOGLETRANSLATE','Google',5],\n['IMAGE','Google',5],\n['IMPORTDATA','Google',5],\n['IMPORTFEED','Google',5],\n['IMPORTHTML','Google',5],\n['IMPORTRANGE','Google',5],\n['IMPORTXML','Google',5],\n['QUERY','Google',5],\n['SPARKLINE','Google',5],\n['CELDA','Informaci\u00f3n',10],\n['ESBLANCO','Informaci\u00f3n',10],\n['ESERR','Informaci\u00f3n',10],\n['ESERROR','Informaci\u00f3n',10],\n['ESLOGICO','Informaci\u00f3n',10],\n['ESNOD','Informaci\u00f3n',10],\n['ESNOTEXTO','Informaci\u00f3n',10],\n['ESNUMERO','Informaci\u00f3n',10],\n['ESREF','Informaci\u00f3n',10],\n['ESTEXTO','Informaci\u00f3n',10],\n['ISEMAIL','Informaci\u00f3n',10],\n['ISFORMULA','Informaci\u00f3n',10],\n['ISURL','Informaci\u00f3n',10],\n['N','Informaci\u00f3n',10],\n['NOD','Informaci\u00f3n',10],\n['TIPO','Informaci\u00f3n',10],\n['TIPO.DE.ERROR','Informaci\u00f3n',10],\n['BIN.A.DEC','Ingenier\u00eda',15],\n['BIN.A.HEX','Ingenier\u00eda',15],\n['BIN.A.OCT','Ingenier\u00eda',15],\n['COMPLEJO','Ingenier\u00eda',15],\n['DEC.A.BIN','Ingenier\u00eda',15],\n['DEC.A.HEX','Ingenier\u00eda',15],\n['DEC.A.OCT','Ingenier\u00eda',15],\n['DELTA','Ingenier\u00eda',15],\n['HEX.A.BIN','Ingenier\u00eda',15],\n['HEX.A.DEC','Ingenier\u00eda',15],\n['HEX.A.OCT','Ingenier\u00eda',15],\n['IM.ABS','Ingenier\u00eda',15],\n['IM.CONJUGADA','Ingenier\u00eda',15],\n['IM.DIV','Ingenier\u00eda',15],\n['IM.PRODUCT','Ingenier\u00eda',15],\n['IM.REAL','Ingenier\u00eda',15],\n['IM.SUM','Ingenier\u00eda',15],\n['IM.SUSTR','Ingenier\u00eda',15],\n['IMAGINARIO','Ingenier\u00eda',15],\n['OCT.A.BIN','Ingenier\u00eda',15],\n['OCT.A.DEC','Ingenier\u00eda',15],\n['OCT.A.HEX','Ingenier\u00eda',15],\n['SI.ERROR','L\u00f3gica',15],\n['FALSO','L\u00f3gicas',15],\n['NO','L\u00f3gicas',15],\n['O','L\u00f3gicas',15],\n['SI','L\u00f3gicas',15],\n['VERDADERO','L\u00f3gicas',15],\n['Y','L\u00f3gicas',15],\n['ABS','Matem\u00e1ticas',15],\n['ACOS','Matem\u00e1ticas',15],\n['ACOSH','Matem\u00e1ticas',15],\n['ALEATORIO','Matem\u00e1ticas',15],\n['ALEATORIO.ENTRE','Matem\u00e1ticas',15],\n['ASENO','Matem\u00e1ticas',15],\n['ASENOH','Matem\u00e1ticas',15],\n['ATAN','Matem\u00e1ticas',15],\n['ATAN2','Matem\u00e1ticas',15],\n['ATANH','Matem\u00e1ticas',15],\n['COCIENTE','Matem\u00e1ticas',15],\n['COMBINAT','Matem\u00e1ticas',15],\n['CONTAR.BLANCO','Matem\u00e1ticas',15],\n['CONTAR.SI','Matem\u00e1ticas',15],\n['CONTAR.SI.CONJUNTO','Matem\u00e1ticas',15],\n['COS','Matem\u00e1ticas',15],\n['COSH','Matem\u00e1ticas',15],\n['COUNTUNIQUE','Matem\u00e1ticas',15],\n['ENTERO','Matem\u00e1ticas',15],\n['ES.IMPAR','Matem\u00e1ticas',15],\n['ES.PAR','Matem\u00e1ticas',15],\n['EXP','Matem\u00e1ticas',15],\n['FACT','Matem\u00e1ticas',15],\n['FACT.DOBLE','Matem\u00e1ticas',15],\n['FUN.ERROR.COMPL','Matem\u00e1ticas',15],\n['GAMMA.LN','Matem\u00e1ticas',15],\n['GRADOS','Matem\u00e1ticas',15],\n['LN','Matem\u00e1ticas',15],\n['LOG','Matem\u00e1ticas',15],\n['LOG10','Matem\u00e1ticas',15],\n['M.C.D','Matem\u00e1ticas',15],\n['M.C.M','Matem\u00e1ticas',15],\n['MULTINOMIAL','Matem\u00e1ticas',15],\n['MULTIPLO.INFERIOR','Matem\u00e1ticas',15],\n['MULTIPLO.SUPERIOR','Matem\u00e1ticas',15],\n['PI','Matem\u00e1ticas',15],\n['POTENCIA','Matem\u00e1ticas',15],\n['PRODUCTO','Matem\u00e1ticas',15],\n['RADIANES','Matem\u00e1ticas',15],\n['RAIZ','Matem\u00e1ticas',15],\n['RAIZ2PI','Matem\u00e1ticas',15],\n['REDOND.MULT','Matem\u00e1ticas',15],\n['REDONDEA.IMPAR','Matem\u00e1ticas',15],\n['REDONDEA.PAR','Matem\u00e1ticas',15],\n['REDONDEAR','Matem\u00e1ticas',15],\n['REDONDEAR.MAS','Matem\u00e1ticas',15],\n['REDONDEAR.MENOS','Matem\u00e1ticas',15],\n['RESIDUO','Matem\u00e1ticas',15],\n['SENO','Matem\u00e1ticas',15],\n['SENOH','Matem\u00e1ticas',15],\n['SIGNO','Matem\u00e1ticas',15],\n['SUBTOTALES','Matem\u00e1ticas',15],\n['SUMA','Matem\u00e1ticas',15],\n['SUMA.CUADRADOS','Matem\u00e1ticas',15],\n['SUMA.SERIES','Matem\u00e1ticas',15],\n['SUMAR.SI','Matem\u00e1ticas',15],\n['SUMAR.SI.CONJUNTO','Matem\u00e1ticas',15],\n['TAN','Matem\u00e1ticas',15],\n['TANH','Matem\u00e1ticas',15],\n['TRUNCAR','Matem\u00e1ticas',15],\n['ARRAY_CONSTRAIN','Matriz',15],\n['CRECIMIENTO','Matriz',15],\n['ESTIMACION.LINEAL','Matriz',15],\n['ESTIMACION.LOGARITMICA','Matriz',15],\n['FRECUENCIA','Matriz',15],\n['MDETERM','Matriz',15],\n['MINVERSA','Matriz',15],\n['MMULT','Matriz',15],\n['SUMAPRODUCTO','Matriz',15],\n['SUMAX2MASY2','Matriz',15],\n['SUMAX2MENOSY2','Matriz',15],\n['SUMAXMENOSY2','Matriz',15],\n['TENDENCIA','Matriz',15],\n['TRANSPONER','Matriz',15],\n['ADD','Operador',15],\n['CONCAT','Operador',15],\n['DIVIDE','Operador',15],\n['EQ','Operador',15],\n['GT','Operador',15],\n['GTE','Operador',15],\n['LT','Operador',15],\n['LTE','Operador',15],\n['MINUS','Operador',15],\n['MULTIPLY','Operador',15],\n['NE','Operador',15],\n['POW','Operador',15],\n['UMINUS','Operador',15],\n['UNARY_PERCENT','Operador',15],\n['UPLUS','Operador',15],\n['CARACTER','Texto',15],\n['CODIGO','Texto',15],\n['CONCATENAR','Texto',15],\n['DECIMAL','Texto',15],\n['DERECHA','Texto',15],\n['ENCONTRAR','Texto',15],\n['ENCONTRARB','Texto',15],\n['ESPACIOS','Texto',15],\n['EXTRAE','Texto',15],\n['HALLAR','Texto',15],\n['HALLARB','Texto',15],\n['IGUAL','Texto',15],\n['IZQUIERDA','Texto',15],\n['JOIN','Texto',15],\n['LARGO','Texto',15],\n['LIMPIAR','Texto',15],\n['MAYUSC','Texto',15],\n['MINUSC','Texto',15],\n['MONEDA','Texto',15],\n['NOMPROPIO','Texto',15],\n['NUMERO.ARABE','Texto',15],\n['NUMERO.ROMANO','Texto',15],\n['REEMPLAZAR','Texto',15],\n['REGEXEXTRACT','Texto',15],\n['REGEXMATCH','Texto',15],\n['REGEXREPLACE','Texto',15],\n['REPETIR','Texto',15],\n['SPLIT','Texto',15],\n['SUSTITUIR','Texto',15],\n['T','Texto',15],\n['TEXTO','Texto',15],\n['VALOR','Texto',15]\n        ]);\n        tree = new google.visualization.TreeMap(document.getElementById('chart_div'));\n        tree.draw(data, {\n          highlightOnMouseOver: true,\n          minColor: '#2f7ed1',\n          midColor: '#8ee5f3',\n          maxColor: '#dff3ed',\n          headerHeight: 25,\n          fontColor: 'black',\n          showScale: false\n        });\n      }\n    <\/script><\/p>\n<h1>El gr\u00e1fico TreeMap.<\/h1>\n<p>Se trata de una gr\u00e1fico estructurado y consiste de 3 datos b\u00e1sicos:<br \/>\n&#8211; Categor\u00eda;<br \/>\n&#8211; Categor\u00eda principal (&#8220;Parent&#8221;);<br \/>\n&#8211; Ponderaci\u00f3n (un valor seg\u00fan lo que quieras graficar). En este caso, el valor es el n\u00famero de f\u00f3rmulas por categor\u00eda.<\/p>\n<p><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"7741409798\"><\/ins><br \/>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/p>\n<h1>El ejemplo: todas las f\u00f3rmulas de Google Sheets<\/h1>\n<p>El gr\u00e1fico presentado aqu\u00ed contiene todas las f\u00f3rmulas de Google Sheets agrupadas por categor\u00eda. Para ver las f\u00f3rmulas de cada categor\u00eda, haz click en la que quieras ver y se desplegar\u00e1 el contenido. Para regresar a la categor\u00eda anterior, usa un click derecho en el encabezado del gr\u00e1fico.<\/p>\n<div id=\"chart_div\" style=\"width: 750px; height: 800px;\"><\/div>\n<p>Este gr\u00e1fico est\u00e1 elaborado con datos &#8220;hard coded&#8221; (dentro del c\u00f3digo), puedes intentar algunos cambios editando el JSFiddle (click en el bot\u00f3n superior derecho del recuadro inferior). M\u00e1s detalles de Google Charts en este enlace: <a href=\"https:\/\/developers.google.com\/chart\/interactive\/docs\/gallery\/treemap\" target=\"_blank\" rel=\"noopener\">ir a la referencia<\/a>. La lista completa y detallada de las f\u00f3rmulas la puedes consultar en este enlace: <a href=\"https:\/\/www.fditf.com\/bi\/google-sheets\/guia-completa-de-formulas-de-googlesheets\/\" target=\"_blank\" rel=\"noopener\">ver lista<\/a>.<\/p>\n<p><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script><br \/>\n<!-- RegularPostBottom --><br \/>\n<ins class=\"adsbygoogle\" style=\"display: block;\" data-ad-client=\"ca-pub-9033709093144000\" data-ad-slot=\"2196072090\" data-ad-format=\"auto\"><\/ins><br \/>\n<script>\n(adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><br \/>\n<script async src=\"\/\/jsfiddle.net\/5y6b06ga\/embed\/html,result\/\"><\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>El gr\u00e1fico TreeMap. Se trata de una gr\u00e1fico estructurado y consiste de 3 datos b\u00e1sicos: &#8211; Categor\u00eda; &#8211; Categor\u00eda principal (&#8220;Parent&#8221;); &#8211; Ponderaci\u00f3n (un valor seg\u00fan lo que quieras graficar). En este caso, el valor es el n\u00famero de f\u00f3rmulas <a href=\"https:\/\/www.fditf.com\/bi\/google-charts\/el-grafico-treemap-en-googlecharts\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":629,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[82],"tags":[84,90],"class_list":["post-621","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-charts","tag-google-charts","tag-treemap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>El gr\u00e1fico #TreeMap en #GoogleCharts - Business Intelligence MX<\/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:\/\/www.fditf.com\/bi\/google-charts\/el-grafico-treemap-en-googlecharts\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"El gr\u00e1fico #TreeMap en #GoogleCharts - Business Intelligence MX\" \/>\n<meta property=\"og:description\" content=\"El gr\u00e1fico TreeMap. Se trata de una gr\u00e1fico estructurado y consiste de 3 datos b\u00e1sicos: &#8211; Categor\u00eda; &#8211; Categor\u00eda principal (&#8220;Parent&#8221;); &#8211; Ponderaci\u00f3n (un valor seg\u00fan lo que quieras graficar). En este caso, el valor es el n\u00famero de f\u00f3rmulas Read More ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fditf.com\/bi\/google-charts\/el-grafico-treemap-en-googlecharts\/\" \/>\n<meta property=\"og:site_name\" content=\"Business Intelligence MX\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelyfinanzasmx\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-09T03:32:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-02-09T03:35:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/header.png\" \/>\n\t<meta property=\"og:image:width\" content=\"726\" \/>\n\t<meta property=\"og:image:height\" content=\"419\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"V\u00edctor Urbina\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@excelfinanzasMX\" \/>\n<meta name=\"twitter:site\" content=\"@excelfinanzasMX\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"V\u00edctor Urbina\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-charts\\\/el-grafico-treemap-en-googlecharts\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-charts\\\/el-grafico-treemap-en-googlecharts\\\/\"},\"author\":{\"name\":\"V\u00edctor Urbina\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/person\\\/ff30cbd17d9f746cacb687d5332924c5\"},\"headline\":\"El gr\u00e1fico #TreeMap en #GoogleCharts\",\"datePublished\":\"2018-02-09T03:32:09+00:00\",\"dateModified\":\"2018-02-09T03:35:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-charts\\\/el-grafico-treemap-en-googlecharts\\\/\"},\"wordCount\":181,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-charts\\\/el-grafico-treemap-en-googlecharts\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/header.png\",\"keywords\":[\"Google Charts\",\"TreeMap\"],\"articleSection\":[\"Google Charts\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-charts\\\/el-grafico-treemap-en-googlecharts\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-charts\\\/el-grafico-treemap-en-googlecharts\\\/\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-charts\\\/el-grafico-treemap-en-googlecharts\\\/\",\"name\":\"El gr\u00e1fico #TreeMap en #GoogleCharts - Business Intelligence MX\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-charts\\\/el-grafico-treemap-en-googlecharts\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-charts\\\/el-grafico-treemap-en-googlecharts\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/header.png\",\"datePublished\":\"2018-02-09T03:32:09+00:00\",\"dateModified\":\"2018-02-09T03:35:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-charts\\\/el-grafico-treemap-en-googlecharts\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-charts\\\/el-grafico-treemap-en-googlecharts\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-charts\\\/el-grafico-treemap-en-googlecharts\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/header.png\",\"contentUrl\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/header.png\",\"width\":726,\"height\":419},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/google-charts\\\/el-grafico-treemap-en-googlecharts\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"El gr\u00e1fico #TreeMap en #GoogleCharts\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#website\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\",\"name\":\"Business Intelligence MX\",\"description\":\" \",\"publisher\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#organization\",\"name\":\"FDI Tecnolog\u00eda y Finanzas, SAS de CV\",\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"http:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/logo.png\",\"contentUrl\":\"http:\\\/\\\/www.fditf.com\\\/bi\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/logo.png\",\"width\":275,\"height\":168,\"caption\":\"FDI Tecnolog\u00eda y Finanzas, SAS de CV\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/excelyfinanzasmx\\\/\",\"https:\\\/\\\/x.com\\\/excelfinanzasMX\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/#\\\/schema\\\/person\\\/ff30cbd17d9f746cacb687d5332924c5\",\"name\":\"V\u00edctor Urbina\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g\",\"caption\":\"V\u00edctor Urbina\"},\"url\":\"https:\\\/\\\/www.fditf.com\\\/bi\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"El gr\u00e1fico #TreeMap en #GoogleCharts - Business Intelligence MX","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.fditf.com\/bi\/google-charts\/el-grafico-treemap-en-googlecharts\/","og_locale":"en_US","og_type":"article","og_title":"El gr\u00e1fico #TreeMap en #GoogleCharts - Business Intelligence MX","og_description":"El gr\u00e1fico TreeMap. Se trata de una gr\u00e1fico estructurado y consiste de 3 datos b\u00e1sicos: &#8211; Categor\u00eda; &#8211; Categor\u00eda principal (&#8220;Parent&#8221;); &#8211; Ponderaci\u00f3n (un valor seg\u00fan lo que quieras graficar). En este caso, el valor es el n\u00famero de f\u00f3rmulas Read More ...","og_url":"https:\/\/www.fditf.com\/bi\/google-charts\/el-grafico-treemap-en-googlecharts\/","og_site_name":"Business Intelligence MX","article_publisher":"https:\/\/www.facebook.com\/excelyfinanzasmx\/","article_published_time":"2018-02-09T03:32:09+00:00","article_modified_time":"2018-02-09T03:35:58+00:00","og_image":[{"width":726,"height":419,"url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/header.png","type":"image\/png"}],"author":"V\u00edctor Urbina","twitter_card":"summary_large_image","twitter_creator":"@excelfinanzasMX","twitter_site":"@excelfinanzasMX","twitter_misc":{"Written by":"V\u00edctor Urbina","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fditf.com\/bi\/google-charts\/el-grafico-treemap-en-googlecharts\/#article","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/google-charts\/el-grafico-treemap-en-googlecharts\/"},"author":{"name":"V\u00edctor Urbina","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5"},"headline":"El gr\u00e1fico #TreeMap en #GoogleCharts","datePublished":"2018-02-09T03:32:09+00:00","dateModified":"2018-02-09T03:35:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/google-charts\/el-grafico-treemap-en-googlecharts\/"},"wordCount":181,"commentCount":0,"publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/google-charts\/el-grafico-treemap-en-googlecharts\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/header.png","keywords":["Google Charts","TreeMap"],"articleSection":["Google Charts"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fditf.com\/bi\/google-charts\/el-grafico-treemap-en-googlecharts\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fditf.com\/bi\/google-charts\/el-grafico-treemap-en-googlecharts\/","url":"https:\/\/www.fditf.com\/bi\/google-charts\/el-grafico-treemap-en-googlecharts\/","name":"El gr\u00e1fico #TreeMap en #GoogleCharts - Business Intelligence MX","isPartOf":{"@id":"https:\/\/www.fditf.com\/bi\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fditf.com\/bi\/google-charts\/el-grafico-treemap-en-googlecharts\/#primaryimage"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/google-charts\/el-grafico-treemap-en-googlecharts\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/header.png","datePublished":"2018-02-09T03:32:09+00:00","dateModified":"2018-02-09T03:35:58+00:00","breadcrumb":{"@id":"https:\/\/www.fditf.com\/bi\/google-charts\/el-grafico-treemap-en-googlecharts\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fditf.com\/bi\/google-charts\/el-grafico-treemap-en-googlecharts\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/google-charts\/el-grafico-treemap-en-googlecharts\/#primaryimage","url":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/header.png","contentUrl":"https:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/02\/header.png","width":726,"height":419},{"@type":"BreadcrumbList","@id":"https:\/\/www.fditf.com\/bi\/google-charts\/el-grafico-treemap-en-googlecharts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fditf.com\/bi\/"},{"@type":"ListItem","position":2,"name":"El gr\u00e1fico #TreeMap en #GoogleCharts"}]},{"@type":"WebSite","@id":"https:\/\/www.fditf.com\/bi\/#website","url":"https:\/\/www.fditf.com\/bi\/","name":"Business Intelligence MX","description":" ","publisher":{"@id":"https:\/\/www.fditf.com\/bi\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fditf.com\/bi\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.fditf.com\/bi\/#organization","name":"FDI Tecnolog\u00eda y Finanzas, SAS de CV","url":"https:\/\/www.fditf.com\/bi\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/logo\/image\/","url":"http:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/logo.png","contentUrl":"http:\/\/www.fditf.com\/bi\/wp-content\/uploads\/2018\/01\/logo.png","width":275,"height":168,"caption":"FDI Tecnolog\u00eda y Finanzas, SAS de CV"},"image":{"@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelyfinanzasmx\/","https:\/\/x.com\/excelfinanzasMX"]},{"@type":"Person","@id":"https:\/\/www.fditf.com\/bi\/#\/schema\/person\/ff30cbd17d9f746cacb687d5332924c5","name":"V\u00edctor Urbina","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/82af8163ed1a344c7fe2a709c29fea445dbf06cd4321465c3fdcc146da0403c4?s=96&d=mm&r=g","caption":"V\u00edctor Urbina"},"url":"https:\/\/www.fditf.com\/bi\/author\/admin\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/621","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/comments?post=621"}],"version-history":[{"count":19,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/621\/revisions"}],"predecessor-version":[{"id":642,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/posts\/621\/revisions\/642"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media\/629"}],"wp:attachment":[{"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/media?parent=621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/categories?post=621"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fditf.com\/bi\/wp-json\/wp\/v2\/tags?post=621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}