As a result of performing the previous step, Google Sheets inserts a chart type, that it deems fit to the data that we have chosen. In this example, it inserted a Line chart.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/google-sheets-charts-3.png” alt=”google sheets charts 3″ title_text=”google sheets charts 3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]
But, we can change the chart type using the Chart editor, that pop out on the right-hand side of the screen. It goes away if we click elsewhere on the spreadsheet. It comes back on when we double-click on the chart. Let\u2019s try changing it from Line chart to a Column chart. We can do so using the very first field on the\u00a0<\/span>DATA<\/strong>\u00a0<\/span>tab within the Chart editor.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/google-sheets-charts-4.png” alt=”google sheets charts 4″ title_text=”google sheets charts 4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”] Apart from changing the chart type, Google Sheets provides us with a myriad of options through Chart editor, using which we can customize our charts. The\u00a0<\/span>DATA<\/strong>tab handles the configuration settings like source data, axis, and series definitions etc. So, we can change the data range of a chart, edit the axis, or edit\/add another series to the existing chart.<\/p>\n The\u00a0<\/span>CUSTOMIZE<\/strong>\u00a0<\/span>tab handles all the appearance settings. So, we can amend the settings for chart style, colors, fonts, labels, legends, and title etc. from here. In the snapshot below, we changed the Chart style to 3D and Series color to brown.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/google-sheets-charts-5.png” alt=”google sheets charts 5″ title_text=”google sheets charts 5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”] Google Sheets charts come with wide variety of types. Which type is the best one to go with? It depends on the kind of data we are representing the chart with. So, before we even insert a chart in Google Sheets, we need to understand the purpose our chart is going to solve. Below is the list of the most commonly used chart types and the primary purpose they solve. There are other charts, but they are most advanced versions of the charts we talk about below.<\/p>\n A\u00a0<\/span>line chart<\/a>\u00a0<\/span>is typically used to represent changing trends that change over a period of time. If you need a chart that is time-sensitive, you may consider using a line chart. The third snapshot in this example is a Line chart.<\/p>\n This is very similar to that of the line chart.\u00a0An\u00a0<\/span>area chart<\/a>\u00a0<\/span>is visually more defining when the users are keen on the variances or margins between different trends.<\/p>\n We have used a\u00a0<\/span>column chart<\/a>\u00a0<\/span>in this example. This is usually chosen to compare a similar variable.A bar chart is similar to a column chart, except the axes are flipped.\u00a0 In the chart we have demonstrated above, we have compared sales across years. What if there is sales data corresponding to multiple regions? In this scenario, we can either use a clustered or a stacked column\/bar chart.<\/p>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/google-sheets-charts-6.png” alt=”google sheets charts 6″ title_text=”google sheets charts 6″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”] Consider that, we sales data from multiple regions. And, we need to see how each region contributes to the overall sales. In this scenario, a\u00a0<\/span>pie chart<\/a>\u00a0<\/span>solves our purpose. It divides an overall pie (total sales) into individual slices (regional sales), based on their corresponding proportions. Higher the sales from a region, bigger is the slice of the pie.<\/p>\n We use the\u00a0<\/span>scatter chart<\/a>\u00a0<\/span>to visualize the correlation between two dependent variables. For example, the overall productivity of a company can vary in accordance with the level of employee satisfaction.<\/p>\n Depending upon the type of data, and the visualization purpose, we can choose a type of chart that suits our needs and accordingly insert a chart in Google Sheets accordingly. Read through the following blog post to learn\u00a0<\/span>how to insert a diagram in Google Sheets<\/a>.<\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":" Spreadsheets are of the most ubiquitous software programs that help a user, beginner or advanced, to quickly get along with numbers. They not only help us store the data but also provide us with the necessary tools to derive insights. Google Sheets charts help the users to visualize data and inherent trends. In this article, […]<\/p>\n","protected":false},"author":40,"featured_media":37670,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Spreadsheets are of the most ubiquitous software programs that help a user, beginner or advanced, to quickly get along with numbers. They not only help us store the data but also provide us with the necessary tools to derive insights. Google Sheets charts help the users to visualize data and inherent trends. In this article, we explain how to insert a chart in Google Sheets. We also briefly talk about the kinds of chart types and their typical real-world applications.\nChart types<\/h3>\n
Line chart<\/h4>\n
Area chart<\/h4>\n
Column\/Bar chart<\/h4>\n
Pie chart<\/h4>\n
Scatter chart<\/h4>\n
Conclusion<\/h3>\n
Google Sheets charts: how to insert<\/h3>\nPlease consider the snapshot below. We have a sample sales data, which we will try and insert a chart for.\n\nExample<\/strong>
![\"Insert](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/12\/chart1.png\")
\n\nWe will select the entire data (in this example, A1:B7), and then choose the menu option Insert > Chart<\/strong>, as shown in the image below.\n\nExample<\/strong> ![\"Insert](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/12\/chart2.png\")
\n\nAs a result of performing the previous step, Google Sheets inserts a chart type, that it deems fit to the data that we have chosen. In this example, it inserted a Line chart.\n\nExample<\/strong> ![\"Insert](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/12\/chart3.png\")
\n\nBut, we can change the chart type using the Chart editor, that pop out on the right-hand side of the screen. It goes away if we click elsewhere on the spreadsheet. It comes back on when we double-click on the chart. Let's try changing it from Line chart to a Column chart. We can do so using the very first field on the DATA<\/strong> tab within the Chart editor.\n\nExample<\/strong> ![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/12\/chart4.png\")
\n\nApart from changing the chart type, Google Sheets provides us with a myriad of options through Chart editor, using which we can customize our charts. The DATA<\/strong> tab handles the configuration settings like source data, axis, and series definitions etc. So, we can change the data range of a chart, edit the axis, or edit\/add another series to the existing chart.\n\nThe CUSTOMIZE<\/strong> tab handles all the appearance settings. So, we can amend the settings for chart style, colors, fonts, labels, legends, and title etc. from here. In the snapshot below, we changed the Chart style to 3D and Series color to brown.\n\nExample<\/strong> ![\"Insert](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/12\/chart5.png\")
\nChart types<\/h3>\nGoogle Sheets charts come with wide variety of types. Which type is the best one to go with? It depends on the kind of data we are representing the chart with. So, before we even insert a chart in Google Sheets, we need to understand the purpose our chart is going to solve. Below is the list of the most commonly used chart types and the primary purpose they solve. There are other charts, but they are most advanced versions of the charts we talk about below.\n
Line chart<\/h4>\nA line chart<\/a> is typically used to represent changing trends that change over a period of time. If you need a chart that is time-sensitive, you may consider using a line chart. The third snapshot in this example is a Line chart.\n
Area chart<\/h4>\nThis is very similar to that of the line chart.\u00a0An area chart<\/a> is visually more defining when the users are keen on the variances or margins between different trends.\n
Column\/Bar chart<\/h4>\nWe have used a column chart<\/a> in this example. This is usually chosen to compare a similar variable.A bar chart is similar to a column chart, except the axes are flipped.\u00a0 In the chart we have demonstrated above, we have compared sales across years. What if there is sales data corresponding to multiple regions? In this scenario, we can either use a clustered or a stacked column\/bar chart.\n\nExample<\/strong>
![\"Insert](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/12\/chart6.png\")
\nPie chart<\/h4>\nConsider that, we sales data from multiple regions. And, we need to see how each region contributes to the overall sales. In this scenario, a pie chart<\/a> solves our purpose. It divides an overall pie (total sales) into individual slices (regional sales), based on their corresponding proportions. Higher the sales from a region, bigger is the slice of the pie.\n
Scatter chart<\/h4>\nWe use the scatter chart<\/a> to visualize the correlation between two dependent variables. For example, the overall productivity of a company can vary in accordance with the level of employee satisfaction.\n
Conclusion<\/h3>\nDepending upon the type of data, and the visualization purpose, we can choose a type of chart that suits our needs and accordingly insert a chart in Google Sheets accordingly.\n\n
\n\nFeatured image designed by Jannoon028 \/ Freepik<\/a><\/em><\/span>","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[39,28],"class_list":["post-7554","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/7554","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=7554"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/7554\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/37670"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=7554"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=7554"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=7554"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}