{"id":281,"date":"2022-12-05T08:45:37","date_gmt":"2022-12-05T03:15:37","guid":{"rendered":"https:\/\/sheetstips.com\/?p=281"},"modified":"2022-12-06T17:17:34","modified_gmt":"2022-12-06T11:47:34","slug":"line-chart-google-sheets","status":"publish","type":"post","link":"https:\/\/sheetstips.com\/line-chart-google-sheets\/","title":{"rendered":"How to Make a Line Chart in Google Sheets: Setup\/Edit\/Customize Line Graph"},"content":{"rendered":"<p><strong>Google Sheets Line Graph<\/strong> is one of the useful features which helps us to understand any dataset&#8217;s analysis within a fraction of seconds. Most people rely on line charts when it comes to store and review the informational changes from time to time. Any individual can easily create a Google Sheets Line chart within few clicks. However, if you have no idea about how to make a line chart in Google Sheets, then this article is for you. On this page, we have provided step by step procedure for making a line graph with <a href=\"https:\/\/sheetstips.com\/google-sheets-tips\/\" target=\"_blank\" rel=\"noopener\"><strong>Google Sheet tips<\/strong><\/a>. Read on to find more.<\/p>\n<p>Also Read: <a href=\"https:\/\/btechgeeks.com\/java-program-to-find-the-sum-of-series-x-x3-x5-x7-n\/\" target=\"_blank\" rel=\"noopener\">Java Program to Find the Sum of Series x \u2013 x^3 + x^5 \u2013 x^7 + \u2026\u2026 + N<\/a><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"601\">\n<p style=\"text-align: center;\"><strong>Table of Contents<\/strong><\/p>\n<ol>\n<li><a href=\"#Google-Line-Chart-Parameters\">Google Line Chart Parameters<\/a><\/li>\n<li><a href=\"#Types-of-Line-Chart-in-Google-Sheet\">Types of Line Chart in Google Sheet<\/a><\/li>\n<li><a href=\"#How-to-Make-a-Line-Graph-in-Google-Sheets-with-Multiple-Lines\">How to Make a Line Graph in Google Sheets with Multiple Lines?<\/a><\/li>\n<li><a href=\"#Setting-Up-Line-Chart-in-Google-Sheets\">Setting Up Line Chart in Google Sheets<\/a><\/li>\n<li><a href=\"#Customizing-the-Line-Graph-in-Google-Sheets\">Customizing the Line Graph in Google Sheets<\/a><\/li>\n<li><a href=\"#Editing-Line-Graph-in-Google-Sheets\">Editing Line Graph in Google Sheets<\/a><\/li>\n<\/ol>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"Google-Line-Chart-Parameters\">Google Line Chart Parameters<\/h2>\n<p>The important parameters of the line graph in Google Sheets are explained below:<\/p>\n<ol>\n<li>The Y-Axis (vertical axis)<\/li>\n<li>The X-Axis (horizontal axis)<\/li>\n<li>Chart Title<\/li>\n<li>Markers<\/li>\n<li>Grid<\/li>\n<li>Y-Axis Label<\/li>\n<li>X-Axis Label<\/li>\n<li>Legend<\/li>\n<\/ol>\n<h3 id=\"Types-of-Line-Chart-in-Google-Sheet\">Types of Line Chart in Google Sheet<\/h3>\n<p>Before creating a line chart, let&#8217;s understand the types of line charts available in Google Sheets.<\/p>\n<ol>\n<li>Regular Line chart<\/li>\n<li>Smooth line chart<\/li>\n<li>Combo line chart<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-309 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Chart-in-Google-Sheets.jpg\" alt=\"How to Make a Line Chart in Google Sheets\" width=\"603\" height=\"366\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Chart-in-Google-Sheets.jpg 603w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Chart-in-Google-Sheets-300x182.jpg 300w\" sizes=\"(max-width: 603px) 100vw, 603px\" \/><\/p>\n<p>A regular line graph will appear spiky, whereas a smooth line graph will appear to have flowing lines. A combo line graph combines the features of a line graph and a bar graph.<\/p>\n<ul>\n<li><a href=\"https:\/\/sheetstips.com\/scatter-plot-google-sheets\/\">How to Make a Scatter Plot in Google Sheets (Step-by-Step)<\/a><\/li>\n<li><a href=\"https:\/\/sheetstips.com\/pie-chart-google-sheets\/\">How to Make a Pie Chart in Google Sheets: Customize Pie Chart<\/a><\/li>\n<li><a href=\"https:\/\/sheetstips.com\/how-to-make-an-organization-chart-in-google-sheets\/\">How to\u00a0Make an\u00a0Organization Chart in Google Sheets? \u2013 Create an Org Chart in Google Sheets<\/a><\/li>\n<\/ul>\n<p>While you have complete control over how your graph appears, the most popular option is a normal line graph, which displays data more directly and precisely. However, the combo line graph works only when you have two series of data.<\/p>\n<h3 id=\"How-to-Make-a-Line-Graph-in-Google-Sheets-with-Multiple-Lines\">How to Make a Line Graph in Google Sheets with Multiple Lines?<\/h3>\n<p>Let&#8217;s consider we have the following dataset and want to create a line chart for the same.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-310\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-with-Multiple-Lines.jpg\" alt=\"How to Make a Line Graph in Google Sheets with Multiple Lines\" width=\"768\" height=\"626\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-with-Multiple-Lines.jpg 768w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-with-Multiple-Lines-300x245.jpg 300w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/p>\n<p>The steps to create a Line Chart in Google Sheet are given below:<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Select the dataset.<\/li>\n<li><strong>Step 2:<\/strong> Click on the &#8220;<strong>Insert<\/strong>&#8221; tab and select &#8220;<strong>Chart<\/strong>&#8221; from the drop-down menu. You can also make use of the Chart icon in the toolbar to create a Chart.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-312 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-1.jpg\" alt=\"How to Make a Line Graph in Google Sheets\" width=\"1688\" height=\"772\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-1.jpg 1688w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-1-300x137.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-1-1024x468.jpg 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-1-768x351.jpg 768w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-1-1536x702.jpg 1536w\" sizes=\"(max-width: 1688px) 100vw, 1688px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><strong>Step 3:<\/strong> Now the Chart Pane will open towards the right side of the screen.<\/li>\n<li><strong>Step 4:<\/strong> Under the &#8220;<strong>Chart Type<\/strong>&#8221; select &#8220;<strong>Line Chart<\/strong>&#8221; from the drop-down menu.<\/li>\n<li><strong>Step 5:<\/strong> Now your Line Graph will be generated as shown below.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-313 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-2.jpg\" alt=\"How to Make a Line Graph in Google Sheets\" width=\"1837\" height=\"753\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-2.jpg 1837w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-2-300x123.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-2-1024x420.jpg 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-2-768x315.jpg 768w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-2-1536x630.jpg 1536w\" sizes=\"(max-width: 1837px) 100vw, 1837px\" \/><\/p>\n<h3 id=\"Setting-Up-Line-Chart-in-Google-Sheets\">Setting Up Line Chart in Google Sheets<\/h3>\n<ol>\n<li><strong>Data Range:<\/strong> This defines the range of selected cells. You can also change the cell range by entering the cell ranges manually.<\/li>\n<li><strong>X-Axis:<\/strong> This is the range of cells in your spreadsheet that make up the X-Axis of your chart. Under the X-Axis, you will have the option to check or uncheck the Aggregate box. By checking the Aggregate box, You can combine all values that have the same X-Axis key. The aggregate dropdown box for your series or lines will give you the choice of showing the data such as average, count, max, median, min, sum and so on.<\/li>\n<li><strong>Series:<\/strong> A \u201cseries\u201d is a term that refers to each line in your graph. You can edit the series bar by clicking the 3 dots to add or delete the labels.<\/li>\n<li><strong>Switch Rows\/Columns Box:<\/strong> When you check this box, you can switch the rows into columns and columns into rows.<\/li>\n<li><strong>Use Row 1 as Headers:<\/strong> When you select this section, the data entered in row 1 will act as headers. Unchecking this section will consider all the data as non-headers.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-314 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-3.jpg\" alt=\"How to Make a Line Graph in Google Sheets\" width=\"322\" height=\"796\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-3.jpg 322w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-3-121x300.jpg 121w\" sizes=\"(max-width: 322px) 100vw, 322px\" \/><\/p>\n<h3 id=\"Customizing-the-Line-Graph-in-Google-Sheets\">Customizing the Line Graph in Google Sheets<\/h3>\n<p>Once the line graph is inserted in Google Sheets, you can customize the chart by moving to the Customize pane as shown below.<\/p>\n<ul>\n<li><strong>Chart Style:<\/strong> Here you can set up the chart background color and border color. Also, you can reset the layout from the list of options.<\/li>\n<li><strong>Chart and Axis Title<\/strong>: Under chart and axis title,\u00a0 you have the option to change the chart title, chart subtitle, X-axis title, Y-axis style. Apart from this, you can customize your chart title by changing the font type, color, size and text format.<\/li>\n<li><strong>Series:<\/strong> You can change the style of your lines here. You may construct the chart that most clearly depicts the information you want to convey by altering the thickness of each line, the marker point size, and the marker point shape. The aggregate dropdown menu in this area allows you to choose the type of aggregate you want your chart to display. Under &#8220;format data point&#8221; you can click on &#8220;add,&#8221; where you may even specify a specific marker on your chart. You can also choose whether or not to show elements like error bars, data labels, and trendlines.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-315 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-4.jpg\" alt=\"How to Make a Line Graph in Google Sheets\" width=\"326\" height=\"593\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-4.jpg 326w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-4-165x300.jpg 165w\" sizes=\"(max-width: 326px) 100vw, 326px\" \/><\/p>\n<ul>\n<li><strong>Legend<\/strong>: This menu allows you to move your legend to the desired location, as well as adjust the font, size, format, and text colour of the legend.<\/li>\n<li><strong>Horizontal Axis &amp; Vertical Axis: <\/strong>This section comes with plenty of choices, where you resize the font, change the font types, color, format and much more.<\/li>\n<li><strong>Gridlines:<\/strong> When showing data, gridlines might be useful. They give viewers a new viewpoint that allows them to better understand the information presented.<\/li>\n<\/ul>\n<h3 id=\"Editing-Line-Graph-in-Google-Sheets\">Editing Line Graph in Google Sheets<\/h3>\n<p>To edit the line chart in Google Sheets, just click on the chart. The &#8220;Chart Editor&#8221; opens towards the right side of the screen, where you can edit your chart.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-316 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-5.jpg\" alt=\"How to Make a Line Graph in Google Sheets\" width=\"1837\" height=\"753\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-5.jpg 1837w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-5-300x123.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-5-1024x420.jpg 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-5-768x315.jpg 768w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Make-a-Line-Graph-in-Google-Sheets-5-1536x630.jpg 1536w\" sizes=\"(max-width: 1837px) 100vw, 1837px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Sheets Line Graph is one of the useful features which helps us to understand any dataset&#8217;s analysis within a fraction of seconds. Most people rely on line charts when it comes to store and review the informational changes from time to time. Any individual can easily create a Google Sheets Line chart within few &#8230; <a title=\"How to Make a Line Chart in Google Sheets: Setup\/Edit\/Customize Line Graph\" class=\"read-more\" href=\"https:\/\/sheetstips.com\/line-chart-google-sheets\/\" aria-label=\"More on How to Make a Line Chart in Google Sheets: Setup\/Edit\/Customize Line Graph\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[83,84],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1824,"url":"https:\/\/sheetstips.com\/multi-colored-line-charts-google-sheets\/","url_meta":{"origin":281,"position":0},"title":"How To Create Multi Colored Line Charts in Google Sheets? (Multiple Color Chart in G-Sheets)","author":"Varsha","date":"May 12, 2022","format":false,"excerpt":"Anyone knows how to create line charts in Google Sheets. But do you know how to create Multi Colored Line Charts in Google Sheets? If not, then you don't have to worry. In this tutorial, we will learn everything about how to create a multi colored Line Charts with the\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"multi-colored-line-charts9","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/11\/multi-colored-line-charts9.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":517,"url":"https:\/\/sheetstips.com\/histogram-google-sheets\/","url_meta":{"origin":281,"position":1},"title":"How to Make a Histogram in Google Sheets: Create\/Delete\/Customize Histogram Graph","author":"Varsha","date":"December 5, 2022","format":false,"excerpt":"Google Sheets Histogram: When we want to display the distribution of a data set across different buckets or ranges, we can use a histogram chart in Google Sheets. The number of values in each range is represented by the height of each bar. The histogram is an inbuilt graphing tool\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"Show-item-dividers-in-the-histogram","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/08\/Show-item-dividers-in-the-histogram.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1013,"url":"https:\/\/sheetstips.com\/candlestick-chart-google-sheets\/","url_meta":{"origin":281,"position":2},"title":"How to Create Candlestick Chart in Google Sheets (With Examples)","author":"Varsha","date":"May 16, 2022","format":false,"excerpt":"A chart can depict a set of data values more clearly than a table with rows of numbers. Thus Google Sheets offers various types of charts that we can incorporate with our dataset. One of the most useful charts in Google Sheets is Candlestick Chart. A candlestick chart is a\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"candlestick-chart-google-sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/09\/candlestick-chart-google-sheets6.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1815,"url":"https:\/\/sheetstips.com\/waterfalls-chart-in-google-sheets\/","url_meta":{"origin":281,"position":3},"title":"How To Create a Waterfall Chart in Google Sheets? (Stacked Waterfall Charts)","author":"Varsha","date":"May 12, 2022","format":false,"excerpt":"There are various types of charts that can be created on Google Sheets to make our data in a more easy and understanding manner. A waterfall chart could show the number of leads, traffic sources, or blog visits over a period of time. For example, a waterfall chart might be\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"waterfalls-chart-in-google-sheets5","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/11\/waterfalls-chart-in-google-sheets5.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":525,"url":"https:\/\/sheetstips.com\/bell-curve-google-sheets\/","url_meta":{"origin":281,"position":4},"title":"How to Make a Bell Curve in Google Sheets: Bell Curve Graph Generator","author":"Varsha","date":"May 18, 2022","format":false,"excerpt":"Bell Curve is a type of Graph that can be generated on Google Sheets within few clicks. With the help of the Bell Curve, we can examine the differences between data points and the remaining data. Usually, organizations provide appraisals to employees based on the Bell Curve graph. The graph,\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"bell curve in google sheets7","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/08\/bell-curve-in-google-sheets1.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1182,"url":"https:\/\/sheetstips.com\/how-to-add-labels-to-legend-in-google-sheets\/","url_meta":{"origin":281,"position":5},"title":"How to Add Labels to Legend in Google Sheets (Step by Step Procedure)","author":"Varsha","date":"May 15, 2022","format":false,"excerpt":"Google Sheets allows us to create a wide range of charts to visualize the data. With the help of Charts in Google Sheets, we can easily understand the differences, data trends, and much more things. However, simply creating a chart with colored columns would be insufficient to understand the dataset.\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"how-to-add-labels-to-legend-in-google-sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/09\/how-to-add-labels-to-legend-in-google-sheets6.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/281"}],"collection":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/comments?post=281"}],"version-history":[{"count":2,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/281\/revisions"}],"predecessor-version":[{"id":4878,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/281\/revisions\/4878"}],"wp:attachment":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/media?parent=281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/categories?post=281"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/tags?post=281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}