{"id":940,"date":"2019-08-21T05:53:31","date_gmt":"2019-08-21T05:53:31","guid":{"rendered":"http:\/\/pt.repairmsexcel.com\/blog\/?p=940"},"modified":"2021-07-31T11:51:11","modified_gmt":"2021-07-31T11:51:11","slug":"excel-2019-funcoes-charts","status":"publish","type":"post","link":"https:\/\/pt.repairmsexcel.com\/blog\/excel-2019-funcoes-charts","title":{"rendered":"Excel 2019 Novas fun\u00e7\u00f5es e gr\u00e1ficos que voc\u00ea deve aprender!"},"content":{"rendered":"<div class=\"cb46ff181ce6eef70c33ac8d8c9c88c4\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">O <strong>Microsoft Office 2019<\/strong> acaba de ser lan\u00e7ado e, entre seus aplicativos, o <strong>Excel 2019<\/strong> \u00e9 o que conta com uma ampla cole\u00e7\u00e3o de recursos e habilidades mais recentes e desenvolvidos.<\/p>\n<p style=\"text-align: justify;\">Bem, muitas das melhorias est\u00e3o dentro dos recursos como <strong>Poder\u00a0 Piv\u00f4 e Obter e transformar.<\/strong> Apesar disso, muitas <strong>novas fun\u00e7\u00f5es e tipos de gr\u00e1ficos<\/strong> tamb\u00e9m est\u00e3o dispon\u00edveis no Excel 2019 para facilitar o trabalho para os usu\u00e1rios comuns e para o <span style=\"color: #339966;\"><a style=\"color: #339966;\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/30-dicas-a-mestre-ms-excel\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>mestre Microsoft Excel<\/strong>.<\/a><\/span><\/p>\n<p style=\"text-align: justify;\">Neste artigo, vou descrever algumas das fun\u00e7\u00f5es aprimoradas e mais recentes do Excel 2019 e os tipos de gr\u00e1ficos descrevem como us\u00e1-los.<!--more--><\/p>\n<p style=\"text-align: justify;\">Portanto, sem perder tempo, vamos descobrir as <strong>\u00faltimas fun\u00e7\u00f5es do Excel 2019<\/strong> e us\u00e1-las como um profissional.<\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: center;\"><span style=\"color: #339966;\"><strong><u>Lista de Excel 2019 fun\u00e7\u00f5es :<\/u><\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\"><strong><u>\u00a0<\/u><\/strong><\/p>\n<h3 style=\"text-align: justify;\"><strong><u>Excel 2019 Fun\u00e7\u00f5es de texto<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\"><strong>\u00a0<\/strong><\/p>\n<h3 style=\"text-align: justify;\">\u00a0 1: CONCAT<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Esta nova fun\u00e7\u00e3o do Excel 2019 \u00e9 como <strong>CONCATENAR<\/strong>, mas melhor que isso. Isso \u00e9 mais curto e f\u00e1cil de digitar. Tamb\u00e9m suporta posi\u00e7\u00f5es de alcance, para refer\u00eancias de c\u00e9lula.<\/p>\n<p style=\"text-align: justify;\">Por exemplo:<\/p>\n<table class=\"spreadsheet-centered\" style=\"height: 61px;\" width=\"337\">\n<tbody>\n<tr>\n<th class=\"spreadsheet-margin\"><\/th>\n<th class=\"spreadsheet\">A<\/th>\n<th class=\"spreadsheet\">B<\/th>\n<th class=\"spreadsheet\">C<\/th>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">1<\/th>\n<td class=\"spreadsheet\">C:\\<\/td>\n<td class=\"spreadsheet\">Users\\<\/td>\n<td class=\"spreadsheet\">Teff<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\">Usando as cadeias de texto da fun\u00e7\u00e3o Concat nas c\u00e9lulas <strong>A1, B1 e C1<\/strong> s\u00e3o unidas.<\/p>\n<p style=\"text-align: justify;\"><strong>= CONCAT (A1: C1)<\/strong><\/p>\n<p style=\"text-align: justify;\">que fornece a string de texto resultante <strong>C: \\ Users \\ Teff<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">2: TEXTJOIN<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Esta fun\u00e7\u00e3o do Excel 2019 une v\u00e1rios intervalos de texto e cada item \u00e9 dividido por um delimitador especificado por voc\u00ea.<\/p>\n<p style=\"text-align: justify;\"><strong>Por exemplo:<\/strong><\/p>\n<table style=\"height: 127px;\" width=\"244\">\n<tbody>\n<tr>\n<td><strong>\u00a0<\/strong><\/td>\n<td><strong>A<\/strong><\/td>\n<td><strong>B<\/strong><\/td>\n<td><strong>C<\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong>1<\/strong><\/td>\n<td>C:<\/td>\n<td>Workers<\/td>\n<td>Reff<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\">Usando a fun\u00e7\u00e3o Textjoin, as strings de texto fornecidas no exemplo acima s\u00e3o combinadas e separadas pelo delimitador \u201c\\\u201d.<\/p>\n<p style=\"text-align: justify;\"><strong>= TEXTJOIN (\u201c\\\u201d, VERDADEIRO, A1: C1)<\/strong><\/p>\n<p style=\"text-align: justify;\">E o resultado \u00e9 <strong>C: \\ Workers \\ Reff<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><u>\u00a0<\/u><\/strong><\/p>\n<h3 style=\"text-align: justify;\"><strong><u>Excel 2019 Fun\u00e7\u00f5es estat\u00edsticas<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\"><strong>\u00a0<\/strong><\/p>\n<h3 style=\"text-align: justify;\">3: MAXIFS<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">A fun\u00e7\u00e3o MAXIFS na lista fornece o maior n\u00famero de um intervalo de n\u00fameros de acordo com os crit\u00e9rios \u00fanicos ou m\u00faltiplos especificados.<\/p>\n<p style=\"text-align: justify;\"><strong>Vamos descrever melhor com o exemplo dado:<\/strong><\/p>\n<table class=\"spreadsheet-centered\" style=\"height: 297px;\" width=\"270\">\n<tbody>\n<tr>\n<th class=\"spreadsheet-margin\"><\/th>\n<th class=\"spreadsheet\">A<\/th>\n<th class=\"spreadsheet\">B<\/th>\n<th class=\"spreadsheet\">C<\/th>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">1<\/th>\n<td class=\"spreadsheet\"><strong>Alunas<\/strong><\/td>\n<td class=\"spreadsheet\"><b>Set 1<\/b><\/td>\n<td class=\"spreadsheet\"><b>Score<\/b><\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">2<\/th>\n<td class=\"spreadsheet\">Tina<\/td>\n<td class=\"spreadsheet-num\">1<\/td>\n<td class=\"spreadsheet-num\">58%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">3<\/th>\n<td class=\"spreadsheet\">Alex<\/td>\n<td class=\"spreadsheet-num\">2<\/td>\n<td class=\"spreadsheet-num\">87%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">4<\/th>\n<td class=\"spreadsheet\">Henry<\/td>\n<td class=\"spreadsheet-num\">2<\/td>\n<td class=\"spreadsheet-num\">74%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">5<\/th>\n<td class=\"spreadsheet\">John<\/td>\n<td class=\"spreadsheet-num\">1<\/td>\n<td class=\"spreadsheet-num\">41%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">6<\/th>\n<td class=\"spreadsheet\">Johnson<\/td>\n<td class=\"spreadsheet-num\">1<\/td>\n<td class=\"spreadsheet-num\">79%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">7<\/th>\n<td class=\"spreadsheet\">Emmy<\/td>\n<td class=\"spreadsheet-num\">1<\/td>\n<td class=\"spreadsheet-num\">66%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">8<\/th>\n<td class=\"spreadsheet\">Jacob<\/td>\n<td class=\"spreadsheet-num\">2<\/td>\n<td class=\"spreadsheet-num\">90%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">9<\/th>\n<td class=\"spreadsheet\">George<\/td>\n<td class=\"spreadsheet-num\">2<\/td>\n<td class=\"spreadsheet-num\">73%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\">Usando a fun\u00e7\u00e3o Maxifs, o jogo m\u00e1ximo marcado no <strong>Conjunto 1<\/strong> \u00e9 facilmente encontrado.<\/p>\n<p style=\"text-align: justify;\"><strong>= MAXIFS (C2: C9, B2: B9, 1)<\/strong><\/p>\n<p style=\"text-align: justify;\">E o resultado \u00e9 <strong>79%<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">4: MINIFS<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Essa fun\u00e7\u00e3o <strong>MINIF<\/strong>s \u00e9 semelhante a<strong> MAXIFs<\/strong>, mas \u00e9 usada para retornar o menor n\u00famero de intervalo, de acordo com um ou mais crit\u00e9rios.<\/p>\n<p style=\"text-align: justify;\"><strong>Descreva-o com o exemplo:<\/strong><\/p>\n<table class=\"spreadsheet-centered\" style=\"height: 297px;\" width=\"270\">\n<tbody>\n<tr>\n<th class=\"spreadsheet-margin\"><\/th>\n<th class=\"spreadsheet\">A<\/th>\n<th class=\"spreadsheet\">B<\/th>\n<th class=\"spreadsheet\">C<\/th>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">1<\/th>\n<td class=\"spreadsheet\"><strong>Alunas<\/strong><\/td>\n<td class=\"spreadsheet\"><b>Set 1<\/b><\/td>\n<td class=\"spreadsheet\"><b>Score<\/b><\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">2<\/th>\n<td class=\"spreadsheet\">Tina<\/td>\n<td class=\"spreadsheet-num\">1<\/td>\n<td class=\"spreadsheet-num\">58%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">3<\/th>\n<td class=\"spreadsheet\">Alex<\/td>\n<td class=\"spreadsheet-num\">2<\/td>\n<td class=\"spreadsheet-num\">87%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">4<\/th>\n<td class=\"spreadsheet\">Henry<\/td>\n<td class=\"spreadsheet-num\">2<\/td>\n<td class=\"spreadsheet-num\">74%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">5<\/th>\n<td class=\"spreadsheet\">John<\/td>\n<td class=\"spreadsheet-num\">1<\/td>\n<td class=\"spreadsheet-num\">41%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">6<\/th>\n<td class=\"spreadsheet\">Johnson<\/td>\n<td class=\"spreadsheet-num\">1<\/td>\n<td class=\"spreadsheet-num\">79%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">7<\/th>\n<td class=\"spreadsheet\">Emmy<\/td>\n<td class=\"spreadsheet-num\">1<\/td>\n<td class=\"spreadsheet-num\">66%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">8<\/th>\n<td class=\"spreadsheet\">Jacob<\/td>\n<td class=\"spreadsheet-num\">2<\/td>\n<td class=\"spreadsheet-num\">90%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">9<\/th>\n<td class=\"spreadsheet\">George<\/td>\n<td class=\"spreadsheet-num\">2<\/td>\n<td class=\"spreadsheet-num\">73%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\">Voc\u00ea pode verificar a pontua\u00e7\u00e3o m\u00ednima do jogo registrada no <strong>conjunto 2<\/strong> usando a fun\u00e7\u00e3o Minifs<\/p>\n<p style=\"text-align: justify;\"><strong>= MINIFS (C2: C9, B2: B9, 2)<\/strong><\/p>\n<p style=\"text-align: justify;\">Voc\u00ea pode ver o resultado em <strong>73%<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\"><strong><u>Excel 2019 Fun\u00e7\u00f5es l\u00f3gicas<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\"><strong>\u00a0<\/strong><\/p>\n<h3 style=\"text-align: justify;\">5: IFS<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Esta \u00e9 a vers\u00e3o mais recente da fun\u00e7\u00e3o <strong>IF<\/strong>. A fun\u00e7\u00e3o IFS permite que os usu\u00e1rios testem as condi\u00e7\u00f5es na ordem especificada e retornam resultados correspondentes \u00e0 primeira condi\u00e7\u00e3o que estimam como <strong>TRUE<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><strong>Vamos descrev\u00ea-lo melhor com o exemplo<\/strong><\/p>\n<table style=\"height: 50px;\" width=\"262\">\n<tbody>\n<tr>\n<td><strong>\u00a0<\/strong><\/td>\n<td><strong>A<\/strong><\/td>\n<td><strong>B<\/strong><\/td>\n<td><strong>C<\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong>1<\/strong><\/td>\n<td>40<\/td>\n<td>0<\/td>\n<td>2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\">A fun\u00e7\u00e3o IFS poderia ser utilizada para dividir o valor na <strong>c\u00e9lula A1<\/strong> pelo primeiro valor diferente de zero nas c\u00e9lulas <strong>B1-C1: = IFS (B1 &lt;&gt; 0, A1 \/ B1, C1 &lt;&gt; 0, A1 \/ C1)<\/strong><\/p>\n<p style=\"text-align: justify;\">Isso dar\u00e1 o resultado <strong>20.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">6: SWITCH<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Esta \u00faltima fun\u00e7\u00e3o do Excel 2019 compara o n\u00famero com os valores fornecidos e retorna o primeiro resultado correspondente. E se nenhum resultado corresponder, ent\u00e3o <strong>&#8220;else&#8221;<\/strong> \u00e9 retornado<\/p>\n<p style=\"text-align: justify;\"><strong>Vamos descrever melhor com o exemplo:<\/strong><\/p>\n<table class=\"spreadsheet-centered\" style=\"height: 60px;\" width=\"267\">\n<tbody>\n<tr>\n<th class=\"spreadsheet-margin\"><\/th>\n<th class=\"spreadsheet\">A<\/th>\n<th class=\"spreadsheet\">B<\/th>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">1<\/th>\n<td class=\"spreadsheet-num\">2<\/td>\n<td class=\"spreadsheet\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\">Aqui, a fun\u00e7\u00e3o de troca \u00e9 usada para retornar uma fruta relacionada ao n\u00famero na <strong>c\u00e9lula A1<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>= SWITCH (A1, 1, \u201cApple\u201d, 2, \u201cGrapes\u201d, 3, \u201cMango\u201d, 4, \u201cStrawberry\u201d)<\/strong><\/p>\n<p style=\"text-align: justify;\">E o resultado em <strong>&#8220;Mango&#8221;<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: center;\"><span style=\"color: #339966;\"><strong><u>Excel 2019 novos gr\u00e1ficos para dados de exibi\u00e7\u00e3o visual<\/u><\/strong><\/span><\/h2>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Assim como as fun\u00e7\u00f5es do Excel 2019 tamb\u00e9m haviam comprado novos gr\u00e1ficos. Ent\u00e3o, aprenda <span style=\"color: #339966;\"><a style=\"color: #339966;\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/usar-etiquetas-de-dados-dinamicas-para-criar-graficos-interativos-do-excel\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>como criar gr\u00e1ficos interativos do Excel<\/strong><\/a><\/span> e apresentar os dados de uma maneira nova.<\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">1: Sunburst:<\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-947\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-sunubrst-chart.jpg\" alt=\"\" width=\"535\" height=\"402\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-sunubrst-chart.jpg 535w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-sunubrst-chart-300x225.jpg 300w\" sizes=\"auto, (max-width: 535px) 100vw, 535px\" \/><\/p>\n<p style=\"text-align: justify;\">O gr\u00e1fico Sunburst \u00e9 um gr\u00e1fico de v\u00e1rios n\u00edveis e exibe dados hier\u00e1rquicos. Neste gr\u00e1fico, o c\u00edrculo interno inclui categorias de n\u00edvel superior e o c\u00edrculo de sa\u00edda mostra subcategorias e, depois disso, o c\u00edrculo \u00e9 assim por diante.<\/p>\n<p style=\"text-align: justify;\">Esses gr\u00e1ficos s\u00e3o os melhores para exibir os relacionamentos entre as principais categorias e subcategorias.<\/p>\n<p style=\"text-align: justify;\"><strong>Aqui sabe como criar um gr\u00e1fico Sunburst:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Na planilha, certifique-se de que os dados estejam organizados no m\u00e9todo hier\u00e1rquico.<\/li>\n<li>Em seguida, escolha o intervalo de todos os dados, com todos os n\u00edveis de r\u00f3tulos.<\/li>\n<li>Em seguida, clique em <strong>Inserir<\/strong>, depois em Gr\u00e1fico de <strong>hierarquia<\/strong> e em seguida<\/li>\n<li>Agora formate o gr\u00e1fico como voc\u00ea deseja<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">2: Treemap<\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-946\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-treemap-chart.jpg\" alt=\"\" width=\"535\" height=\"327\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-treemap-chart.jpg 535w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-treemap-chart-300x183.jpg 300w\" sizes=\"auto, (max-width: 535px) 100vw, 535px\" \/><\/p>\n<p style=\"text-align: justify;\">O gr\u00e1fico treemap gera uma visualiza\u00e7\u00e3o de dados hier\u00e1rquicos com as categorias principais (<strong>ramifica\u00e7\u00f5es de \u00e1rvore<\/strong>) exibidas como ret\u00e2ngulos, incluindo subcategorias, apresentadas como pequenos ret\u00e2ngulos agrupados nos grandes.<\/p>\n<p style=\"text-align: justify;\">Por isso, ele permite que os usu\u00e1rios comparem facilmente categorias de primeiro n\u00edvel e tamanhos de subcategorias \u00e0 primeira vista.<\/p>\n<p style=\"text-align: justify;\"><strong>Etapas para criar um gr\u00e1fico de treemap:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Assim como o sunburst, garanta que os dados sejam organizados de forma hier\u00e1rquica na planilha<\/li>\n<li>Escolha o intervalo de dados completo, com n\u00edveis inteiros de r\u00f3tulos que voc\u00ea precisa incluir.<\/li>\n<li>Em seguida, clique em <strong>Inserir<\/strong>, depois em <strong>Gr\u00e1fico de hierarquia<\/strong> e<\/li>\n<li>E formatar gr\u00e1fico conforme seu desejo.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">3: Waterfall Charts<\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-945\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-waterfall-chart.jpg\" alt=\"\" width=\"535\" height=\"340\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-waterfall-chart.jpg 535w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-waterfall-chart-300x191.jpg 300w\" sizes=\"auto, (max-width: 535px) 100vw, 535px\" \/><\/p>\n<p style=\"text-align: justify;\">No Excel 2019, o gr\u00e1fico em cascata \u00e9 adicionado \u00e0 demanda dos usu\u00e1rios. Bem, na vers\u00e3o anterior do Excel, fazer esse tipo de gr\u00e1fico \u00e9 realmente demorado e requer uma solu\u00e7\u00e3o alternativa.<\/p>\n<p style=\"text-align: justify;\">Mas no Excel 2019, a cascata \u00e9 apresentada como um tipo de gr\u00e1fico e pode ser criada facilmente em poucos cliques. Este gr\u00e1fico \u00e9 o melhor para apresentar o crescente resultado de valores maiores e menores.<\/p>\n<p style=\"text-align: justify;\"><strong>Ent\u00e3o, aqui siga os passos para criar o gr\u00e1fico em cascata:<\/strong><\/p>\n<ol style=\"text-align: justify;\">\n<li>Para garantir que seus dados s\u00e3o organizados na ordem como deveria aparecer no gr\u00e1fico. Ent\u00e3o, se necess\u00e1rio, reordene primeiro<\/li>\n<li>Agora, escolha os dados para apresentar no gr\u00e1fico, com os r\u00f3tulos de dados.<\/li>\n<li>Clique em Insert e depois em <strong>Inserir gr\u00e1fico de cascata, estoque, funil, superf\u00edcie ou radar.<\/strong><\/li>\n<li>Clique em Cachoeira.<\/li>\n<li>E formate o gr\u00e1fico conforme necess\u00e1rio.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">4: Box and Whisker Charts<\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-944\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-box-whisker-chart.jpg\" alt=\"\" width=\"535\" height=\"348\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-box-whisker-chart.jpg 535w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-box-whisker-chart-300x195.jpg 300w\" sizes=\"auto, (max-width: 535px) 100vw, 535px\" \/><\/p>\n<p style=\"text-align: justify;\">O <strong>Box and Whisker Charts \u00e9 como um histograma, apresenta<\/strong> frequ\u00eancias no conjunto de dados. Mas \u00e9 usado para an\u00e1lise profunda do que um histograma.<\/p>\n<p style=\"text-align: justify;\"><strong>Nota:<\/strong> Um quartil \u00e9 um quarto dos pontos de dados<\/p>\n<p style=\"text-align: justify;\">Isso pr\u00e9-calcula os dados, dividindo-os nos quartis. E os dois quartis m\u00e9dios (2 e 3) s\u00e3o representados por uma caixa e os quartis acima e abaixo (1 e 4) s\u00e3o representados por <strong>linhas verticais <\/strong>chamadas bigodes, que s\u00e3o projetadas da parte superior e inferior da caixa.<\/p>\n<p style=\"text-align: justify;\"><strong>Agora siga os passos para criar um gr\u00e1fico de caixa e bigode:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Na planilha, organize os conjuntos de dados em colunas com uma \u00fanica coluna para cada conjunto de dados.<\/li>\n<li>Do que colocar etiquetas de texto mostrando os conjuntos de dados acima dos dados.<\/li>\n<li>E escolha os conjuntos de <strong>dados e os r\u00f3tulos das colunas<\/strong>.<\/li>\n<li>Clique em Inserir e <strong>Inserir Gr\u00e1fico Estat\u00edstico e Box e Whisker.<\/strong><\/li>\n<li>E por \u00faltimo, formate o gr\u00e1fico<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">E, dessa maneira, a caixa do Excel 2019 e o gr\u00e1fico de bigodes s\u00e3o criados facilmente.<\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">5: Filled Map Charts<\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-943\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-filled-map.jpg\" alt=\"\" width=\"535\" height=\"256\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-filled-map.jpg 535w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-filled-map-300x144.jpg 300w\" sizes=\"auto, (max-width: 535px) 100vw, 535px\" \/><\/p>\n<p style=\"text-align: justify;\">Na vers\u00e3o anterior do Excel, criar um mapa com dados num\u00e9ricos \u00e9 muito dif\u00edcil tomar um tempo. Portanto, o Excel 2019 tornou mais f\u00e1cil para os usu\u00e1rios com o tipo de <strong>gr\u00e1fico de mapa preenchido.<\/strong><\/p>\n<p style=\"text-align: justify;\">Isso \u00e9 usado para distinguir <strong>pa\u00edses, estados \/ prov\u00edncias e c\u00f3digos postais<\/strong> em r\u00f3tulos de dados e mostra o mapa adequado e \u00e1reas adequadas, colocando o valor no mapa.<\/p>\n<p style=\"text-align: justify;\"><strong>Passos para criar preenchidas mapa:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Na planilha, coloque alguns dados processando nomes de pa\u00eds ou estado para r\u00f3tulos de dados.<\/li>\n<li>Em seguida, escolha os <strong>dados e os r\u00f3tulos<\/strong>&gt; clique em <strong>Inserir<\/strong> e <strong>Mapas <\/strong>e depois em <strong>Mapa preenchido.<\/strong><\/li>\n<li>Aguarde o carregamento do mapa<\/li>\n<li>Em seguida, formate e redimensione conforme sua necessidade.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">6: Funnel Chart<\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-942\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-funnel-chart.jpg\" alt=\"\" width=\"535\" height=\"321\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-funnel-chart.jpg 535w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-funnel-chart-300x180.jpg 300w\" sizes=\"auto, (max-width: 535px) 100vw, 535px\" \/><\/p>\n<p style=\"text-align: justify;\">Este \u00e9 o \u00faltimo gr\u00e1fico mais recente do Excel 2019 denominado gr\u00e1fico de funil. O gr\u00e1fico de funil exibe todos os pontos de dados como uma <strong>barra horizontal<\/strong>, com as barras longas para valores mais altos.<\/p>\n<p style=\"text-align: justify;\">Todas as <strong>barras<\/strong> est\u00e3o centradas e dispostas verticalmente. E se voc\u00ea classificar os dados do maior para o menor, o resultado geral parece um funil.<\/p>\n<p style=\"text-align: justify;\"><strong>Siga as etapas para criar um gr\u00e1fico de funil:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Primeiro, digite os <strong>r\u00f3tulos e dados<\/strong>&gt; depois <strong>organize-os na ordem desejada do que aparecer no gr\u00e1fico de cima para baixo<\/strong><\/li>\n<li>Em seguida, escolha os<strong> r\u00f3tulos e dados<\/strong>&gt; clique em <strong>Inserir<\/strong>&gt; <strong>Cachoeira, Funil, Estoque, Superf\u00edcie ou Gr\u00e1fico de radar&gt; Funil.<\/strong><\/li>\n<li>E projetar o gr\u00e1fico de acordo com seu desejo.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Ent\u00e3o, \u00e9 isso, voc\u00ea pode criar o gr\u00e1fico de funil no Excel 2019.<\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\"><strong>Conclus\u00e3o:<\/strong><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\"><strong>Excel 2019<\/strong> \u00e9, sem d\u00favida, altamente avan\u00e7ado e teve muitas melhorias nele. <strong>V\u00e1rias fun\u00e7\u00f5es, f\u00f3rmulas, gr\u00e1ficos<\/strong>, etc. s\u00e3o implementadas para facilitar o trabalho dos usu\u00e1rios do Excel.<\/p>\n<p style=\"text-align: justify;\">Mas, com as \u00faltimas melhorias, \u00e9 igualmente importante saber us\u00e1-las.<\/p>\n<p style=\"text-align: justify;\">Ent\u00e3o, neste artigo, listei as \u00faltimas <strong>fun\u00e7\u00f5es e gr\u00e1ficos do Excel 2019 <\/strong>com maneiras de cri\u00e1-lo facilmente.<\/p>\n<p style=\"text-align: justify;\">Leia atentamente o blog para saber sobre as <strong>fun\u00e7\u00f5es do Excel 2019<\/strong> para simplificar sua experi\u00eancia de edi\u00e7\u00e3o de c\u00e1lculos e f\u00f3rmulas.<\/p>\n<p style=\"text-align: justify;\">Al\u00e9m disso, conhe\u00e7a os seis <strong>novos tipos de gr\u00e1fico para visualizar <\/strong>e apresentar os dados e obter uma vis\u00e3o do seu p\u00fablico.<\/p>\n<p style=\"text-align: justify;\">Apesar disso, se voc\u00ea deseja se tornar um profissional do Excel, aprenda o <span style=\"color: #339966;\"><a style=\"color: #339966;\" href=\"http:\/\/www.repairmsexcel.com\/blog\/master-excel\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Guia Avan\u00e7ado do Excel <\/strong><\/a><\/span>e torne-se um mestre no Excel.<\/p>\n<p style=\"text-align: justify;\">Espero que voc\u00ea goste do artigo e, se tiver alguma sugest\u00e3o, consultas e coment\u00e1rios, sinta-se \u00e0 vontade para compartilh\u00e1-lo conosco na se\u00e7\u00e3o de coment\u00e1rios abaixo.<\/p>\n<p style=\"text-align: justify;\">Boa sorte!!!<\/p>\n<p><a href=\"http:\/\/www.repairmsexcel.com\/blog\/master-excel\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2310 size-full\" src=\"http:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/05\/Excel_promo_img.jpg\" alt=\"learn Excel\" width=\"650\" height=\"325\" \/><\/a><\/p>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>O Microsoft Office 2019 acaba de ser lan\u00e7ado e, entre seus aplicativos, o Excel 2019 \u00e9 o que conta com &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Excel 2019 Novas fun\u00e7\u00f5es e gr\u00e1ficos que voc\u00ea deve aprender!\" class=\"read-more button\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-2019-funcoes-charts#more-940\" aria-label=\"Read more about Excel 2019 Novas fun\u00e7\u00f5es e gr\u00e1ficos que voc\u00ea deve aprender!\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":941,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[695],"tags":[496,497,498,499],"class_list":["post-940","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutoriais","tag-excel-2019-mais-recentes-graficos","tag-excel-2019-recursos-mais-recentes","tag-excel-2019-ultimas-funcoes","tag-o-que-ha-de-novo-no-excel-2019","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel 2019 Novas fun\u00e7\u00f5es e gr\u00e1ficos que voc\u00ea deve aprender!<\/title>\n<meta name=\"description\" content=\"Saiba as \u00faltimas Microsoft Excel 2019 fun\u00e7\u00f5es e novos gr\u00e1ficos para simplificar o seu c\u00e1lculo e apresentar dados de uma maneira nova\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-2019-funcoes-charts\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel 2019 Novas fun\u00e7\u00f5es e gr\u00e1ficos que voc\u00ea deve aprender!\" \/>\n<meta property=\"og:description\" content=\"Saiba as \u00faltimas Microsoft Excel 2019 fun\u00e7\u00f5es e novos gr\u00e1ficos para simplificar o seu c\u00e1lculo e apresentar dados de uma maneira nova\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-2019-funcoes-charts\" \/>\n<meta property=\"og:site_name\" content=\"Excel Arquivo Reparar Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-08-21T05:53:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-31T11:51:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/PT-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"654\" \/>\n\t<meta property=\"og:image:height\" content=\"391\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Margret\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/margret1_arthur\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Margret\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-2019-funcoes-charts#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-2019-funcoes-charts\"},\"author\":{\"name\":\"Margret\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\"},\"headline\":\"Excel 2019 Novas fun\u00e7\u00f5es e gr\u00e1ficos que voc\u00ea deve aprender!\",\"datePublished\":\"2019-08-21T05:53:31+00:00\",\"dateModified\":\"2021-07-31T11:51:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-2019-funcoes-charts\"},\"wordCount\":1670,\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-2019-funcoes-charts#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/PT-1.png\",\"keywords\":[\"Excel 2019 mais recentes gr\u00e1ficos\",\"Excel 2019 recursos mais recentes\",\"Excel 2019 \u00faltimas fun\u00e7\u00f5es\",\"O que h\u00e1 de novo no Excel 2019\"],\"articleSection\":[\"Tutoriais\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-2019-funcoes-charts\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-2019-funcoes-charts\",\"name\":\"Excel 2019 Novas fun\u00e7\u00f5es e gr\u00e1ficos que voc\u00ea deve aprender!\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-2019-funcoes-charts#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-2019-funcoes-charts#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/PT-1.png\",\"datePublished\":\"2019-08-21T05:53:31+00:00\",\"dateModified\":\"2021-07-31T11:51:11+00:00\",\"description\":\"Saiba as \u00faltimas Microsoft Excel 2019 fun\u00e7\u00f5es e novos gr\u00e1ficos para simplificar o seu c\u00e1lculo e apresentar dados de uma maneira nova\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-2019-funcoes-charts#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-2019-funcoes-charts\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-2019-funcoes-charts#primaryimage\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/PT-1.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/PT-1.png\",\"width\":654,\"height\":391,\"caption\":\"Excel 2019 \u00faltimas fun\u00e7\u00f5es,\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-2019-funcoes-charts#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel 2019 Novas fun\u00e7\u00f5es e gr\u00e1ficos que voc\u00ea deve aprender!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/\",\"name\":\"Excel Arquivo Reparar Blog\",\"description\":\"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas\",\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\",\"name\":\"Excel Arquivo Reparar\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Excel Arquivo Reparar\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\",\"name\":\"Margret\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"caption\":\"Margret\"},\"description\":\"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/margret-arthur-2545b6195\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/margret1_arthur\"],\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/author\\\/margret\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel 2019 Novas fun\u00e7\u00f5es e gr\u00e1ficos que voc\u00ea deve aprender!","description":"Saiba as \u00faltimas Microsoft Excel 2019 fun\u00e7\u00f5es e novos gr\u00e1ficos para simplificar o seu c\u00e1lculo e apresentar dados de uma maneira nova","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:\/\/pt.repairmsexcel.com\/blog\/excel-2019-funcoes-charts","og_locale":"en_US","og_type":"article","og_title":"Excel 2019 Novas fun\u00e7\u00f5es e gr\u00e1ficos que voc\u00ea deve aprender!","og_description":"Saiba as \u00faltimas Microsoft Excel 2019 fun\u00e7\u00f5es e novos gr\u00e1ficos para simplificar o seu c\u00e1lculo e apresentar dados de uma maneira nova","og_url":"https:\/\/pt.repairmsexcel.com\/blog\/excel-2019-funcoes-charts","og_site_name":"Excel Arquivo Reparar Blog","article_published_time":"2019-08-21T05:53:31+00:00","article_modified_time":"2021-07-31T11:51:11+00:00","og_image":[{"width":654,"height":391,"url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/PT-1.png","type":"image\/png"}],"author":"Margret","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/margret1_arthur","twitter_misc":{"Written by":"Margret","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-2019-funcoes-charts#article","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-2019-funcoes-charts"},"author":{"name":"Margret","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca"},"headline":"Excel 2019 Novas fun\u00e7\u00f5es e gr\u00e1ficos que voc\u00ea deve aprender!","datePublished":"2019-08-21T05:53:31+00:00","dateModified":"2021-07-31T11:51:11+00:00","mainEntityOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-2019-funcoes-charts"},"wordCount":1670,"publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-2019-funcoes-charts#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/PT-1.png","keywords":["Excel 2019 mais recentes gr\u00e1ficos","Excel 2019 recursos mais recentes","Excel 2019 \u00faltimas fun\u00e7\u00f5es","O que h\u00e1 de novo no Excel 2019"],"articleSection":["Tutoriais"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-2019-funcoes-charts","url":"https:\/\/pt.repairmsexcel.com\/blog\/excel-2019-funcoes-charts","name":"Excel 2019 Novas fun\u00e7\u00f5es e gr\u00e1ficos que voc\u00ea deve aprender!","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-2019-funcoes-charts#primaryimage"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-2019-funcoes-charts#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/PT-1.png","datePublished":"2019-08-21T05:53:31+00:00","dateModified":"2021-07-31T11:51:11+00:00","description":"Saiba as \u00faltimas Microsoft Excel 2019 fun\u00e7\u00f5es e novos gr\u00e1ficos para simplificar o seu c\u00e1lculo e apresentar dados de uma maneira nova","breadcrumb":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-2019-funcoes-charts#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pt.repairmsexcel.com\/blog\/excel-2019-funcoes-charts"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-2019-funcoes-charts#primaryimage","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/PT-1.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/PT-1.png","width":654,"height":391,"caption":"Excel 2019 \u00faltimas fun\u00e7\u00f5es,"},{"@type":"BreadcrumbList","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-2019-funcoes-charts#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pt.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"Excel 2019 Novas fun\u00e7\u00f5es e gr\u00e1ficos que voc\u00ea deve aprender!"}]},{"@type":"WebSite","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website","url":"https:\/\/pt.repairmsexcel.com\/blog\/","name":"Excel Arquivo Reparar Blog","description":"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas","publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pt.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization","name":"Excel Arquivo Reparar","url":"https:\/\/pt.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Excel Arquivo Reparar"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca","name":"Margret","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","caption":"Margret"},"description":"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.","sameAs":["https:\/\/www.linkedin.com\/in\/margret-arthur-2545b6195\/","https:\/\/x.com\/https:\/\/twitter.com\/margret1_arthur"],"url":"https:\/\/pt.repairmsexcel.com\/blog\/author\/margret"}]}},"_links":{"self":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/940","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=940"}],"version-history":[{"count":3,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/940\/revisions"}],"predecessor-version":[{"id":3446,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/940\/revisions\/3446"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/941"}],"wp:attachment":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=940"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=940"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=940"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}