{"id":9034,"date":"2023-09-29T13:38:00","date_gmt":"2023-09-29T13:38:00","guid":{"rendered":"https:\/\/randomtools.io\/blog\/?p=9034"},"modified":"2023-10-03T12:41:22","modified_gmt":"2023-10-03T12:41:22","slug":"how-to-make-a-line-graph-in-google-sheets","status":"publish","type":"post","link":"https:\/\/randomtools.io\/blog\/how-to-make-a-line-graph-in-google-sheets\/","title":{"rendered":"How to Make a Line Graph in Google Sheets in 2023?"},"content":{"rendered":"\n<p>A line graph is the best way to display the information and observe the trends. Let&#8217;s understand line graphs in more detail, which will make it easier for you to learn how to make a line graph in Google Sheets. Before we start, let&#8217;s understand what a line graph in <a href=\"https:\/\/www.google.com\/sheets\/about\/\" data-type=\"URL\" data-id=\"https:\/\/www.google.com\/sheets\/about\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Google Sheet<\/a>s is.&nbsp;<\/p>\n\n\n\n<p>So, in a simple way, line graphs are a way to record and monitor informational changes accurately. A line graph is also known as a line chart. Line graphs have straight lines which connect data points called &#8216;markers&#8217;. Line graphs have horizontal and vertical axes, which differentiate between categories and measurement values.&nbsp;<\/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><strong>How to Make a Line Graph in Google Sheets?<\/strong><br><strong>What are the Important Parts of a Line Graph?<\/strong><br><strong>Why Should You Use Line Graph?<\/strong><br><strong>How to Make a Line Graph in Google Sheets?<\/strong><br><strong>How to Make a Line Graph in Google Sheets &#8211; Line Graph<\/strong><br><strong>How to Make a Line Graph in Google Sheets &#8211; Multiple Lines<\/strong><br><strong>How Many Types of Line Graphs are in Google Sheets?<\/strong><br><strong>Conclusion<\/strong><gwmw style=\"display:none;\"><\/td><\/tr><\/tbody><\/table><figcaption><gwmw style=\"display:none;\"><gwmw style=\"display:none;\"><\/gwmw><\/gwmw><\/figcaption><\/figure>\n\n\n<h2 id=\"what-are-the-important-parts-of-a-line-graph\"><strong>What are the Important Parts of a Line Graph?<\/strong><\/h2>\n\n\n<p>So, first of all, we have to understand the different parts of a line graph. Understanding this can easily help display and analyze the information. So, let&#8217;s learn some important terminologies in line graphs before diving into how to make a line graph &#8211;<\/p>\n\n\n\n<ul><li>X-Axis (Horizontal axis)<\/li><li>Y-Axis (vertical axis)<\/li><li>Chart title<\/li><li>Markers<\/li><li>Grid<\/li><li>Y-Axis label<\/li><li>X-Axis label<\/li><li>Legend<\/li><\/ul>\n\n\n<h2 id=\"why-should-you-use-line-graph\">Why Should You Use Line Graph?<\/h2>\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/G9XrwyTj_AqC0bvnKgt6wFs1gKVrb7uERMx_ME6UdYUE89HWHA8p7cWan1dndOkl_dyNI64dxSAue21_T1UepDl5aG5WCKnv9s9lbVQzNE7XnoJJ2n9oDh-gpsHPv2HSOkLIJUMFAzA8\" alt=\"\"\/><\/figure>\n\n\n\n<p>The line graph helps serve the following purpose &#8211;<\/p>\n\n\n\n<ul><li>Showing data<\/li><li>Easy to understand, indicate, and read.<\/li><li>Easily displaying changes over time.<\/li><li>Understanding trends in the datasheet.<\/li><li>Showing how two variables relate to each other.<\/li><\/ul>\n\n\n\n<p>So, you can make a line graph when you need to explain trends, changes, increases, decreases, etc. Let&#8217;s dive in and learn how to make line graphs in Google Sheets.<\/p>\n\n\n<h2 id=\"how-to-make-a-line-graph-in-google-sheets\"><strong>How to Make a Line Graph in Google Sheets?<\/strong><\/h2>\n\n\n<p>Line graphs are easy to make. All you need to know is where you find the charts and graphs in Google Sheets. Here\u2019s how you can create a line graph.&nbsp;<\/p>\n\n\n\n<ul><li>Enter data in Google Sheets.<\/li><li>Select the data and go to the toolbar.<\/li><li>Go to <em>Insert&gt;Chart<\/em>.&nbsp;<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/H9xLnlrB5BqDD0VjcBu7vPcE_vwYCSf0h6pLog5taGcIEG6ohHiPfff9Wtlj2vk_gbuMmDmJtfs5rzIw21w8-tceo-1j8xd3KdDeES6FkIDAJMngGbNuou15DkIIHF-hUEBDkBLunOnt\" alt=\"\"\/><\/figure>\n\n\n\n<ul><li>You will find several chart options on a page on the screen, such as <em>Smooth Line Chart, Regular Line Chart, and Combo Line Chart.&nbsp;<\/em><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/-XRrTslzt_c43d6Pwf1dHKdev7M_AdAYY8HMzYvRKp1rOTcrKljkFQEOk-ZBySEh0o0ndXY0BOBId4TaU19paYXc9ouw6o5BKYqTI2EIUhO6fR_qISuHYLyECCQ2qQbfou-BLupKSP64\" alt=\"\"\/><\/figure>\n\n\n\n<ul><li>Ensure the correct ranges are entered in the X-axis and Series sections.&nbsp;<\/li><li>You can also customize the data and the chart as per your liking.&nbsp;<\/li><\/ul>\n\n\n<h2 id=\"how-to-make-a-line-graph-in-google-sheets-line-graph\">\n<strong>How to Make a Line Graph in Google Sheets &#8211; Line Graph<\/strong><gwmw style=\"display:none;\"><\/gwmw>\n<\/h2>\n\n\n<p>After choosing your Line Chart, you can further customize the graph. Here\u2019s how to do it &#8211;&nbsp;<\/p>\n\n\n\n<ul><li>Click on <em>Customize<\/em> beside the <em>Setup<\/em> option.&nbsp;<\/li><li>Go to <em>Chart Style<\/em>.&nbsp;<\/li><li>Click on the <em>Background Color<\/em>.&nbsp;<\/li><li>Choose the font type and customize other parameters, as shown below.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/wphM_dUuMOmQ11WpV1Ch4N8feUoVLqjU2bwthtU3ESBtQ6c4IkMABSVgZk95koNoKMyu3iucP0jduCvx5UFeGYSWoJTtfdmzSyeCYMcNEkZOU1XN8sHqf1dfZsrdZI3e8aoF-iB8Up79\" alt=\"\"\/><\/figure>\n\n\n\n<p>Now, you can also change the title font and size of the chart title. Here\u2019s how to do it &#8211;<\/p>\n\n\n\n<ul><li>Explore the <em>Chart Axis Title<\/em>, choose <em>Chart Title<\/em> in the drop-down list at the top.<\/li><li>Once selected, enter the chart title in the text box.&nbsp;<\/li><li>Click the <em>Bold <\/em>icon in <em>Title Format<\/em> and select blue in <em>Title Text Color<\/em>, as shown below.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/NY2ke40skf73sbrQNXx4wNGJ6Zuoe4wW8v7YNITv1ZSiLPRYwAlT2P5rRPVZiYN702PpTUSJYaE3zVgGm01ritdHa8pRSGpshET0zAfcBw1-qeoQEAL1TnIj2Mz7Ckamy9Fz-K8f7zfy\" alt=\"\"\/><\/figure>\n\n\n\n<p>You can also change the line color and opacity by following the steps given below &#8211;<\/p>\n\n\n\n<ul><li>Go to the <em>Series<\/em> tab.<\/li><li>Change <em>Line Color<\/em> to blue and choose <em>7px<\/em> for <em>Point Size<\/em> and <em>Circle<\/em> for <em>Point Shape.<\/em><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/DLjyJJxRkhaohWzK9UlorVx5qf-PQ0vT50RoAPrQl1uugn6S5alUNSrvm6dPPq3U0rKCs8eewU-nk4cZd2uBwgMQ2jYVdd9xneGxr9X8EB1siSvntCxP5x89i_nnEjs9qsh4Vur_9JzY\" alt=\"\"\/><\/figure>\n\n\n\n<ul><li>You can also add labels by checking the box near <em>Data Labels.<\/em>&nbsp;<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/RZHjN8leSwAptZPxSLdL9xlL_lya6TZRQ5UQK6vL87cU5BevX6SOj_-YcUyLMSugKqGbiPVg3uesjiaVRC7N8y2KUCOSpQqRwReWU00rxiGHB8rHTGhtug-3_39Ojo28yc3SwOuQqGML\" alt=\"\"\/><\/figure>\n\n\n\n<ul><li>Then, go to <em>Legend<\/em> and add a position at the <em>Bottom, Middle, or Top<\/em>.&nbsp;<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/BJqGejppa2PUKrPkByerBuxnHDjzD3Qo5YF241PIV5obaf4_pmZmuQkTb_VqR71pui5BeQG7NlD3bAH9MWcvXfwwdXsW_5d_Iiu-05i1H9EZ_OeqgSElc0Wyi5aRtaTohkh8AToBnKaq\" alt=\"\"\/><\/figure>\n\n\n\n<ul><li>Also, you can change the degree or the graph by hovering over <em>the Horizontal Axis<\/em> and changing the <em>Slant Labels<\/em>.&nbsp;<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/KMPnREPw6Dzx0N8Djd6_CzENt3qir3FPKBhZ86L2J5zoNPwe_i5W3vher9QEBLYfRlJljy9Vx5GE0VSaWGabiqU19ontRTGgwb5rMqhgWWC2ZU95NjLxb8Azpyh3GEqlmWJPtVaLYyWp\" alt=\"\"\/><\/figure>\n\n\n\n<ul><li>Input minimum and maximum values in the Y-axis in the text box.<\/li><\/ul>\n\n\n<h2 id=\"how-to-make-a-line-graph-in-google-sheets-multiple-lines\">\n<strong>How to Make a Line Graph in Google Sheets &#8211; Multiple Lines<\/strong><gwmw style=\"display:none;\"><\/gwmw>\n<\/h2>\n\n\n<p>Now that you know how to create and customize a single line graph, it is time to understand how to make a line graph in Google Sheets using multiple items. This helps show different values.&nbsp;<\/p>\n\n\n\n<ul><li>Select the data you want to include in the case.&nbsp;<\/li><li>Go to <em>Insert&gt;Chart<\/em>.<\/li><li>You will have a few lines on the sheets, as shown below.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/vzzg-WzbPPHX0yeG5kNJvox-DgapsbtJBZVR0vYRAVbOzte-3KcdJ6id5G8oB8Z_7WK-XwXe-czLcIzUituSCfT4HOxzJr6-y_AKEuSgzU-UeIYx224D9FL2jEEyOcWsLMDklf0-I0-4\" alt=\"\"\/><\/figure>\n\n\n\n<ul><li>You can add or remove the line series from <em>Setup&gt;Chart Editor<\/em>.&nbsp;<\/li><li>You can edit or customize the chart from <em>Customize<\/em>.&nbsp;<\/li><\/ul>\n\n\n<h2 id=\"how-many-types-of-line-graphs-are-in-google-sheets\">\n<strong>How Many Types of Line Graphs are in Google Sheets?<\/strong><gwmw style=\"display:none;\"><\/gwmw>\n<\/h2>\n\n\n<p>As per Google Sheets, there are three line graphs &#8211; Smooth Line Chart, Line Chart, and Combo Chart. We have already told you how to make a line graph in Google Sheets. Let\u2019s learn how to make Smooth Line and Combo Charts in Google Sheets.<\/p>\n\n\n<h3 id=\"smooth-line-chart\"><strong>Smooth Line Chart<\/strong><\/h3>\n\n\n<p>In line graphs, you will find rough edges; on the other hand, smooth line graphs don&#8217;t have any edges. Smooth line graphs are particularly used for small data sets, where distortions can be avoided. Here\u2019s how to make a smooth line graph &#8211;<\/p>\n\n\n\n<ul><li>Select the data input in the Google Sheets.<\/li><li>Go to <em>Insert&gt;Chart<\/em>.<\/li><li>You will have a basic line chart on your Google Sheets.<\/li><li>From the Chart Editor, go to the <em>Setup <\/em>tab.<\/li><li>Go to <em>Chart Type<\/em> and change the selection to <em>Smooth Line Chart<\/em>, as shown below.&nbsp;<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/tE-hXMbWtHxae1PqC57mbbzLyZsOObX5JpIESmVFRqsYcei-S_PCYZkJg1KOmCeHpQ9uAoGTbd3ZigulNT_wtPcRgBvc98dAffEI8j38lTDNA6b3gH1dkotzGUUM2Zd3CHycNFsHVxqO\" alt=\"\"\/><\/figure>\n\n\n<h3 id=\"combo-chart\">\n<strong>Combo Chart<\/strong><gwmw style=\"display:none;\"><gwmw style=\"display:none;\"><\/gwmw><\/gwmw>\n<\/h3>\n\n\n<p>Here\u2019s how you can make a combo chart &#8211;<\/p>\n\n\n\n<ul><li>Select the data set.<\/li><li>Go to <em>Insert&gt;Chart<\/em>.&nbsp;<\/li><li>From the Chart Type dropdown, select the<em> Combo Chart<\/em>.&nbsp;<\/li><li>The bar graph shows the roll number, and the marks are in the red line, as shown below.&nbsp;<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/yCFZ9_kF-sq5Cz1khEsk4PRqQiVj06Ju_2RU9kviPYnCcCJTDCRKl-C5U6L3Bj7AXY2ngUxIQ1IuSXaD-H8QJI3b2sdIlDaQlsb5xyGtG0dMbUrluaflIWUZYIA3YOp_KqgJRfEDf-eJ\" alt=\"\"\/><\/figure>\n\n\n<h2 id=\"conclusion\">\n<strong>Conclusion<\/strong><gwmw style=\"display:none;\"><\/gwmw>\n<\/h2>\n\n\n<p>As you have seen, learning how to make a line graph in Google Sheets is not very tough. You need a basic understanding of <a href=\"https:\/\/randomtools.io\/blog\/how-to-make-a-graph-in-google-sheets\/\" target=\"_blank\" data-type=\"URL\" data-id=\"https:\/\/randomtools.io\/blog\/how-to-make-a-graph-in-google-sheets\/\" rel=\"noreferrer noopener nofollow\">what a graph is<\/a> (most importantly, what a line graph is) and where you can find them in Google Sheets. Once you understand the basics, you are good to go. Hence, you can create a line graph of your own and be a workplace superstar!<\/p>\n\n\n\n<p>Line graphs are a great way to display the change in variables. Now you know how to make a line graph in Google Sheets, the types of line graphs, and the use of the graphs in Google Sheets. In addition, you know the difference between the three types of charts shown on Google Sheets: Smooth Line Chart, Line Chart, and Combo Line Chart.&nbsp;<\/p>\n<div class=\"likebtn_container\" style=\"\"><!-- LikeBtn.com BEGIN --><span class=\"likebtn-wrapper\"  data-identifier=\"post_9034\"  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-line-graph-in-google-sheets\/\"  data-item_title=\"How to Make a Line Graph in Google Sheets in 2023?\"  data-item_image=\"\/blog\/wp-content\/uploads\/2023\/09\/How-to-Make-a-Line-Graph-in-Google-Sheets-1024x576.png\"  data-item_date=\"2023-09-29T13:38: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>A line graph is the best way to display the information and observe the trends. Let&#8217;s understand line graphs in more detail, which will make<\/p>\n<div class=\"likebtn_container\" style=\"\"><!-- LikeBtn.com BEGIN --><span class=\"likebtn-wrapper\"  data-identifier=\"post_9034\"  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-line-graph-in-google-sheets\/\"  data-item_title=\"How to Make a Line Graph in Google Sheets in 2023?\"  data-item_image=\"\/blog\/wp-content\/uploads\/2023\/09\/How-to-Make-a-Line-Graph-in-Google-Sheets-1024x576.png\"  data-item_date=\"2023-09-29T13:38: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":9075,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[278,498],"tags":[493,552,554,555],"_links":{"self":[{"href":"https:\/\/randomtools.io\/blog\/wp-json\/wp\/v2\/posts\/9034"}],"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=9034"}],"version-history":[{"count":10,"href":"https:\/\/randomtools.io\/blog\/wp-json\/wp\/v2\/posts\/9034\/revisions"}],"predecessor-version":[{"id":9209,"href":"https:\/\/randomtools.io\/blog\/wp-json\/wp\/v2\/posts\/9034\/revisions\/9209"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/randomtools.io\/blog\/wp-json\/wp\/v2\/media\/9075"}],"wp:attachment":[{"href":"https:\/\/randomtools.io\/blog\/wp-json\/wp\/v2\/media?parent=9034"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/randomtools.io\/blog\/wp-json\/wp\/v2\/categories?post=9034"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/randomtools.io\/blog\/wp-json\/wp\/v2\/tags?post=9034"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}