{"id":8831,"date":"2023-09-18T08:35:00","date_gmt":"2023-09-18T08:35:00","guid":{"rendered":"https:\/\/randomtools.io\/blog\/?p=8831"},"modified":"2023-10-03T12:36:26","modified_gmt":"2023-10-03T12:36:26","slug":"how-to-make-a-graph-in-google-sheets","status":"publish","type":"post","link":"https:\/\/randomtools.io\/blog\/how-to-make-a-graph-in-google-sheets\/","title":{"rendered":"\u00a0How to Make a Graph in Google Sheets in 2023?"},"content":{"rendered":"\n<p>The spreadsheet can be a great tool to store and maintain data. However, with so much data and information, it can be very overwhelming. Thus, graphs help you to understand complex data in a jiffy. So, if you are wondering how to make a graph in Google Sheets, this blog is for you!<\/p>\n\n\n\n<p>This blog will discuss how to create a graph in Google Sheets.&nbsp;<gwmw style=\"display:none;\"><\/gwmw><\/p>\n\n\n<h2 id=\"table-of-content\">Table of Content<\/h2>\n\n\n<figure class=\"wp-block-table aligncenter\"><table><tbody><tr><td class=\"has-text-align-left\" data-align=\"left\"><strong>Why Are Graphs Used in Google Sheets?<\/strong><br><strong>How to Create a Graph in Google Sheets?<\/strong><br><strong>How to Create Different Types of Graphs in Google Sheets?<\/strong><br><strong>How to Make Line a Graph in Google Sheets &#8211; Line Graph<\/strong><br><strong>How to Make a Graph in Google Sheets &#8211; Scatter Plot<\/strong><br><strong>How to Make a Graph in Google Sheets &#8211; Bar or Column Graph&nbsp;<\/strong><br><strong>How to Make a Graph in Google Sheets &#8211; Stacked Bar Graph<\/strong><br><strong>How to Make a Graph in Google Sheets &#8211; Line Graph<\/strong><br><strong>How to Make a Graph in Google Sheets &#8211; 3D Graph<\/strong><br><strong>Conclusion<\/strong><gwmw style=\"display:none;\"><\/gwmw><\/td><\/tr><\/tbody><\/table><figcaption><gwmw style=\"display:none;\"><gwmw style=\"display:none;\"><\/gwmw><\/gwmw><\/figcaption><\/figure>\n\n\n<h2 id=\"why-are-graphs-used-in-google-sheets\">\n<strong>Why are Graphs Used in Google Sheets?<\/strong><gwmw style=\"display:none;\"><gwmw style=\"display:none;\"><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><gwmw style=\"display:none;\"><\/gwmw><\/gwmw><\/gwmw>\n<\/h2>\n\n\n<p>As they transform abstract numbers into visual representations that can be quickly understood, charts and graphs can be very helpful in simplifying complex data. Making charts or graphs out of the numbers in your spreadsheet is simple with <a href=\"https:\/\/workspace.google.com\/products\/sheets\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Google Sheets<\/a>.<gwmw style=\"display:none;\"><\/gwmw><\/p>\n\n\n<h2 id=\"how-to-create-a-graph-in-google-sheets\">\n<strong>How to Create a Graph in Google Sheets?<\/strong><gwmw style=\"display:none;\"><gwmw style=\"display:none;\"><\/gwmw><\/gwmw>\n<\/h2>\n\n\n<p>Creating a graph is simple and easy to create. Here\u2019s how to do it &#8211;<\/p>\n\n\n\n<ul><li>Open a Google Sheet and put the data.<\/li><li>Select the cell to enter the graph.&nbsp;<\/li><li>In the top toolbar, find the <em>Insert&gt;Chart<\/em><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/A_BxVoDpUlVLqPdJNHYEgqvJ1B8QOgd4dxmb3WX7hqvUz5mrimwG3gwZVABKMypRMKx5awFkFwvvmE_z0EOMGi3LARHp7nLIWD_TrDoUaK6sG7wDfF5UbjcIN_ooauLBgTBgbmz9of-G8HkNKTIgQBw\" alt=\"\"\/><\/figure>\n\n\n\n<ul><li>Your chart will appear on the sheet.&nbsp;<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/cf3Qe38NmN3MdqL8drKbiIzFaJn_qBp--xqBNoEWs8gDGVmNdl3Ax6JJkOXj3Lmj5zf9XkXjBx0wZtdbA1o_18Qi9_beoAntvhWJqpXvIaNSpjqlkep-qCTa7oZmn5tleDHvAdw-kLO2g1AhGxXedsw\" alt=\"\"\/><\/figure>\n\n\n\n<p>You can customize and select different types of charts and graphs as per your needs.<\/p>\n\n\n<h2 id=\"how-to-create-different-types-of-graphs-in-google-sheets\">\n<strong>How to Create Different Types of Graphs in Google Sheets?<\/strong><gwmw style=\"display:none;\"><\/gwmw>\n<\/h2>\n\n\n<p>Because they transform abstract numbers into visually appealing representations, charts and graphs are useful for conveying information. With Google Sheets, it&#8217;s simple to construct graphs or charts from the data in your spreadsheet.<gwmw style=\"display:none;\"><\/p>\n\n\n\n<p>We have discussed how to create different types of graphs in Google Sheets &#8211;<\/p>\n\n\n<h3 id=\"how-to-make-line-a-graph-in-google-sheets-line-graph\"><strong><strong><strong>How to Make Line a Graph in Google Sheets &#8211; Line Graph<\/strong><\/strong><\/strong><\/h3>\n\n\n<p>The link between two variables\u2014one dependent and one independent variable\u2014is depicted using line graphs. The independent variable is shown along the horizontal or x-axis and is usually used to indicate the passage of time. The y-axis, or vertical dimension, is used to measure the dependent variable. The junctions are shown as dots that are connected by curved or straight lines. Here\u2019s <a href=\"https:\/\/randomtools.io\/blog\/how-to-make-a-line-graph-in-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">how to make a line graph in Google Sheets<\/a> &#8211;<\/p>\n\n\n\n<ul><li>Set up your data.<\/li><li>Go to <em>Insert&gt;Chart<\/em>.&nbsp;<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/A_BxVoDpUlVLqPdJNHYEgqvJ1B8QOgd4dxmb3WX7hqvUz5mrimwG3gwZVABKMypRMKx5awFkFwvvmE_z0EOMGi3LARHp7nLIWD_TrDoUaK6sG7wDfF5UbjcIN_ooauLBgTBgbmz9of-G8HkNKTIgQBw\" alt=\"\"\/><\/figure>\n\n\n\n<ul><li>A dialogue box will open beside the page, and you can pick or customize your line graph as needed.&nbsp;<\/li><\/ul>\n\n\n<h3 id=\"how-to-make-a-graph-in-google-sheets-scatter-plot\">How to Make a Graph in Google Sheets &#8211; Scatter Plot<\/h3>\n\n\n<p>In scatter plots, a dataset of two variables is often represented. Data is shown as a set of points, with the values of one variable determining the position along the x-axis and the other variable determining the position along the y-axis. Here\u2019s how you can do it &#8211;<gwmw style=\"display:none;\"><gwmw style=\"display:none;\"><\/p>\n\n\n\n<ul><li>Set up your data.<\/li><li>Go to <em>Insert&gt;Chart<\/em>.&nbsp;<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/A_BxVoDpUlVLqPdJNHYEgqvJ1B8QOgd4dxmb3WX7hqvUz5mrimwG3gwZVABKMypRMKx5awFkFwvvmE_z0EOMGi3LARHp7nLIWD_TrDoUaK6sG7wDfF5UbjcIN_ooauLBgTBgbmz9of-G8HkNKTIgQBw\" alt=\"\"\/><\/figure>\n\n\n\n<ul><li>A dialogue box will open beside the page.<\/li><li>Select <em>Scatter Chart<\/em> from the box.&nbsp;<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/K3O_0tKrNUiI2yk-HPHVMk77HKpDTwZRBApBtszNV4VxLrQmxeeOm4wuEdQjzUsQD_lwcVqE-xzZnIe5eByKVgMrnUultR0o3zVv90rwyhH-F5Lw2P90oDoz57VbyhjHXgwtGuZkHtkw0PBUVaG8Dko\" alt=\"\"\/><\/figure>\n\n\n\n<ul><li>Now, you have your scatter graph on your sheet.&nbsp;<\/li><\/ul>\n\n\n<h3 id=\"how-to-make-a-graph-in-google-sheets-bar-or-column-graphnbsp\">How to Make a Graph in Google Sheets &#8211; Bar or Column Graph <\/h3>\n\n\n<p>Bar graphs and columns are used to compare categorical data. Each bar represents a category. The length of the bar shows the value they represent. The higher or longer the bar, the higher the value. Depending on the data, these graphs are placed either horizontally or vertically. Here\u2019s how to make a bar or column graphs &#8211;<\/p>\n\n\n\n<ul><li>Set up the data in Google Sheets.<\/li><li>Select the data using CTRL+A.&nbsp;<\/li><li>Go to <em>Insert&gt;Chart<\/em>.&nbsp;<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/A_BxVoDpUlVLqPdJNHYEgqvJ1B8QOgd4dxmb3WX7hqvUz5mrimwG3gwZVABKMypRMKx5awFkFwvvmE_z0EOMGi3LARHp7nLIWD_TrDoUaK6sG7wDfF5UbjcIN_ooauLBgTBgbmz9of-G8HkNKTIgQBw\" alt=\"\"\/><\/figure>\n\n\n\n<ul><li>Select the column or bar from under the <em>Chart Type<\/em> to select a horizontal or vertical bar.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/jBRiIgnuhAlvDbhRZnDfLm5K6lXxeGKbCrjd08dh4F9acpt_wE3x3EeGOrML4PqOM69RHUnx0VvQFfWl8Vw1VMGIPKMnzNyanCOy7JoBikZld4iyVSiBPAxm2zugJRxuAeACn2gOAuyLvS6zw-mGiPA\" alt=\"\"\/><\/figure>\n\n\n<h3 id=\"how-to-make-a-graph-in-google-sheets-stacked-bar-graph\"><strong>How to Make a Graph in Google Sheets &#8211; Stacked Bar Graph<\/strong><\/h3>\n\n\n<p>A simple bar graph uses bars to represent a variable. The stacked bar graphs, however, only accomplish this for one variable. The height or length of the resulting stack, which is created when the bars in the bar graphs are stacked on top of one another, displays the total outcome. How to create a stacked bar graph is as follows &#8211;<\/p>\n\n\n\n<ul><li>Select the data using CTRL+A.<\/li><li>Go to <em>Insert&gt;Chart.<\/em><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/A_BxVoDpUlVLqPdJNHYEgqvJ1B8QOgd4dxmb3WX7hqvUz5mrimwG3gwZVABKMypRMKx5awFkFwvvmE_z0EOMGi3LARHp7nLIWD_TrDoUaK6sG7wDfF5UbjcIN_ooauLBgTBgbmz9of-G8HkNKTIgQBw\" alt=\"\"\/><\/figure>\n\n\n\n<ul><li>You will find a dialogue box with chart options.&nbsp;<\/li><li>Click the drop-down, select <em>Stacked Column Chart<\/em>, and select <em>Standard<\/em> from under the <em>Stacking<\/em>.&nbsp;<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/NVjPjhcRnTqSuXMkhnF9CNIffmHh_NideNymd7nNJ0QE_FPxdZJhEMMUc-Fi_cs3ZN3eEVkIaJgApsFfC0PHX3Yo-AtirRbeDn5zicfJLa197ee-JD5Z2WPHFN52l_kXIvORPGUkyd3voq88CjY147I\" alt=\"\"\/><\/figure>\n\n\n\n<ul><li>If you want to use horizontal bars, you can navigate through the same stacking options.&nbsp;<\/li><\/ul>\n\n\n<h3 id=\"how-to-make-a-graph-in-google-sheets-line-graph\">How to Make a Graph in Google Sheets &#8211; Line Graph<\/h3>\n\n\n<p>Line graphs are best for showing one or more variables. The graph has an X and Y axis, in which &#8211; the X-axis shows the time unit, whereas the Y-axis shows the unit of the variable. Here\u2019s how to make a line graph in Google Sheets &#8211;<\/p>\n\n\n\n<ul><li>Select the entire data using CTRL+A.<\/li><li>Go to <em>Insert&gt;Chart<\/em>.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/A_BxVoDpUlVLqPdJNHYEgqvJ1B8QOgd4dxmb3WX7hqvUz5mrimwG3gwZVABKMypRMKx5awFkFwvvmE_z0EOMGi3LARHp7nLIWD_TrDoUaK6sG7wDfF5UbjcIN_ooauLBgTBgbmz9of-G8HkNKTIgQBw\" alt=\"\"\/><\/figure>\n\n\n\n<ul><li>A dialogue box named Chart Editor will appear at the side of the page.&nbsp;<\/li><li>Click on the drop-down option <em>Column Chart<\/em>.&nbsp;<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/FPPMovFYSRv2B7oXa7V8yQwnc1pkEvSKgtCxwPERuJ1RAGXUX2IoTpDyv-Bz4muLvT9KrmqbuAlUaqLGeVYskt4lkPLdGYbiwHyP0P67dxgIUf8w7lp4dWDn5eYC6PHies4mg1edgYH9mpS2UqnjZ3o\" alt=\"\"\/><\/figure>\n\n\n\n<ul><li>You will find several line graphs.&nbsp;<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/VoUnfPT1QkrpTHnVqO4qJptaJNqL0jPwN85Az6VsNv-iurRHxLP7EA1WE1c7UZe0vRQnJFImaldWpjY7LA5RXyzcmDKPxniaFV5uVtBVGt-4wc5_TSnydmzdLSot1ZUV-E3bz9ZzgCrtXVniQJ8p1hQ\" alt=\"\"\/><\/figure>\n\n\n\n<ul><li>Select the one that suits your data.&nbsp;<\/li><\/ul>\n\n\n\n<p>Not to forget, did you know you can also make 3D graphs in Google Sheets?&nbsp;<\/p>\n\n\n<h3 id=\"how-to-make-a-graph-in-google-sheets-3d-graph\"><strong>How to Make a Graph in Google Sheets &#8211; 3D Graph<\/strong><\/h3>\n\n\n<p>Here\u2019s how you to 3D graphs in Google Sheets &#8211;<\/p>\n\n\n\n<ul><li>Select the entire data using CTRL+A.<\/li><li>Go to <em>Insert&gt;Chart<\/em>.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/A_BxVoDpUlVLqPdJNHYEgqvJ1B8QOgd4dxmb3WX7hqvUz5mrimwG3gwZVABKMypRMKx5awFkFwvvmE_z0EOMGi3LARHp7nLIWD_TrDoUaK6sG7wDfF5UbjcIN_ooauLBgTBgbmz9of-G8HkNKTIgQBw\" alt=\"\"\/><\/figure>\n\n\n\n<ul><li>A dialogue box named Chart Editor will appear at the side of the page.<\/li><li>Click on <em>Customize<\/em>.<\/li><li>Click on <em>3D<\/em>.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/ybabMJQaxRlFyzZ9iB3Ky0QUfWLg-29kO9T7BEELCNXCfrk1GDVP8bKD1MMKa2fcYFxgZ_fHAZwQ83FD5_okZ2AYcnshoxEfsqnbnbL5a9ZZ4SLdpb4PxSoNR8c47-eTZxhyRdb_3f9d2_Brl3MEnfA\" alt=\"\"\/><\/figure>\n\n\n\n<p>There you go! You have a data chart that looks more presentable and appealing.&nbsp;<\/p>\n\n\n<h2 id=\"conclusion\">Conclus<strong>ion<\/strong>\n<\/h2>\n\n\n<p>Now you know how to make a graph in Google Sheets, you must have known by now that the chart selection includes various graphs. Hence, your chart selection depends on the data you use or want to highlight. Usually, Google Sheets automatically recognize the type of chart suitable for your data type. However, you can choose anything you want to. These are the basics of Google Sheets, and if you want to know more about Google Sheets basics, <a href=\"https:\/\/randomtools.io\/blog\/google-sheets-basics-in-2023\/\" target=\"_blank\" data-type=\"URL\" data-id=\"https:\/\/randomtools.io\/blog\/google-sheets-basics-in-2023\/\" rel=\"noreferrer noopener nofollow\">check out this blog<\/a>!<\/p>\n<div class=\"likebtn_container\" style=\"\"><!-- LikeBtn.com BEGIN --><span class=\"likebtn-wrapper\"  data-identifier=\"post_8831\"  data-site_id=\"63451ab7943ec9522b1d4658\"  data-theme=\"custom\"  data-btn_size=\"35\"  data-icon_l=\"thmb7-u\"  data-icon_d=\"thmb7-d\"  data-icon_size=\"20\"  data-icon_l_c=\"#81d742\"  data-icon_d_c=\"#dd3333\"  data-brdr_c=\"#1e73be\"  data-f_size=\"18\"  data-f_family=\"Comic Sans MS\"  data-ef_voting=\"wobble\"  data-show_like_label=\"false\"  data-share_size=\"large\"  data-style=\"\"  data-unlike_allowed=\"\"  data-show_copyright=\"\"  data-item_url=\"https:\/\/randomtools.io\/blog\/how-to-make-a-graph-in-google-sheets\/\"  data-item_title=\"\u00a0How to Make a Graph in Google Sheets in 2023?\"  data-item_image=\"\/blog\/wp-content\/uploads\/2023\/10\/Master-Google-Sheets-Graph-Beginner-to-Pro-in-No-Minute-1024x576.png\"  data-item_date=\"2023-09-18T08:35:00+00:00\"  data-engine=\"WordPress\"  data-plugin_v=\"2.6.46\"  data-prx=\"\/blog\/wp-admin\/admin-ajax.php?action=likebtn_prx\"  data-event_handler=\"likebtn_eh\" ><\/span><!-- LikeBtn.com END --><\/div>","protected":false},"excerpt":{"rendered":"<p>The spreadsheet can be a great tool to store and maintain data. However, with so much data and information, it can be very overwhelming. Thus,<\/p>\n<div class=\"likebtn_container\" style=\"\"><!-- LikeBtn.com BEGIN --><span class=\"likebtn-wrapper\"  data-identifier=\"post_8831\"  data-site_id=\"63451ab7943ec9522b1d4658\"  data-theme=\"custom\"  data-btn_size=\"35\"  data-icon_l=\"thmb7-u\"  data-icon_d=\"thmb7-d\"  data-icon_size=\"20\"  data-icon_l_c=\"#81d742\"  data-icon_d_c=\"#dd3333\"  data-brdr_c=\"#1e73be\"  data-f_size=\"18\"  data-f_family=\"Comic Sans MS\"  data-ef_voting=\"wobble\"  data-show_like_label=\"false\"  data-share_size=\"large\"  data-style=\"\"  data-unlike_allowed=\"\"  data-show_copyright=\"\"  data-item_url=\"https:\/\/randomtools.io\/blog\/how-to-make-a-graph-in-google-sheets\/\"  data-item_title=\"\u00a0How to Make a Graph in Google Sheets in 2023?\"  data-item_image=\"\/blog\/wp-content\/uploads\/2023\/10\/Master-Google-Sheets-Graph-Beginner-to-Pro-in-No-Minute-1024x576.png\"  data-item_date=\"2023-09-18T08:35:00+00:00\"  data-engine=\"WordPress\"  data-plugin_v=\"2.6.46\"  data-prx=\"\/blog\/wp-admin\/admin-ajax.php?action=likebtn_prx\"  data-event_handler=\"likebtn_eh\" ><\/span><!-- LikeBtn.com END --><\/div>","protected":false},"author":4638,"featured_media":9213,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[498,278],"tags":[559,560,558],"_links":{"self":[{"href":"https:\/\/randomtools.io\/blog\/wp-json\/wp\/v2\/posts\/8831"}],"collection":[{"href":"https:\/\/randomtools.io\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/randomtools.io\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/randomtools.io\/blog\/wp-json\/wp\/v2\/users\/4638"}],"replies":[{"embeddable":true,"href":"https:\/\/randomtools.io\/blog\/wp-json\/wp\/v2\/comments?post=8831"}],"version-history":[{"count":15,"href":"https:\/\/randomtools.io\/blog\/wp-json\/wp\/v2\/posts\/8831\/revisions"}],"predecessor-version":[{"id":9215,"href":"https:\/\/randomtools.io\/blog\/wp-json\/wp\/v2\/posts\/8831\/revisions\/9215"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/randomtools.io\/blog\/wp-json\/wp\/v2\/media\/9213"}],"wp:attachment":[{"href":"https:\/\/randomtools.io\/blog\/wp-json\/wp\/v2\/media?parent=8831"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/randomtools.io\/blog\/wp-json\/wp\/v2\/categories?post=8831"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/randomtools.io\/blog\/wp-json\/wp\/v2\/tags?post=8831"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}