{"id":5286,"date":"2018-06-28T17:34:22","date_gmt":"2018-06-28T10:34:22","guid":{"rendered":"http:\/\/gcloudvn.wam.vn\/cach-chen-bieu-trong-google-sheets\/"},"modified":"2023-11-30T16:37:42","modified_gmt":"2023-11-30T09:37:42","slug":"cach-chen-bieu-trong-google-sheets","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/cach-chen-bieu-trong-google-sheets\/","title":{"rendered":"How to insert a chart in Google Sheets"},"content":{"rendered":"<p><b>Google Sheets<\/b><span style=\"font-weight: 400;\"> is an extremely useful tool when working in real time with a group\u00a0<\/span><i><span style=\"font-weight: 400;\">(in real time)<\/span><\/i><span style=\"font-weight: 400;\">. <\/span><b>Google Sheets<\/b><span style=\"font-weight: 400;\"> fully exploited by Google to increase user experience and productivity. Not only shown with the basic features of <\/span><b>Google Sheets<\/b><span style=\"font-weight: 400;\">, it is also integrated with a series of powerful utilities to help even the most demanding people &quot;smile&quot; and agree when working online. <\/span><i><span style=\"font-weight: 400;\">(online)<\/span><\/i><span style=\"font-weight: 400;\"> with <\/span><b>Sheets<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Let&#039;s take a look at some of the most commonly used utilities on Sheets with Gimasys in today&#039;s article!<\/span><\/p>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_80 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/cach-chen-bieu-trong-google-sheets\/#Heatmaps\" >Heatmaps<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/cach-chen-bieu-trong-google-sheets\/#Chen_bieu_do_tu_Google_Sheet_vao_Google_Docs\" >Insert charts from Google Sheet into Google Docs<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/cach-chen-bieu-trong-google-sheets\/#Chen_du_lieu_tu_mot_sheet_sang_sheet_khac\" >Insert data from one sheet to another sheet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/cach-chen-bieu-trong-google-sheets\/#Chen_bieu_do_tu_dong_trong_Google_Sheet\" >Insert charts automatically in Google Sheet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/cach-chen-bieu-trong-google-sheets\/#Huong_dan_su_dung_Google_Sheet_Explore_xem_hinh\" >Instructions for using Google Sheet Explore (see picture)<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Heatmaps\"><\/span><b>Heatmaps<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Heatmaps<\/b><span style=\"font-weight: 400;\"> is a great way for users to highlight the data in their sheets when creating reports, to give a more vivid example that people can apply the rules. <\/span><i><span style=\"font-weight: 400;\">(syntax) <\/span><\/i><span style=\"font-weight: 400;\">that Google supports <\/span><b>Heatmaps<\/b><span style=\"font-weight: 400;\"> in the process of analyzing data coming from Google Analytics. Data that matches the corresponding rule will be highlighted.<\/span><\/p>\n<p>To create a heatmap, go to Google Sheets &gt; Format &gt; <a href=\"https:\/\/support.google.com\/docs\/answer\/78413?hl=en\" target=\"_blank\" rel=\"noopener\">Conditional Formatting<\/a>&#8230;<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full\" src=\"https:\/\/lh3.googleusercontent.com\/Dj55JWQ5UPFuvI1Gtb3JRFj-Xdy4TPbhrQzRiW6LoiC8RmFwggmqQJnoAzTMMul_lA-7QKx4WAQH1zP_4GYJzddSBDYKitAn4Ei_T70y17TGi-ur42Xo-r7kbS812CnZMiNEar-E\" alt=\"Google sheets\" width=\"250\" height=\"455\" \/><\/p>\n<p>In the options section, you can choose single colore (one color) or color scale to create a heatmap:<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full\" src=\"https:\/\/lh4.googleusercontent.com\/10h3B9lZmL6VwMcpNxG01uPkKM1dSKb383EzgTKSAfUExbrMt64EzjNyYj3wQPH4yT4Y0j5PD6pQkd7Bc6VIRKtZ3-4sFHWrzwqTB0WX7BUpNTl82HtD7ix9V53HGIZn8Y7intiQ\" width=\"750\" height=\"433\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Chen_bieu_do_tu_Google_Sheet_vao_Google_Docs\"><\/span><b>Insert charts from Google Sheet into Google Docs<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Docs<\/b><span style=\"font-weight: 400;\">, <\/span><b>Sheets<\/b><span style=\"font-weight: 400;\">, <\/span><b>Slides<\/b><span style=\"font-weight: 400;\"> is a suite of office applications on Google&#039;s Cloud platform, and Google has been doing a very good job of making them support each other at their best. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">If you have a pie chart containing report data created at <\/span><b>Google Sheets<\/b><span style=\"font-weight: 400;\">, but want to move it in <\/span><b>Google Docs<\/b><span style=\"font-weight: 400;\"> then use the feature <\/span><i><span style=\"font-weight: 400;\">Insert Chart From Sheets.<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">At <\/span><b>Google Docs<\/b><span style=\"font-weight: 400;\"> proceed in <\/span><b>Insert &gt; Chart &gt; From Sheets<\/b><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full\" src=\"https:\/\/lh3.googleusercontent.com\/EnZvyc2g3_T_7AiB95IEoDkVjgokC8l7Hd8L53HSMGhXLp0fAn0trU1MPom1YOCDD_53bIqVNEE4xBFo8TADKI06tG2pVbcDWvRlhNORjt4OIEnwx8IXNV87z5wvW7FRQGq8UEbU\" alt=\"Insert charts in Google Sheets\" width=\"750\" height=\"550\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">This is really useful, all data changes from <\/span><b>Google Sheets <\/b><span style=\"font-weight: 400;\">on this pie chart are all updated <\/span><b>Google Docs<\/b><span style=\"font-weight: 400;\"> automatically. You will save a huge amount of time compared to using other products to manipulate similar datasheets.<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Chen_du_lieu_tu_mot_sheet_sang_sheet_khac\"><\/span><b> Insert data from one sheet to another sheet<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Imagine you have 5 sheet report files and need to synthesize them into a single sheet report file with important data. If using other solutions, it takes a lot of time to copy and paste from 5 sheet files to 1 common file.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">However, Google completely understands the problem users encounter and the IMPORTRANGE function was born to solve that.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full\" src=\"https:\/\/lh6.googleusercontent.com\/T_K_e-HHwFsLcr9K76YMFJakLSogGtPEzvvCuINKY1Pt5jazNtgmWXMuAIJgNEfco0_O4R6MmeUrwLDZB68PwaafxLuRBjUGCCTP7jwXWbwKG-4w7zOwE7AdoBOjcdgBu8JMpVz9\" width=\"750\" height=\"198\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Simply, you only need to operate on 5 report files and it will automatically be updated to the main report file. So great at saving working time.<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Chen_bieu_do_tu_dong_trong_Google_Sheet\"><\/span><b> Insert charts automatically in Google Sheet<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Google has just updated the automatic chart insertion feature with existing metrics. Google automatically extracts data into column or pie charts (in percentage). You can also enter requests in the spoken language. For example\u201d \u201clist total spending by day\u201d, \u201clist the person with the highest revenue\u201d\u2026<\/span><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full\" src=\"https:\/\/lh5.googleusercontent.com\/s6bbZ_eMq9TZ04Xh6lUeTQ0te-adLjDftYyyQ30u4tEkQDxSbcuhbF7UfJUeOJUpMnw6wZWaKcN0d2AQF8t_QSeNpEuHB0vmWEU_0fEc5a9-wJyv6kp8xKX0r3RQT-QctFhY_so4\" alt=\"Insert charts in Google Sheets\" width=\"640\" height=\"407\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Google Sheet automatically creates charts based on data<\/span><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full\" src=\"https:\/\/lh4.googleusercontent.com\/X-DU27PIdGmDQnSehPYxPcgtbA-htd5EXgJj8Suvq386kiUbhWfZiljf-hrTbwCcfdu5bvkQRHKA7yGg99OCNJDN3WM3n9WhXZglyOcKjVNZ7hEl9FSdtgd-mXERXytyjAmo8Whv\" width=\"640\" height=\"255\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Extract total revenue by day<\/span><\/p>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Huong_dan_su_dung_Google_Sheet_Explore_xem_hinh\"><\/span><b>Instructions for using Google Sheet Explore (see picture)<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">- Open <\/span><b>Google Sheets<\/b><span style=\"font-weight: 400;\">, choose <\/span><b>Explore<\/b><span style=\"font-weight: 400;\"> lower right corner of the screen<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u2013 Scroll down and you will see many charts, hover over the chart to select <\/span><b>Insert Chart<\/b><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full\" src=\"https:\/\/lh6.googleusercontent.com\/QfKDt5YMcObmg69IcppFlEFTZfRQZLrv3GKEvi8f_lt3nxSB47MaZAzn9rUJvw9cFa3WrL4LTkqEkIOgs41BKcVHbzjhHf5-olQcWUr3ZCXwzUPPWgEe67JPGl8gmBlF8Wgzko6n\" width=\"640\" height=\"402\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">In addition, you can also sync data to your tablet from the incoming spreadsheet <\/span><b>Google Docs<\/b><span style=\"font-weight: 400;\">\u00a0or <\/span><b>Slides<\/b><span style=\"font-weight: 400;\">. You copy and paste the data in the spreadsheet <\/span><b>Docs\u00a0<\/b><span style=\"font-weight: 400;\">or <\/span><b>Slides\u00a0<\/b><span style=\"font-weight: 400;\">and press <\/span><b>\u201cUpdate\u201d <\/b><span style=\"font-weight: 400;\">to sync via tablet. You can also create a 3D chart with a new chart on the right. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">The above feature supports both iPhone and iPad.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full\" src=\"https:\/\/lh3.googleusercontent.com\/nH7mYK63maH3FWhNvtki6xkBZCPAhm743m2_BPJwOTDI7hi9MZ49w4fEv_zzbX9KYn2mBc4QAYbsEVLrlvmmse5SBMh6GXtLRWzeqVHZWjhizbXM2bCDl1xqkEHEATnC0BJ2P0n0\" width=\"640\" height=\"320\" \/><\/p>\n<p>&nbsp;<\/p>\n<blockquote><p><em>See more: <a href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/nhung-bieu-do-tu-google-sheets-vao-google-docs-va-slides\/\" target=\"_blank\" rel=\"noopener\">EMBEDD CHART FROM GOOGLE SHEETS INTO GOOGLE DOCS AND SLIDES<\/a>.<\/em><\/p><\/blockquote>\n<p style=\"text-align: right;\"><strong>Update: <a href=\"https:\/\/gcloudvn.com\/en\/\">Gimasys<\/a><\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>Google Sheets l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 c\u1ef1c k\u00ec h\u1eefu d\u1ee5ng khi vi\u1ec7c l\u00e0m vi\u1ec7c nh\u00f3m trong th\u1eddi gian th\u1ef1c c\u00f9ng nh\u00f3m\u00a0(in real time). Google Sheets \u0111\u01b0\u1ee3c Google khai th\u00e1c tri\u1ec7t \u0111\u1ec3 nh\u1eb1m t\u0103ng tr\u1ea3i nghi\u1ec7m c\u0169ng nh\u01b0 n\u0103ng su\u1ea5t l\u00e0m&hellip;<\/p>","protected":false},"author":1,"featured_media":5287,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5286","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kienthuc","entry","has-media"],"_links":{"self":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/5286","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/comments?post=5286"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/5286\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/5287"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=5286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=5286"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=5286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}