{"id":26064,"date":"2020-06-16T15:50:00","date_gmt":"2020-06-16T15:50:00","guid":{"rendered":"https:\/\/icrowdnewswire.com\/?p=2599565"},"modified":"2020-06-16T15:50:00","modified_gmt":"2020-06-16T15:50:00","slug":"how-to-make-a-graph-in-google-sheets","status":"publish","type":"post","link":"https:\/\/ipsnews.net\/business\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/","title":{"rendered":"How to make a graph in Google Sheets"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" width=\"233\" height=\"24\" src=\"https:\/\/icrowdnewswire.com\/wp-content\/uploads\/2020\/06\/4001-logo-549.png\" class=\"webfeedsFeaturedVisual wp-post-image\" alt=\"\" style=\"display: block; margin-bottom: 5px; clear:both;max-width: 100%;\" link_thumbnail=\"\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/05\/Google-Drive-logo-on-smartphone-stock-photo-2-1200x675.jpg\" alt=\"Google Drive logo on smartphone stock photo 2\" width=\"731\" height=\"411\" \/><\/p>\n<div class=\"the-content padded-panel\">\n<div id=\"content-anchor-inner\" class=\"clearfix\">\n<p>Google Sheets is a convenient alternative to&nbsp;<a href=\"https:\/\/www.androidauthority.com\/how-to-find-mean-in-excel-1108559\/\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft Excel<\/a>. It offers many of the same functions in a cloud-based package. However, it can still be a challenge to read and understand large sheets of data. Here&rsquo;s how to make a graph in Google Sheets to simplify your information.<\/p>\n<p><strong>See also:&nbsp;<\/strong><a href=\"https:\/\/www.androidauthority.com\/best-excel-apps-spreadsheet-apps-android-1122472\/\">10 best Excel apps and spreadsheet apps for Android!<\/a><\/p>\n<p>The process of creating a graph in Google Sheets is similar to that of&nbsp;<a href=\"https:\/\/www.androidauthority.com\/how-to-filter-data-in-excel-1102521\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel<\/a>, though you&rsquo;ll have to be ready for a different set of buttons. We&rsquo;ve grabbed our data from&nbsp;<em><a href=\"https:\/\/www.idc.com\/promo\/smartphone-market-share\/vendor\" target=\"_blank\" rel=\"noopener noreferrer\" data-vars-outbound-link=\"https:\/\/www.idc.com\/promo\/smartphone-market-share\/vendor\">IDC<\/a><\/em>, so you can always use that as an example and follow along.<\/p>\n<p><strong>See also:&nbsp;<\/strong><a href=\"https:\/\/www.androidauthority.com\/how-to-use-google-drive-860193\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to use Google Drive: Everything you need to know<\/a><\/p>\n<h2>How to make a graph in Google Sheets<\/h2>\n<p>1. Much like making a graph in Excel, the first step is to select your data. After all, an empty chart won&rsquo;t do much for your readers.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-1126841 noname aa-img lazyloaded\" title=\"graph in google sheets 1\" src=\"https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-1200x559.jpg\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" srcset=\"https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-1200x559.jpg 1200w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-300x140.jpg 300w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-768x358.jpg 768w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-16x7.jpg 16w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-32x15.jpg 32w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-28x13.jpg 28w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-56x26.jpg 56w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-64x30.jpg 64w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-1000x466.jpg 1000w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-429x200.jpg 429w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-675x315.jpg 675w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1.jpg 1309w\" alt=\"graph in google sheets 1\" width=\"741\" height=\"345\" data-src=\"https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-1200x559.jpg\" data-srcset=\"https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-1200x559.jpg 1200w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-300x140.jpg 300w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-768x358.jpg 768w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-16x7.jpg 16w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-32x15.jpg 32w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-28x13.jpg 28w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-56x26.jpg 56w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-64x30.jpg 64w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-1000x466.jpg 1000w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-429x200.jpg 429w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1-675x315.jpg 675w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-1.jpg 1309w\" data-sizes=\"(max-width: 1200px) 100vw, 1200px\" data-attachment-id=\"1126841\" \/><\/p>\n<p>2. Now head up to the&nbsp;<strong>Insert<\/strong>&nbsp;tab (located between View and Format) and scroll down to the&nbsp;<strong>Chart<\/strong>&nbsp;option. The Chart button is where you&rsquo;ll find both charts and graphs in Google Sheets, there is no Graph button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-1126842 noname aa-img lazyloaded\" title=\"graph in google sheets 2\" src=\"https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-1200x557.jpg\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" srcset=\"https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-1200x557.jpg 1200w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-300x139.jpg 300w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-768x357.jpg 768w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-16x7.jpg 16w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-32x15.jpg 32w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-28x13.jpg 28w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-56x26.jpg 56w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-64x30.jpg 64w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-1000x464.jpg 1000w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-431x200.jpg 431w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-675x314.jpg 675w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2.jpg 1309w\" alt=\"graph in google sheets 2\" width=\"743\" height=\"345\" data-src=\"https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-1200x557.jpg\" data-srcset=\"https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-1200x557.jpg 1200w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-300x139.jpg 300w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-768x357.jpg 768w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-16x7.jpg 16w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-32x15.jpg 32w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-28x13.jpg 28w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-56x26.jpg 56w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-64x30.jpg 64w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-1000x464.jpg 1000w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-431x200.jpg 431w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2-675x314.jpg 675w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-2.jpg 1309w\" data-sizes=\"(max-width: 1200px) 100vw, 1200px\" data-attachment-id=\"1126842\" \/><\/p>\n<p>3. You&rsquo;ll probably notice that Google Sheets defaults to a stacked column chart. It&rsquo;s not perfect for everyone, but now we&rsquo;ll dig into the&nbsp;<strong>Chart Editor<\/strong>&nbsp;(at right) to get everything just right.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-1126843 noname aa-img lazyloaded\" title=\"graph in google sheets 3\" src=\"https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-1200x560.jpg\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" srcset=\"https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-1200x560.jpg 1200w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-300x140.jpg 300w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-768x358.jpg 768w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-16x7.jpg 16w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-32x15.jpg 32w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-28x13.jpg 28w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-56x26.jpg 56w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-64x30.jpg 64w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-1000x467.jpg 1000w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-429x200.jpg 429w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-675x315.jpg 675w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3.jpg 1307w\" alt=\"graph in google sheets 3\" width=\"733\" height=\"342\" data-src=\"https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-1200x560.jpg\" data-srcset=\"https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-1200x560.jpg 1200w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-300x140.jpg 300w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-768x358.jpg 768w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-16x7.jpg 16w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-32x15.jpg 32w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-28x13.jpg 28w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-56x26.jpg 56w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-64x30.jpg 64w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-1000x467.jpg 1000w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-429x200.jpg 429w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3-675x315.jpg 675w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-3.jpg 1307w\" data-sizes=\"(max-width: 1200px) 100vw, 1200px\" data-attachment-id=\"1126843\" \/><\/p>\n<ul>\n<li>Creating a pie chart in Google Sheets is best for percentage data. However, it doesn&rsquo;t work as well across multiple time periods.<\/li>\n<li>Creating a bar chart in Google Sheets is best for frequency data. It would work in this case, but it would be complicated based on how much data we have.<\/li>\n<\/ul>\n<p>4. The first setting we&rsquo;ll change is to choose a&nbsp;<strong>Line Chart<\/strong>. This helps us to illustrate the rise and fall of each manufacturer&rsquo;s market share by quarter. Google will actually give recommendations for chart types based on your data input.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-1126844 noname aa-img lazyloaded\" title=\"graph in google sheets 4\" src=\"https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-1200x558.jpg\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" srcset=\"https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-1200x558.jpg 1200w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-300x140.jpg 300w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-768x357.jpg 768w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-16x7.jpg 16w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-32x15.jpg 32w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-28x13.jpg 28w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-56x26.jpg 56w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-64x30.jpg 64w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-1000x465.jpg 1000w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-430x200.jpg 430w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-675x314.jpg 675w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4.jpg 1309w\" alt=\"graph in google sheets 4\" width=\"738\" height=\"343\" data-src=\"https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-1200x558.jpg\" data-srcset=\"https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-1200x558.jpg 1200w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-300x140.jpg 300w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-768x357.jpg 768w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-16x7.jpg 16w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-32x15.jpg 32w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-28x13.jpg 28w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-56x26.jpg 56w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-64x30.jpg 64w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-1000x465.jpg 1000w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-430x200.jpg 430w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4-675x314.jpg 675w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-4.jpg 1309w\" data-sizes=\"(max-width: 1200px) 100vw, 1200px\" data-attachment-id=\"1126844\" \/><\/p>\n<p>5. Once you&rsquo;ve chosen your chart type, scroll down to check that the X-Axis and Series match the information you&rsquo;ve selected.<\/p>\n<p>6. The last step is to head to the&nbsp;<strong>Customize<\/strong>&nbsp;tab. This is where you can tinker with titles and legends as well as change the color scheme of your chart. You can also click on the title or legend in the chart to jump to the specific menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-1126845 noname aa-img lazyloaded\" title=\"graph in google sheets 5\" src=\"https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-1200x558.jpg\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" srcset=\"https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-1200x558.jpg 1200w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-300x140.jpg 300w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-768x357.jpg 768w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-16x7.jpg 16w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-32x15.jpg 32w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-28x13.jpg 28w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-56x26.jpg 56w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-64x30.jpg 64w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-1000x465.jpg 1000w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-430x200.jpg 430w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-675x314.jpg 675w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5.jpg 1307w\" alt=\"graph in google sheets 5\" width=\"735\" height=\"342\" data-src=\"https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-1200x558.jpg\" data-srcset=\"https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-1200x558.jpg 1200w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-300x140.jpg 300w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-768x357.jpg 768w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-16x7.jpg 16w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-32x15.jpg 32w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-28x13.jpg 28w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-56x26.jpg 56w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-64x30.jpg 64w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-1000x465.jpg 1000w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-430x200.jpg 430w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5-675x314.jpg 675w, https:\/\/cdn57.androidauthority.net\/wp-content\/uploads\/2020\/06\/graph-in-google-sheets-5.jpg 1307w\" data-sizes=\"(max-width: 1200px) 100vw, 1200px\" data-attachment-id=\"1126845\" \/><\/p>\n<p>Now that you know how to make a chart in Google Sheets, it&rsquo;s time to get out there and practice!<\/p>\n<p><strong>See also:&nbsp;<\/strong><a href=\"https:\/\/www.androidauthority.com\/best-office-apps-for-android-281250\/\">10 best office apps for Android to get work done!<\/a><\/p>\n<\/div>\n<\/div>\n<div id=\"comments-1126819\">&nbsp;<\/div>\n<div class=\"aa-lazy-comments-section\">&nbsp;<\/div>\n<p class=\"tags\">\n<div><strong>See Campaign: <\/strong><a href=\"https:\/\/www.androidauthority.com\/best-excel-apps-spreadsheet-apps-android-1122472\/\" target=\"_blank\">https:\/\/www.androidauthority.com\/best-excel-apps-spreadsheet-apps-android-1122472\/<\/a><br \/><b>Contact Information:<\/b><br \/>Ryan Haines<\/p>\n<p><b>Tags:<\/b><br \/><a href=\"\"><\/a>, <a href=\"https:\/\/icrowdnewswire.com\/category\/news-category\/wire\/\" rel=\"category tag\">Wire<\/a>, <a href=\"https:\/\/icrowdnewswire.com\/category\/global-regions\/united-states\/\" rel=\"category tag\">United States<\/a>, <a href=\"https:\/\/icrowdnewswire.com\/category\/language\/english\/\" rel=\"category tag\">English<\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"\" alt=\"image\" width=\"400\" height=\"300\" class=\"cwdfimg\" \/><\/div>\n<div>\n<h3>Contact Information:<\/h3>\n<p>Ryan Haines\n <\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" width=\"233\" height=\"24\" src=\"https:\/\/icrowdnewswire.com\/wp-content\/uploads\/2020\/06\/4001-logo-549.png\" alt=\"\">Google Sheets is a convenient alternative to&nbsp;Microsoft Excel. It offers many of the same functions in a cloud-based package. However, it can still be a challenge to read and understand large sheets of data. Here&rsquo;s how to make a graph in Google Sheets to simplify your information. See also:&nbsp;10 best Excel apps and spreadsheet apps &hellip; <a href=\"https:\/\/icrowdnewswire.com\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/\">Continue reading <span>How to make a graph in Google Sheets<\/span><\/a> <a href=\"https:\/\/ipsnews.net\/business\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/\" class=\"more-link\">Continue Reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":47,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,22,54],"tags":[],"class_list":["post-26064","post","type-post","status-publish","format-standard","hentry","category-english","category-united-states","category-wire"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to make a graph in Google Sheets - Business<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/ipsnews.net\/business\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to make a graph in Google Sheets - Business\" \/>\n<meta property=\"og:description\" content=\"Google Sheets is a convenient alternative to&nbsp;Microsoft Excel. It offers many of the same functions in a cloud-based package. However, it can still be a challenge to read and understand large sheets of data. Here&rsquo;s how to make a graph in Google Sheets to simplify your information. See also:&nbsp;10 best Excel apps and spreadsheet apps &hellip; Continue reading How to make a graph in Google Sheets Continue Reading &rarr;\" \/>\n<meta property=\"og:url\" content=\"http:\/\/ipsnews.net\/business\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Business\" \/>\n<meta property=\"article:published_time\" content=\"2020-06-16T15:50:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/icrowdnewswire.com\/wp-content\/uploads\/2020\/06\/4001-logo-549.png\" \/>\n<meta name=\"author\" content=\"Bilal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bilal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/ipsnews.net\/business\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/\",\"url\":\"http:\/\/ipsnews.net\/business\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/\",\"name\":\"How to make a graph in Google Sheets - Business\",\"isPartOf\":{\"@id\":\"https:\/\/ipsnews.net\/business\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/ipsnews.net\/business\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/#primaryimage\"},\"image\":{\"@id\":\"http:\/\/ipsnews.net\/business\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/icrowdnewswire.com\/wp-content\/uploads\/2020\/06\/4001-logo-549.png\",\"datePublished\":\"2020-06-16T15:50:00+00:00\",\"author\":{\"@id\":\"https:\/\/ipsnews.net\/business\/#\/schema\/person\/70b05bacee6cf8a877350412fae25e20\"},\"breadcrumb\":{\"@id\":\"http:\/\/ipsnews.net\/business\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/ipsnews.net\/business\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/ipsnews.net\/business\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/#primaryimage\",\"url\":\"https:\/\/icrowdnewswire.com\/wp-content\/uploads\/2020\/06\/4001-logo-549.png\",\"contentUrl\":\"https:\/\/icrowdnewswire.com\/wp-content\/uploads\/2020\/06\/4001-logo-549.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/ipsnews.net\/business\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ipsnews.net\/business\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to make a graph in Google Sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ipsnews.net\/business\/#website\",\"url\":\"https:\/\/ipsnews.net\/business\/\",\"name\":\"Business\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ipsnews.net\/business\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/ipsnews.net\/business\/#\/schema\/person\/70b05bacee6cf8a877350412fae25e20\",\"name\":\"Bilal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ipsnews.net\/business\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/01d05f3f41cc0f9ca88d2011a983bb3f2e83e3e92e3532188bf201df38d2aea8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/01d05f3f41cc0f9ca88d2011a983bb3f2e83e3e92e3532188bf201df38d2aea8?s=96&d=mm&r=g\",\"caption\":\"Bilal\"},\"sameAs\":[\"https:\/\/icrowdnewswire.com\/fc\"],\"url\":\"https:\/\/ipsnews.net\/business\/author\/bilal\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to make a graph in Google Sheets - Business","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/ipsnews.net\/business\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/","og_locale":"en_US","og_type":"article","og_title":"How to make a graph in Google Sheets - Business","og_description":"Google Sheets is a convenient alternative to&nbsp;Microsoft Excel. It offers many of the same functions in a cloud-based package. However, it can still be a challenge to read and understand large sheets of data. Here&rsquo;s how to make a graph in Google Sheets to simplify your information. See also:&nbsp;10 best Excel apps and spreadsheet apps &hellip; Continue reading How to make a graph in Google Sheets Continue Reading &rarr;","og_url":"http:\/\/ipsnews.net\/business\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/","og_site_name":"Business","article_published_time":"2020-06-16T15:50:00+00:00","og_image":[{"url":"https:\/\/icrowdnewswire.com\/wp-content\/uploads\/2020\/06\/4001-logo-549.png","type":"","width":"","height":""}],"author":"Bilal","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bilal","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/ipsnews.net\/business\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/","url":"http:\/\/ipsnews.net\/business\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/","name":"How to make a graph in Google Sheets - Business","isPartOf":{"@id":"https:\/\/ipsnews.net\/business\/#website"},"primaryImageOfPage":{"@id":"http:\/\/ipsnews.net\/business\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/#primaryimage"},"image":{"@id":"http:\/\/ipsnews.net\/business\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/#primaryimage"},"thumbnailUrl":"https:\/\/icrowdnewswire.com\/wp-content\/uploads\/2020\/06\/4001-logo-549.png","datePublished":"2020-06-16T15:50:00+00:00","author":{"@id":"https:\/\/ipsnews.net\/business\/#\/schema\/person\/70b05bacee6cf8a877350412fae25e20"},"breadcrumb":{"@id":"http:\/\/ipsnews.net\/business\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/ipsnews.net\/business\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/ipsnews.net\/business\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/#primaryimage","url":"https:\/\/icrowdnewswire.com\/wp-content\/uploads\/2020\/06\/4001-logo-549.png","contentUrl":"https:\/\/icrowdnewswire.com\/wp-content\/uploads\/2020\/06\/4001-logo-549.png"},{"@type":"BreadcrumbList","@id":"http:\/\/ipsnews.net\/business\/2020\/06\/16\/how-to-make-a-graph-in-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ipsnews.net\/business\/"},{"@type":"ListItem","position":2,"name":"How to make a graph in Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/ipsnews.net\/business\/#website","url":"https:\/\/ipsnews.net\/business\/","name":"Business","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ipsnews.net\/business\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ipsnews.net\/business\/#\/schema\/person\/70b05bacee6cf8a877350412fae25e20","name":"Bilal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ipsnews.net\/business\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/01d05f3f41cc0f9ca88d2011a983bb3f2e83e3e92e3532188bf201df38d2aea8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/01d05f3f41cc0f9ca88d2011a983bb3f2e83e3e92e3532188bf201df38d2aea8?s=96&d=mm&r=g","caption":"Bilal"},"sameAs":["https:\/\/icrowdnewswire.com\/fc"],"url":"https:\/\/ipsnews.net\/business\/author\/bilal\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ipsnews.net\/business\/wp-json\/wp\/v2\/posts\/26064","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ipsnews.net\/business\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ipsnews.net\/business\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ipsnews.net\/business\/wp-json\/wp\/v2\/users\/47"}],"replies":[{"embeddable":true,"href":"https:\/\/ipsnews.net\/business\/wp-json\/wp\/v2\/comments?post=26064"}],"version-history":[{"count":1,"href":"https:\/\/ipsnews.net\/business\/wp-json\/wp\/v2\/posts\/26064\/revisions"}],"predecessor-version":[{"id":26065,"href":"https:\/\/ipsnews.net\/business\/wp-json\/wp\/v2\/posts\/26064\/revisions\/26065"}],"wp:attachment":[{"href":"https:\/\/ipsnews.net\/business\/wp-json\/wp\/v2\/media?parent=26064"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ipsnews.net\/business\/wp-json\/wp\/v2\/categories?post=26064"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ipsnews.net\/business\/wp-json\/wp\/v2\/tags?post=26064"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}