{"id":368790,"date":"2021-11-17T22:00:42","date_gmt":"2021-11-17T19:00:42","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-make-a-line-graph-in-google-sheets\/"},"modified":"2021-11-17T22:00:42","modified_gmt":"2021-11-17T19:00:42","slug":"how-to-make-a-line-graph-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-line-graph-in-google-sheets\/","title":{"rendered":"#How to Make a Line Graph in Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a368d9392baf\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" 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: #dd3333;color:#dd3333\" 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><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a368d9392baf\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-line-graph-in-google-sheets\/#Make_a_Line_Chart_in_Google_Sheets\" >Make a Line Chart in Google Sheets<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-line-graph-in-google-sheets\/#Customize_a_Line_Graph_in_Google_Sheets\" >Customize a Line Graph in Google Sheets<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-line-graph-in-google-sheets\/#Adjust_the_Series\" >Adjust the Series<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-line-graph-in-google-sheets\/#Change_the_Gridlines_and_Ticks\" >Change the Gridlines and Ticks<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-line-graph-in-google-sheets\/#Modify_the_Legend\" >Modify the Legend<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Make a Line Graph in Google Sheets&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-767762\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/GoogleSheetsLineChart.png?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/GoogleSheetsLineChart.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/GoogleSheetsLineChart.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Google Sheets Line Chart\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you want to visually display data that changes over time, a line chart is ideal. With just a few clicks, you can create a line graph in Google Sheets and then customize it to your liking.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Make_a_Line_Chart_in_Google_Sheets\"><\/span>Make a Line Chart in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Start by selecting your data. You can do this by dragging your cursor through the range of cells you want to use.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-767765\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/SelectCells-GoogleSheetsLineChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the data\" width=\"400\" height=\"254\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Go to Insert in the menu and select \u201cChart.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-767764\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/InsertChart-GoogleSheetsLineChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Insert, Chart\" width=\"400\" height=\"392\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Google Sheets pops a default style graph into your spreadsheet, normally a column chart. But you can change this easily.<\/p>\n<p>When the graph <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ears, the Chart Editor sidebar should open along with it. Select the \u201cSetup\u201d tab at the top and click the \u201cChart Type\u201d drop-down box. Move down to the Line options and pick the one you want from a standard or smooth line chart.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-767767\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/SelectTypeLine-GoogleSheetsLineChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select a Line chart style\" width=\"400\" height=\"382\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The graph on your sheet will update im<a href=\"https:\/\/buradabiliyorum.com\/en\/category\/social-mediaa\/\" data-internallinksmanager029f6b8e52c=\"1\" title=\"Social Media\" target=\"_blank\" rel=\"noopener\">media<\/a>tely to the new chart type. From there, you can customize it if you like.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-767766\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/InsertedChart-GoogleSheetsLineChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Line graph in Google Sheets\" width=\"650\" height=\"264\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Customize_a_Line_Graph_in_Google_Sheets\"><\/span>Customize a Line Graph in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Most types of charts you create in Google Sheets have the same customization options. So you can do things like change the title, choose a background color, or give your graph a border.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Automatically Generate Charts in Google Sheets<\/em><\/strong><\/p>\n<p>If you closed the Chart Editor sidebar, reopen it by clicking the three dots on the top right of the chart and picking \u201cEdit Chart.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-767770\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/EditChart-GoogleSheetsLineChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select Edit Chart\" width=\"650\" height=\"405\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the sidebar, select the Customize tab at the top. You\u2019ll then see all of your options listed and collapsed. This lets you can expand only what you need or one at a time.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-767769\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/Customize-GoogleSheetsLineChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"View the Customize tab\" width=\"650\" height=\"359\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Let\u2019s take a look at a few customization options particular to line charts.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Adjust_the_Series\"><\/span>Adjust the Series<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>For each <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/watch-movies-tv-seriess\/\" data-internallinksmanager029f6b8e52c=\"8\" title=\"Watch Movies &amp; TV Series\" target=\"_blank\" rel=\"noopener\">series<\/a> on your chart, you have a colored line. Maybe you\u2019d like to change these colors, adjust the thickness, or choose a different line type.<\/p>\n<p>Expand Series in the sidebar. To change each series individually, select the drop-down for Apply to All Series and pick the one you want to adjust first.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-767773\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/SelectSeries-GoogleSheetsLineChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select a series\" width=\"400\" height=\"322\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You might change the color for that line or select a point shape. You\u2019ll see any changes you make apply to your line graph immediately.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-767771\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/ChangeSeries-GoogleSheetsLineChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Change a series style\" width=\"650\" height=\"288\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you want to make an adjustment that applies to all, such as changing the line thickness, select \u201cApply to All Series\u201d once more and make your changes.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-767772\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/AllSeries-GoogleSheetsLineChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Apply changes to all series\" width=\"650\" height=\"285\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Build Instant Charts with Google Sheets&#8217; Explore Feature<\/em><\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Change_the_Gridlines_and_Ticks\"><\/span>Change the Gridlines and Ticks<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Another adjustment you may want to make to your line chart is for the gridlines and ticks. Expand that area in the sidebar to view your options.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-767778\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/GridlinesTicks-GoogleSheetsLineChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Expand Gridlines and Ticks\" width=\"288\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For the horizontal axis, you can only change the major ticks. But for the vertical axis, you can adjust both major and minor gridlines and ticks. You can choose a different color for the gridlines and select a position, length, thickness, and color for the ticks.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-767777\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/ChangeGridlinesTicks-GoogleSheetsLineChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Change gridlines and ticks\" width=\"650\" height=\"329\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Switch Chart Axes in Google Sheets<\/em><\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Modify_the_Legend\"><\/span>Modify the Legend<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Although you can change the legend for other types of charts in Google Sheets, it\u2019s something else you may want to modify for your line graph.<\/p>\n<p>Expand \u201cLegend\u201d in the sidebar. You can then change the position along with the font style, size, format, and color.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-767776\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/Legend-GoogleSheetsLineChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Change the legend\" width=\"650\" height=\"269\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you don\u2019t want to use a legend at all, select \u201cNone\u201d in the Position drop-down list.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-767775\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/NoLegend-GoogleSheetsLineChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select None to remove the legend\" width=\"400\" height=\"423\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Because it\u2019s so simple to make a line graph in Google Sheets, you can give your sheet some pizzazz or your viewers an easy way to see your data at a glance. If you\u2019re looking for something on a smaller scale, take a look at how to use sparklines in Google Sheets instead.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/767761\/how-to-make-a-line-graph-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Make a Line Graph in Google Sheets&#8221; If you want to visually display data that changes over time, a line chart is ideal. With just a few clicks, you can create a line graph in Google Sheets and then customize it to your liking. Make a Line Chart in Google Sheets Start by&#8230;<\/p>\n","protected":false},"author":1,"featured_media":368791,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/GoogleSheetsLineChart.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-368790","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/368790","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=368790"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/368790\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/368791"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=368790"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=368790"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=368790"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}